Report to show all relationship mapping?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2018 05:23 AM
Hi Steven,
Did you try looking or reporting on cmdb_rel_ci table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-05-2022 07:53 AM
Hi
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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