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 · Accepted solution]

You last report shows all records that are in use. The relationship related list shows all childs, so if you look for all CI's that are in use and have a child that is in use, you are showing all CI's with a child that are in use (even if they don't have a parent themselves).

Your 63k reports shows all in use CI's that have a child. 
Your cmdb_ci report (55K) shows all in use CI's with at least one child that is also in use.

The cmdb_rel_ci report (55K) does the same: it shows all in use CI's that have a parent that is also in use.
You apparently have 8K CI's that aren't in use.
The last two reports don't include CI's without a parent. The first one does. I don't know your data and what you are expecting, but report conditions seem correct to me, including the difference between the results.