wrong CI's are showing up while creating a report

[Akshay03]

Hello,

For the below report build on cmdb_ci table, with the conditions as shown in screenshot.
conditions : install status = IN USE
related list condition = parent.install status = IN USE

We have observed that those CI who don't have any parent (shown below in dependency view ex. Computer) which dont have any parent CI, its getting populated while pulling the report.

Our concern is that the CI with without any parent is showing up in report, which is against our conditions. (parent.install status = IN USE)

[Mark Manders]

'Relationships' (assuming it is the OOB one) is defined as 'Parent = current CI'. So you are checking on all CI's that are in use, but only show the ones that have a child of which the parent is 'in use', which is the record itself. The only records not showing, are the ones without a child (or the ones that aren't in use).

I think the best way to get what you want, is to use the CMDB Query Builder, instead of regular reports. 

[Akshay03]

Hello Mark,
Thanks for reply

Is there any way to get only those CI's which don't have parent, but still showing up in our report??
Also can you please help with CMDB query builder?

Thanks.

[Mark Manders]

On my OOB instance, I don't have 'in use' as a choice option for 'install status', so my screenshot selects on 'installed', but if you run your query on the CMDB_REL_CI table, you will get all CI's that have a relationship (excluding the ones that have none and with that also don't have a parent and you don't want to see those, as I understand).

If you query on child.install_status = installed AND parent.install_status = installed, you get all CI's that are installed and if you put your 'child' field as the first one, you will have all installed CI's that have an installed parent. I think that's what you are looking for? 

[Akshay03]

Hello @Mark Manders ,

yes, we have tried this solution but the issue of client is that: if we add  child.install_status = installed AND parent.install_status = installed on cmdb_rel_ci while trying on this, number of records is around 55k.

if we try same thing with cmdb_ci  table (check screenshot) we're getting same number of records (55k)
conditions : install status = IN USE
related list condition = child.install status = IN USE

 

But if we try same thing with cmdb_ci  table (check screenshot) we're getting different number of records(63k)
conditions : install status = IN USE
related list condition = parent.install status = IN USE