ServiceNow SAM: Report on Software Installations to get the Software Lifecycle phase

rahulyamgar
Tera Guru

Hello friends,

 

We have custom discovery tool populating the software installed data in "cmdb_sam_sw_install" table which in turn creates/re-uses the Software Discovery Models which are further normalized. We would like to build report to show the particular business units Software Installed along with their lifecycle phase information. How do I navigate to the lifecycle phase table from the software installations table. Any help is highly appreciated.

 

Thanks,
Rahul 

2 REPLIES 2

Nagaraju D
Tera Contributor

Did you get solution?

rahulyamgar
Tera Guru

No. I did not find the exact solution. But from the Discovery Model we should be able to navigate to the normalized model details and from there we should be able to get the lifecycle information. I got this implemented as "POC", but due to the immense number of records in software installations table, got this solution little bit not feasible. Per computer CI, there are 100s of software installations. So data gets huge if we track from Computer-> Software Installations-> Discovery Maps-> Normalized Models->Lifecycle Data. We are yet  to make decision on the same.

 

Thanks,
Rahul