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,

[Akif_Shah]

This may not be the most efficient solution but it will work.

Step 1: Create script include that gets the sys_ids of CI with no relationships

Step 2: Create report that calls the script include

[Luiz Lucena]

Thanks, Akif.

Will try that.

[Luiz Lucena]

Hi Akif, 

What table did you run the report?

I've tried against the [cmdb_ci] but nothing came out.

[Akif_Shah]

It was the cmdb_ci table. Is the client callable field set to true on the script include?
If you can share your code I can try to see if any issues