Reporting on CMDB relationships

[kwi]

We have relationships established in our CMDB between Application Instance CIs and the Server CIs that host the instances.   And we would like a list of all the Application Instances showing the servers for that instance (see below).   What's the best approach to a solution for this?

Applications	Servers
Application Alpha Production	Server1
	Server2
	Server3
	Server4
Application Alpha Test	Server5
	Server6
	Server7
Application Alpha Dev	Server8
	Server9
	Server10
Application Beta Production	Server11
	Server12
	Server13
Application Beta Test	Server14
	Server15
	Server16
Application Beta Dev	Server17
	Server18
	Server19

[Harish KM · Accepted solution]

You can Join two tables with help of database view .

http://wiki.servicenow.com/index.php?title=Database_Views

Database Views for CMDB Reports

[millerdave]

Or if you are not familiar with Joins one can report on cmdb_ci_rel selecting the relationship type(s) and/or parent/child fields straight from the reporting module.

[Harish KM]

I Did not know that..