CMDB Report: CIs With No Relationships

[adamtoth]

Hello,

How can I most easily create a report of CIs that have no relationships? Essentially these would be for classes that do not have Orphan rules set up.

Thank you,

Adam

[AndersBGS]

Hi @adamtoth 

I would utilize the CMDB query builder and take it class by class. To create a report based on cmdb_rel_ci will not work, as it will only show CIs with relationships.

[adamtoth]

Hello Anders,

For individually doing the classes in CMDB Query builder, how would I set up the query to find the CIs that don't have relationships?

Thank you,

Adam

[Palak Gupta]

Hello @adamtoth,

Do you have the list of classes which don't have Orphan rule defined?

I would recommend for a CMDB governance solution, I would go one step further and create two separate reports:

1. CIs with no relationships
2. CI classes without Orphan Rule coverage(If you don't have the list of classes which don't have Orphan Rule defined)

[adamtoth]

Hello Palak,

How could you query for a list of the CIs that have no relationships?

Thank you,

Adam