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

    Need help comparing two variables

    Rookie

      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?

       

      Thanks!