What is the ITAM CI Usages (itam_ci_usage) table used for?

Go to solution
Claire Ashdown2
Mega Guru

‎08-10-2022 08:15 AM

What is the ITAM CI Usages (itam_ci_usage) table used for? I see that it is populated by the SAM/CI - Populate Licensing Data scheduled job that uses the SAMLicensingUtility script include, but the job seems to cause serious performance issues. What is the table used for (License Workbench? Reclamation workflow? Something else?)? Could this job be run weekly instead of daily?

0 Helpfuls
  • 965 Views
1 ACCEPTED SOLUTION

Go to solution
Daniel Slocum
ServiceNow Employee
ServiceNow Employee

‎08-16-2022 03:21 PM

Hi Claire,

The table and daily job collect and store data used in identifying a customer's consumption of their ServiceNow ITAM product subscriptions.  The query looks for CI's meeting certain discovery criteria over the last 90 days. 

I'm not sure what ServiceNow release your organization is currently utilizing. If it is San Diego P4 or lower, you should expect to see improvements when you move to San Diego P5 or higher. 

Here is a bit of documentation on the topic.

View solution in original post

1 REPLY 1

Go to solution
Daniel Slocum
ServiceNow Employee
ServiceNow Employee

‎08-16-2022 03:21 PM

Hi Claire,

The table and daily job collect and store data used in identifying a customer's consumption of their ServiceNow ITAM product subscriptions.  The query looks for CI's meeting certain discovery criteria over the last 90 days. 

I'm not sure what ServiceNow release your organization is currently utilizing. If it is San Diego P4 or lower, you should expect to see improvements when you move to San Diego P5 or higher. 

Here is a bit of documentation on the topic.