Creating CMDB Missing Relationship Reports

[NonaJohnson]

Greetings,

I am trying to create three reports that shows CMDB applications where there are:

• no downstream relationships or
• no upstream relationships or
• no upstream/downstream relationships

I have tried using the table cmdb_rel_ci (CI Relationship) but cannot seem to create a filter to receive any of the results noted above. It seems to only show those that have either upstream/downstream relationships.  Have also seen on the community those that say to use the cmdb query builder, but I cannot find a way to filter this to show the applications with missing relationships. Also found some that said you had to create a view to combine the application table and the relationship table.

Has anyone had any luck creating a report to show this type of data.

Thanks

Nona Johnson

[petercawdron]

Yeah, reporting on something that doesn't exist is always tricky, particularly in ServiceNow as it has limited OLAP style reporting. You could do something with a data source, but I suspect it would get messy/overly complex very quickly.

I recently had to do something similar for a client and documented it in an article, if you're interested.