Licence numbers and usage data - left join?

[hannahhawkins02]

Does anyone have a simple way of comparing the number of licenced users in a product to the data usage for those users? Currently I'm searching the data usage for my product and then searching the user name who is utilising a licence. There must be an easier way of doing this that I'm missing?

[Maik Skoddow · Accepted solution]

Hi @hannahhawkins02 

I'm not sure whether I get your point. In case you are asking for the ServiceNow product licenses like ITSM, CSM or FSM then there is not such a view OOTB as the underlying topic is too complex. The table which has the closest data you are looking for is ua_app_usage:

Apart from this, I recommend making familiar with the topic and how to assign users to certain licenses. You can all required resource on my page: Subscription Management & Licensing

Maik