The CreatorCon Call for Content is officially open! Get started here.

Alex Panzarella
ServiceNow Employee
ServiceNow Employee

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

find_real_file.png

Steps

  1. Navigate to System Definition >Database Views > New
  2. Input Name and Save
  3. 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,
norm_version,
norm_publisher,
norm_product,
norm_edition,

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,
installed_on

300

si

 si_primary_key = sdm_primary_key

 cmdb_ci_computer

sys_id,
location,
company,

400

scomp

 scomp_sys_id=si_installed_on

End Database Result - Screenshot 2

find_real_file.png

Shoutout to @Brad Bowman for the information on setting up the hard table join.

8 Comments