2 Replies Latest reply on Oct 15, 2013 8:22 AM by Mike_SRTAdmin

    Query return data missmatch

    Mike_SRTAdmin Apprentice

      So just to educate myself on the LANDesk system I recently inherited I was working with building some queries when I ran into this. Two different queries, same data required...

       

      First query returns 236 machines, second returns 234 machines. First query has two machines that are returned twice per machine causing the difference. What I need to know is why is there a difference and is this something that can be corrected.

       

      LANDesk 9.5 SP1

       

       

      "Computer"."Security"."AntiVirus Software"."AntiVirus"."Product Version"  Not Like  "10.1.0.867"

      AND "Computer"."LDAP Location"  Like  "OU=Grand Junction,OU=Computers,OU=AT&T Global Services,OU=Clients,DC=ts,DC=startek,DC=com"

       

      "Computer"."LDAP Location"  Like  "OU=Grand Junction,OU=Computers,OU=AT&T Global Services,OU=Clients,DC=ts,DC=startek,DC=com"

      "Computer"."Security"."AntiVirus Software"."AntiVirus"."Product Version"  Not Like  "10.1.0.867"