User view, Disabled users consuming licenses

You might have seen the view, Disabled users consuming licenses for users and wondered what it means. In CRM on-premise a disabled user does not require a license so what is the view showing.

If you look at the definition of the view in Advanced Find you see an error because Advanced Find can't show the query. Delving in the database, shows that the FetchXML for the query is:

<fetch version="1.0" output-format="xml-platform" mapping="logical">
<entity name="systemuser">
<order attribute="fullname" descending="false" />
<attribute name="fullname" />
<attribute name="systemuserid" />
<attribute name="businessunitid" />
<attribute name="internalemailaddress" />
<filter type="and">
<condition attribute="fullname" operator="ne" value="SYSTEM" />
<condition attribute="fullname" operator="ne" value="INTEGRATION" />
<condition attribute="isdisabled" operator="eq" value="1" />
<condition attribute="islicensed" operator="eq" value="1" />
</filter>
</entity>
</fetch>

The interesting attribute is islicensed. I think this field is only set when using CRM Online for users who have been allocated a license in the Online platform. So the view is showing users who have been disabled in CRM but are still allocated a license in the Online platform. So, really if you see any users in this view you are spending money unnecessarily!

CRM Topics: 
CRM Versions: