How can we report on cmdb_items that have no relationship to other cmdb_items?

veerlerutten · ‎11-23-2015

Community Alums · ‎08-31-2017

Have you tried letting it run for a while to see how long it takes with the full CI list? Are there other filters you might be able to apply (specific classes or statuses) that could cut the numbers down?

ramak · ‎08-31-2017

Yep, let it run and it just keeps running for a while, and just stops after several minutes.

Also looks like DB views don't support dot-walking. How would we run this DB view then?

Robert Campbell · ‎12-01-2021

Is there another way to do this because when I "Try It", it times out.

Your transaction has been canceled

Time: 298672 ms

Reason: maximum execution time exceeded