How to create a report that could show multiple levels of the Data Center table records and their relationships in the hierarchy.

[jb2291]

We recently started to use the CMDB data center tables out of box creating a few levels with parent child relationship so they graphical view accurately represents the hierarchy.  The asset management team is intersted in taking the graphical view to turn it into a report list view that shows hierarchy as columns in the report:

Data Center Name | Computer Room Name | Zone Name | Rack Name | Configuration Item

-----------------------------------------------------------------------------------------------------------------------------

These columns do not exist as attributes on these Data center tables but are in the relationship table.

The column names would repeat for each CI that is in the same Rack for instance.

Is this possible in ServiceNow?  Would this type of report that converts a graphical showing relationships between CIs into a list view be beneficial for many kinds of service reporting?

Thanks

Jon Beck

[sachin_namjoshi]

You will have to create database view to join different tables based on join criteria.

You can then report on this database view.

Regards,

Sachin