Query builder - Search CIs with select agent running

[GauravJ]

Hi, I am very new to SNOW and Query Builder. I am trying to get a query built with following criteria, however, seems I am not getting the results I should. Story below may help understand why I think the results aren't what should be.

Criteria for CIs:

• Agent running on any device that can be assigned an IP address
• Filter is simple, publisher or Display Name on Software Installation class with agent details

Issue on hand:

Software installation is a non-cmdb table, only suggested CMDB class is hardware connection property as 'Installed on'.

This query works but the number of records are less than half if I compare the same using standard reporting on table 'cmdb_sam_sw_install' and set filters on the property 'Installed On' with publisher and display name fields set same as query builder. The results are more than twice the numbers than query builder. Please note that results from both Query Builder and Report has repeating records and I have verified that for handful of CI's they output the same number of records.

I have tried several possible joins (see below) but most would end up with same results or none at all.

Class joins used:

• Hardware joining Installed On Software Installation
• Configuration Item joining with 'Any relationship type' with Hardware joining Installed On Software Installation
• Software Install OR Software Installation joining Hardware class on Installed On

I will really appreciate if anyone here can put me in the right direction.