Creating inactive users report who are consuming software licenses

[iamkurt]

For every publisher, product and model, I need to create license usage reports for comparisons of active software licences with inactive or dormant accounts and ensure unused software licences or licences assigned to former employees or employees on long-term leave are disabled or re-assigned in a timely manner.

I found this playbook → https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0999382

And I have imported the XML file provided here. It basically runs on alm_entitlement table, checks for users are the are active, and groups by entitlements.

However, I am confused about how to show it for every publisher, product and model

1. The XML file from the playbook gives models. So product and publisher should be self-explanatory when you read the model name. Is there something ore I should do to show the publisher and product name separately?
   
   
2. cmdb_sam_sw_instal or cmdb_sam_sw_discovery_model – is there something I need to be picking up from this table?

1. Another way is via cmdb_ci_computer table. There is a “Software Installations” tab in the related links section on this table. I am wondering if there is any way to leverage this.
   
   
2. Once all this is done, I need to create a job that will ID unused licenses from the dashboards above and create a task for a specific team to look after the license. How can I create that?

[dreinhardt]

Hi @iamkurt,

the report type is limited to only one "Group by", same as for list views. I would suggest to add the columns "Publisher, Product, Software Model" and group by "Publisher" - this should help and is a bit more transparent

With the FlowDesigner you should be able to build a low-code flow to create tasks for the teams

Best, Dennis

[AnaMariaL]

Hi, did you manage a way to get a list of dormant accounts please? I am interested to get an EMEA list of dormant accounts. Thank you