Report to show all relationship mapping?

[stevenwatts]

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

[stevenwatts]

Hi Ashutosh,

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,

[Ashutosh Munot1]

Hi Steve,

Yes this makes sense.

So now you have to go with Database views. Because here you can join multiple tables together and create a full fletch report.

If i get time i will surely create one for you.

Regards,Please mark Helpful if it makes sense

[stevenwatts]

Thanks Ashutosh,

If you do get chance to create one please could you upload into this forum, sure it would be useful for lots of people in the community.

Regards

[Shruti47]

Hi Ashutosh

Could you please help in this report creation. Unable to understand how we can create this report using database views. 

Why do I need to join two tables as all the required information is in cmdb_rel_ci. I need to go down and down in that table only.

Any help in the creation of this report would be much appreciated.

[Fathima6]

Can you please send that sample view?