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.