Create report on cmdb_ci_service to list all the 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. 

[Tsura Andreeva]

One suggestion I have is to create a report from the cmdb_ci table where operational status is operational, then create the interactive filter on the business service, so when people use your dashboard and select the business service, the report from the cmdb_ci will display the configuration items for that BU.