Report on Software Product End of Life or End of Service

Neil15
Giga Contributor

Currently we have a report for "Software Model Lifecycle Report" which reports the EOL for the Softwares which have defined software model.

Is there any way to list out all products from ServiceNow software content library and show the EOL/EOS for these. Defining Software model for each of the discovered installs is a tedious job which is our next phase.

1 ACCEPTED SOLUTION

Hardik Benani
Mega Sage
Mega Sage

This is already answered in seperate post but reporting here to ensure it helps others.

So below is the solution that should work.

Create a base view with four tables as below. As the data resides in three different tables you will need to add them to the view and then add relevant conditions.

1. cmdb_sam_sw_discovery_model

2. cmdb_sam_sw_install (csam_discovery_model=samlm_sys_id)

3. samp_sw_entitlement_definition (dmap_sw_product=samlm_norm_product && dmap_version=samlm_norm_version)

4. samp_lifecycle_definition (saml_entitlement_definition=dmap_sys_id) 

 

 

 

This should now give you a single report where you can report on softwares installed on a computer and EOL dates based on DMAP and Lifecycle. 

Note: We can only match base on Product and Version. If you need the exact match you would need to write a script to put them all into a seperate table and this requires a bit of work. It would be good to create an idea on idea portal soo ServiceNow can add this to the required functionality. 

View solution in original post

9 REPLIES 9

akash_mehta
ServiceNow Employee
ServiceNow Employee

Neil:  Not sure I understand your question...but could you run a report against the sam_sw_model_lifecycle table and group by the software model.product field?  Not sure that is what you are looking for...

 

-Akash

Jeff Barratt
Kilo Guru

There is no report for this, but all the content is in the samp_lifecycle_definition table. You could dot-walk the DMAP to get the Publisher and Product.

Please let me know if I understood your request correctly.

Neil15
Giga Contributor

So my aim is to get a report of all software with their end of life details. 

e.g. I have a VM with related list of SW which comes from "cmdb_sam_sw_install" table. 

Need a single report with all details in same report or view.

Hardik Benani
Mega Sage
Mega Sage

This is already answered in seperate post but reporting here to ensure it helps others.

So below is the solution that should work.

Create a base view with four tables as below. As the data resides in three different tables you will need to add them to the view and then add relevant conditions.

1. cmdb_sam_sw_discovery_model

2. cmdb_sam_sw_install (csam_discovery_model=samlm_sys_id)

3. samp_sw_entitlement_definition (dmap_sw_product=samlm_norm_product && dmap_version=samlm_norm_version)

4. samp_lifecycle_definition (saml_entitlement_definition=dmap_sys_id) 

 

 

 

This should now give you a single report where you can report on softwares installed on a computer and EOL dates based on DMAP and Lifecycle. 

Note: We can only match base on Product and Version. If you need the exact match you would need to write a script to put them all into a seperate table and this requires a bit of work. It would be good to create an idea on idea portal soo ServiceNow can add this to the required functionality.