User License Type - some data mining
Published Friday, January 22, 2021
Ever wonder, how can we gather all the different license types that can be mapped for CRM system user. This Stack Overflow question made me to dig that rabbit hole and found out lot of interesting things.
The license type enumerators were stored in stringmap table and I was able to pull out a FetchXML query for the same.
<fetch>
<entity name="stringmap" >
<attribute name="attributevalue" />
<attribute name="attributename" />
<attribute name="value" />
<filter type="and" >
<condition attribute="objecttypecode" operator="eq" value="8" />
<filter type="and" >
<condition attribute="attributename" operator="eq" value="caltype" />
</filter>
</filter>
</entity>
</fetch>Even I have created a github issue asking to update the license types in documentation. But it was closed by communicated that this will change very frequently and MS PG team didn’t want to document it :)
By the way - there are few great responses from community stating other different approaches to achieve it, in that github issue.
Continue to website...
