Report for incidents and cmdb_rel_ci to find records where the ci does not have supporting group

[Tsura Andreeva]

Hello community, I was asked if I can create a report for active incidents where the child ci does not have support group. We have a process where we receive some automated incidents; the service desk will open the ci record in cmdb, scroll down to the "Relationship" section to see that application uses that CI. Then they would open that child CI records in the CMDB to see the Supporting Group. The ask is give us the records for that automated process where the child ci does not have Supporting Group. So they are not looking for the main Ci Support Group ( I can get that from the incident table). Any help or suggestions are most welcome.

[emir]

I am kind of confused of the ask. 

It is a good practice to have a report for all CIs (maybe start with Hardware) that don't have a support group. Are you using a custom field to indicate that?

Are you going after CIs that are part of an app, that do not have a support group?

it is simple to dot walk (show related fields) from INC table to see CI attributes such as a group.

[Tsura Andreeva]

We are looking for one layer deeper than just dot walk from incident table to the ci

[Tsura Andreeva]

 So I can create the report in the cmdb_rel_ci no problem, but how do I reference the incident table?

[emir · Accepted solution]

Use CMDB Query Builder for that, something like this: