Report on cmdb_ci_service to see all child items under it.

Doraemon
Tera Contributor

I want to create a report where i want to see a particular business service and list all the service offering , service_discovered in  relationship , and all the servers which belong to that service discovered.

I want to create a dashboard , if user selects a business service it should list all the above mentioned items.

Please guide how to achieve this. 

1 ACCEPTED SOLUTION

palanikumar
Mega Sage

Hi,

You can create report from svc_ci_assoc table. Add condition to check if Service Id is same as the business Service

Thank you,
Palani

View solution in original post

6 REPLIES 6

CasperJT
Tera Guru

You could consider using the CMDB Query Builder. It allows you to build a list report using a visual layout.

CasperJT_1-1730105398658.png

 

You can include attributes from each of the classes and present them in list form.

 

Hope this helps,

//Casper

Thanks , What type of relationship should i add to each node?