Report on cmdb_ci_service to see all child items under it.

[Doraemon]

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. 

[palanikumar · Accepted solution]

Hi,

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

[Doraemon]

Hi , Thank you for the response. Can i show all the servers listed under the service from this table? 
I can see server count but how to show server and their attributes?

[palanikumar]

Hi,

This table has Server Name in Configuration Item Id field. 

[Doraemon]

Can you please share a screenshot of it in the report fields ? i am unable to find it
Appreciate your help