7 Replies Latest reply on Feb 5, 2012 3:45 PM by JSMCPN

    Query for multiple IP ranges

    Rookie

      I am trying to create a query for 5 IP ranges in one location. They are broken up by building and floor. I have tried:

       

      ("Computer"."Network"."TCPIP"."Address" >= "010.007.000.000"

      AND "Computer"."Network"."TCPIP"."Address" <= "010.007.000.256")

      AND ("Computer"."Network"."TCPIP"."Address" >= "010.007.001.000"

      AND "Computer"."Network"."TCPIP"."Address" <= "010.007.001.256")

       

      AND

       

      ("Computer"."Network"."TCPIP"."Address" >= "010.007.000.000"

      AND "Computer"."Network"."TCPIP"."Address" <= "010.007.000.256")

      OR ("Computer"."Network"."TCPIP"."Address" >= "010.007.001.000"

      AND "Computer"."Network"."TCPIP"."Address" <= "010.007.001.256")

       

      but both queries return zero results. When I run these individually, I get the results I expect but I need to have one query with all computers in these IP ranges.

       

      Can anyone help me with this?