4 Replies Latest reply on Jul 30, 2010 5:59 AM by Maskolis

    Need help comparing two variables


      We'd like to run a query to find Service Tags that do not match the TCP/IP host name for all of our PCs.


      The syntax I'm using is "Computer"."BIOS"."Service Tag" <> "Computer"."Network"."TCP/IP"."Host Name"


      However, when I run the query, I get a return of all of our computers, and yes, nearly all of them have matching info so they should not come up.


      Can anyone spot what is wrong in my statement?