Report to show all relationship mapping?

stevenwatts
Giga Contributor

‎01-19-2018 04:49 AM

Hi,

Is it possible to create a report which details ALL relationships that a CI might have both upstream and downstream. Essentially something similar to the relationship mapping?

Was thinking a database view might work but not sure where to start.

Regards,

Steven

0 Helpfuls
  • 5,703 Views
16 REPLIES 16

Jaspal Singh
Mega Patron
Mega Patron

‎01-19-2018 05:23 AM

Hi Steven,



Did you try looking or reporting on cmdb_rel_ci table.


0 Helpfuls

stevenwatts
Giga Contributor
In response to Jaspal Singh

‎01-19-2018 06:14 AM

Hi Jaspal,



Thanks for responding. That table only gives us parent and child what we are looking for is a report which gives us all relationships, as an example:



GRANDPARENT - PARENT - CI - CHILD - GRANCHILD, rather than



PARENT - CI - CHILD.



Hope that makes sense?



Regards,


0 Helpfuls

Shree14
Tera Contributor
In response to stevenwatts

‎09-05-2022 07:53 AM

Hi @stevenwatts ,

We have a similar Requirement for creating Report on Related CIs.

Did you find any workaround to achieve this, Kindly let us know how could we achieve this.

 

Thanks,

Shree

0 Helpfuls

Ashutosh Munot1
Kilo Patron
Kilo Patron

‎01-19-2018 05:28 AM

HI Steven,



Recently we have just built a report which gives us parent as well as child of a particular CI.



We have used CI Relationship Table i.e. cmdb_rel_ci.



Thank you


0 Helpfuls