How to create a report listing all CIs used for multiple mapped application services

[Jim O_Shea]

I'm new to service mapping and find it hugely useful.  I see how to obtain a list of CIs associated with an application service by choosing the "List CIs" Related Link on the Mapped Application Service form.  But how can I build a report to pull a comprehensive list of all CIs for Operational Application Services?  

Thanks!

[Rahul Priyadars]

You need to do some kind of scripting for this.

Read 1...n Active Application Services CI 

Loop 1 to N Application Services

    Look for Relationships in CMDB_REL_CI table {

          Where Parent or Child CI is -Application Service CI

          push Given Record in a Staging Table

                                                                        }

Once Data is populated in Staging table you can easily fetch the required Cis u are looking for

Regards

RP

[Jim O_Shea]

Thanks Rahul - 

What about the svc_ci_assoc table?  I just ran across this in my investigation and it looks like it might be the silver bullet I'm needing without having to implement scripting (which I admittedly am not good with yet).

Thanks,
Jim