Use Case:
The subscription overview provides insights into the license consumption across different ServiceNow modules. In the event that this feature is not functioning, what alternative methods can be employed to address the situation?
Description:
In the absence of the subscription overview, what underlying functionalities can assist in determining the extent of license utilization and the specific query conditions employed to analyze this consumption? To illustrate this scenario, I will focus on the HRSD license, detailing its consumption and the queries utilized for analysis.
Solution:
The following 3 tables listed below facilitate the comprehension of license usage:
a. usageanalytics_count_cfg
b. ua_stats_defn
c. usageanalytics_count
Utilize these tables to ascertain the license count for each module. For instance, in the case of HRSD, the license is determined using the following query:
HR Profile - License Calculation <<Change the instance name in this URL>>
To gain further insights into each module, it is essential to understand the 'DEFINITION ID,' which varies across different ServiceNow modules. Scheduled jobs are operating behind these tables, running daily to provide results.ServiceNow offers the following article for a more detailed understanding of each product's 'DEFINITION ID':
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727967
It is important to implement the following steps directly within the production environment and to confirm the outcomes. I have authored an article titled 'Subscription Management' that discusses the out-of-the-box support.
Regards,
Suresh.
