- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā07-21-2020 06:11 PM
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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā01-11-2021 04:24 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-04-2020 06:36 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-05-2020 07:26 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā12-13-2020 04:36 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā01-11-2021 04:24 PM
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.