Loading...
Loading...
Subscription overview dashboard shows no usage for "Software Asset Management - Computer v2".
Subscription overview dashboard shows no usage for "Software Asset Management - Computer v2". Root cause: Subscription Management Dashboard takes the information about the usage from UsageAnalytics Count table. This table is populated on execution of definition DEFN1000843 which is not executed after upgrade to Tokyo release where the PRB1555098 fix is available. The existing definition is changed from script based to table based. LUA jobs have different jobs for script definition vs table definition from Tokyo release. So, for upgrading customers, where the instance has already seen the definition as script based, its incompatible now for them and usage analytics count is not populated for Software Asset Management - Computer v2. Workaround 1. Modify the definition DEFN1000843 from table based to script based with below changes. Remove the query conditions. Change the name of the definition to SAMHardwareNodes Add following code in the script answer = getSAMServerAndClientNodes(); function getSAMServerAndClientNodes() { var itamLicGr = new GlideAggregate('itam_licensing_resource_counts'); itamLicGr.addQuery('is_aggregated','true'); itamLicGr.addQuery('resource_category',['servers','end_user_computers']); itamLicGr.addQuery('application','Software Asset Management'); itamLicGr.setGroup(false); itamLicGr.addAggregate('SUM', 'resource_count'); itamLicGr.query(); if (itamLicGr.next()) { return itamLicGr.getAggregate('SUM', 'resource_count'); } else { return 0; } } After the change definition looks as below: 2. Run the scheduled job - 'UA Scripted Definitions Sync Job' to sync the definition to UA scripted definition. After the job execution, verify record exists in the table 'ua_scripted_defn' for definition_id=DEFN1000843. 3. Wait for a day for the definition to be executed automatically and populate the usage on the Subscription overview dashboard for "Software Asset Management - Computer v2".
PRB1629665
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.