How to create a report to show CIs with no relationship?

[Luiz Lucena]

Hello everyone, 

I need to create a report to show all CIs without a relationship to anything. 

Any idea what the query should look like?

Has anyone ever done anything like that?

Thanks,

[EricDohr]

I think you are right, Luiz.

Here are a few of the similar screen shots

Create a new query

In this example, we are going to identify Business Apps with no App Services

Add the appropriate nodes (Business App and App Service) - Select No Relationships

Click Run to view the business app listing.  

Note, you can schedule and create a report. This will create a data source 

[maroon_byte]

Check CMDB View > Relationship Health. See if that helps.