Aggregated users count charged under IRM licensing are not getting reflected on GRC licensing summary dashboard. - Known Error

Aggregated users count charged under IRM licensing are not getting reflected on GRC licensing summary dashboard. Description 1) The job has to run in the starting of April to view the March data to be populated in the graph, as we are considering the accrual period to be (gs.beginningOfLastMonth()). 2) Aggregation date is expected to be populated with last date of the previous month, according to the script "LicenseHelperUtils" and function "CreateUsageAggregate" , we are trying to populate using "gs.endOfLastMonth()"

In the customer's instance, we have noticed that until february, both accrual period and the aggregation date used to be of the same month, i.e., accrual period - 2025 - 02 & aggregation_date - 2025 - 02 -01, because of which graph used to be fine. But when we ran in April - the count was populated in the table "sn_irm_shared_cmn_aggregated_usage_count" for the accrual period "2025 - 03 but the aggregation date is populated as "2025 - 04 -01", because of which we suspect the data in the graph is showing as 0 for the month March.

Steps to Reproduce

1. Search for and navigate to the "Licensing summary dashboard" in the filter navigator 2. In the usage analysis trend graph, change the filter to Last 3 months. 3. Observe that no data appears for March

Upon re-running the job the data was the March usage data was showing for April (according to the graph)

Workaround Description Showing invalid licensing count on licensing summary dashboard.

Note: This issue might occur if system time zone does not match UTC

Steps to Reproduce

1. All -> sn_irm_shared_cmn_aggregated_usage_count.

2. The accrual period and aggregation date should be the same month.

In the upcoming version 21.x, the issue will be fixed.

or

Please import the update set attached to the problem.

And also to update existing data, a script is required. The customer needs to create a fix script under the GRC: Risk Share Common Components scope and request that they run the script in the background.

var gr = new GlideRecord("sn_irm_shared_cmn_aggregated_usage_count"); gr.query(); while (gr.next()) {

var accuralPeriod = gr.getValue('accrual_period'); var license = gr.getValue('licensable_application_family'); var glideDate = new GlideDateTime(accuralPeriod + "-01"); var count = 0; var usageGr = new GlideAggregate("sn_irm_shared_cmn_unique_user_usage"); usageGr.addQuery("licensable_application_family", license); usageGr.addQuery("accrual_period", accuralPeriod); usageGr.addAggregate("COUNT"); usageGr.query();

if (usageGr.next()) { count = usageGr.getAggregate("COUNT"); } gr.setValue('usage_count',count); gr.setValue('aggregation_date',glideDate.getDate()); gr.setWorkflow(false); gr.update(); }