Software Lifecycle Reporting for Software Installation

[jmayger]

Hi All,

Currently facing a challenge whereby the customer wants to report on "End of Life" Software models specifically where the installation 'installed_on' is not retired. Seems simple enough, where we run into issues however, is the duplication of data from the 'sam_sw_product_lifecycle' table. 

I have configured the attached Database View that I am reporting on to do the filtering for installed_on.install_status and Risk Score. We are matching the Software Installation with the corresponding Product Lifecycle based on 'norm_product' and 'norm_full_version' 

The join on 'cmdb_sam_sw_discovery_model' was because we are receiving duplicates from the different editions stored in the 'sam_sw_product_lifecycle' table (See attached). Meaning that we are over reporting on the issue.  I have tried matching on Discovery Model edition and Software Product Lifecycle Edition, however the values are different between the tables or the edition value is simply empty, which the database view wont match on.

Has anyone been able to solve this, we want to report on the installation level so the 'End of Life Products' widget on the Software Asset Workspace doesn't suit this purpose.

[dreinhardt]

Hi @jmayger ,

The business rule "Remove Installs For Retired/Stolen CI" is responsible for this. To „re-trigger“ the rule, identify all retired CI with linked install records and search/filter these devices in cmdb ci computer/server table. Perform a multi row selection for the install_status field an change it to any non-critical status and after this, back to Retired and this should trigger the script again.

Best, Dennis