Create report showing CI Relations

[LarryBlakely]

I need to do a report from the Business Application down to lower level CI Relations:

Business Application
     Application Service
          Environment
               Server(s)
          Servers(s)
          Components(s)
          etc

I can't seem to grasp how to structure the query to return the environment/server level grouped by class(es) above it.

Any and all tips are appreciated.

[sachin_namjoshi]

You can report on cmdb_rel_ci table to find out all upstream and downstream relationships.

Regards,

SAchin

[LarryBlakely]

I assumed as much but I can't seem to grasp how to structure the query.

Are there training materials specifically for this table. For me, it's a bit odd compared to others.