Report showing CI lineage (cmdb_rel_ci)

[ILYA STEIN]

I need to create a report that shows lineage of servers in the company, up to a specified level. For an example, if servers run application services that belong to a business application, I want to be able to show the servers, the application services, and the business application as columns in the report. I don't have any requirements as to what type of report this is, as long as I am able to traverse the lineage for a given server, up to a certain level (minimum the server->service->application hierarchy).
I know all these relationships can be found in the cmdb_rel_ci table, but can't figure out how to traverse its recursive parent/child relationships in a single report.

[Dr Atul G- LNG]

Hi @ILYA STEIN 

If I understand correctly, you can create a single report with multiple datasets, and for each dataset, you can define a set of relationships that link a server and a service.

https://www.servicenow.com/docs/bundle/yokohama-now-intelligence/page/use/reporting/concept/c_Multip...