Manual software usage import

[hugh5]

Is there a simple way to import software usage totals for creating a manual software compliance position? For example - can I create a spreadsheet with a list of Software products/models and the usage number and import that on a monthly basis into a table that would then be used during reconciliation? This is for products where I know the number of installs but do not want to use the count of installs on devices. Thanks. 

[Tarun24]

Are you referring to import data into Usage table (samp_sw_usage)?
If so, please use the Easy import feature which helps import data to a table from spreadsheet. Please use the below link for more information:

https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/import-sets/concept/c_EasyImport.html

[Christina Guidr]

I understand what you are asking hugh5 - we have lots of software with custom metrics that can't be seen and counted by ServiceNow but we have automated reports from the systems providing usage.  We want a place where we can load that usage so it calculates against our entitlements.  During implementation we had raised this question and ServiceNow told us to use this table: samp_sw_client_access.  However, it only works if you entitlement matches the 6 available in this table (i.e. you would have to change your metric on your entitlement from Custom Thing to Per Device CAL) or it will not calculate - this is not sustainable.  The other option is to assign it direct in the entitlement but this is also not sustainable because you cannot allocate more than the purchased rights on the entitlement record.

[dimitrisala]

Hi,

Did you manage to find a solution for this? We are in a similar position with many software products that require custom metrics that cannot be discovered.

[Christina Guidr]

Hi - I think the Utah release came with a new table samp_sw_resource_value where you can put custom usage that cannot be discovered - your entitlement should be of Common - Resource Consumption (that tells it to look in this table).  The name of the entry is the name of the metric (Per Environment, Per Session, Per User, etc) and then enter the usage.  This will calculate in reconciliation.  If there is a usage you get that then requires a calculation you can go farther and create a custom metric that points to Resource Value instead of Installs and it will take the # from the resource value table and you can script whatever calculation is needed.  The only downside I did not like is not seeing on the entitlement what the metric was so our team coded it to pull the name from the resource value table as a display field in the entitlement table so we can see it there and not need a report dot walking to see it.