Config Management - Service Maps with Retired CIs Report

[B Y1]

Hi Team, 

I would like a report listing Service Maps which contain a retired CI so that we can review the Service Map.

I'm new to CMDB, not understanding where to start to create this report. 

Thanks 

Bhanu

[PeterH2]

Hi Bhanu,
Off the top of my head, I'd start with the Service Configuration Item Association [svc_ci_assoc] table and configure the list layout in a new view (in my case PeterH) to show the Configuration Item.Operational Status and Configuration Item.Status like this:

Then filtering your list for only Retired CI's like this...

To get a list like this:

You now have the data which you can convert into a report if desired.

I hope that helps.

Regards,

Peter