Issue
In CMDB Query builder:
(1) run query1 which shows a total e.g. 500 results.
(2) run query2 which shows a total e.g. 10 results.
(3) run query3 which adds an OR operator to connect both queries e.g. this should combined the results but it is showing only 300 results.
Release
New York Patch 4
Cause
In the 3rd query where you combine relationships, check if there is a reverse direction relationship e.g.between cluster resource and computer
cluster resource
<== defines resources for:: Gets resources from == computer
You can test by removing the reversal to see if you get an accurate count
Resolution
There is known issue KB0789905 - CMDB Query Builder returns incorrect results when 2nd level relationships are involved fixed in Orlando in regards to 2nd level relationships which you can apply and test to see if this also resolves relationships that are reversed.
