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

[Shree14]

Hi @Ashutosh Munot 

We have the same requirement of Creating Relationship Report which @stevenwatts has mentioned in this thread. 

Do you have any sample Reports for this. If so, can you please share the one here or any approach to achieve this??

Thanks,

Shree

[Cat at Cap1]

gyedwab, would you care to share the details of this report? Does is show just the immediate child, or ALL relationships downstream?

Thanks,

Cat

[gyedwab]

Hi Cat,

You can see the details below, including a video at the end of the post. It does show *all* children, regardless of how far downstream the CI is.

[gyedwab]

If you want to get this report without making changes to the database, you can use Explore Analytics.

First, you create a list report, using the Explore Analytics filter 'sys_id is upstream from [the CI you want to query on]':

I created a calculated field called 'Direction' using a formula builder that just says 'Upstream', so we can tell what direction it is later:

Then, I created a second report filtered on 'sys_id is downstream from [the CI you want to query on]', and updated the calculated field:

Next, I created a new 'mash-up' view that combines the two reports, and I get one list report with both the upstream and downstream CIs in one list:

This is a real-time report that you can embed in a ServiceNow dashboard, in external portals, or export to CSV. You can drill into form on any of the CIs or related records.

If you want to try it against your data, there's a video on how to set up an evaluation against ServiceNow here.

[stevenwatts]

Thanks Guy,

I'll go back to the sponsor for this piece of work and ask them to investigate Explore Analytics.

Regards