
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
The database view below shows what computers have software that are end of life along with additional location information. The out of box lifecycle report doesn't list out the individual computers that this does providing an extra layer of filtering. This report will likely get added in the coming release, but wanted to share.
End State Report - Screenshot 1
Steps
- Navigate to System Definition >Database Views > New
- Input Name and Save
- Create the following tables, fields, and where clauses
Tables |
Fields |
Order |
Prefix |
Where |
sam_sw_product_lifecycle |
start_date, publisher, norm_version, norm_product, norm_edition, lifecycle_phase |
100 |
spl |
|
cmdb_sam_sw_discovery_model |
primary_key, |
200 |
sdm |
sdm_norm_publisher=spl_publisher && sdm_norm_product=spl_norm_product && sdm_norm_version=spl_norm_version |
cmdb_sam_sw_install |
primary_key, |
300 |
si |
si_primary_key = sdm_primary_key |
cmdb_ci_computer |
sys_id, |
400 |
scomp |
scomp_sys_id=si_installed_on |
End Database Result - Screenshot 2
Shoutout to
- 2,824 Views
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.