Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Report to find orphaned CIs without upstream relationships

AlexR2
Tera Expert

I am trying to write several reports by cmdb class to add to a dashboard that would show orphaned CIs that don't appear in cmdb_ci_rel as a child record. I tried using related list condition but I believe that only looks for a parent

find_real_file.png

Is there a reverse of cmdb_ci_rel table where child is the primary object to query against? I also tried CMDB query builder but I don't believe that could be added to a dashboard, maybe I am wrong. Thanks!

6 REPLIES 6

AJ5
Tera Contributor

Hi @AlexR2 : I was looking for the same answer. Did you resolve the reporting requirement? Please share your experience if you found a solution to this. 

No I wasn't able to.