Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Relationships

Highlighted
kcarson
Regular Collector

Relationships

SD4.5 SP20
How can I create a view, SQL query or Crystal Report that shows the relationships of CIs?
i.e. A related to B B Related to C so C related to A
Our Server people want to be able to see what Application is effected on what server but we only relate the aerver to the database and the database to the application.
Thanks in advance.
What is your process?
3 REPLIES
Sam decosta
Esteemed Contributor

Re: Relationships

Hi Kcarson,

You can get all the relations between CIs in itsm_ci_relations table.

Thanks,
Avinash
kcarson
Regular Collector

Re: Relationships

Yes but I was looking for a easy way to link then in a view or report.
What is your process?
The Pike
Honored Contributor

Re: Relationships

Have you considered the '(Re)Generate Views for Reporting' utility?

That creates user-friendly (sort of) database views...

The Pike
//Add this to "OnDomLoad" event