4 Replies Latest reply on Dec 26, 2008 7:24 AM by swant

    Excluding devices from query

    Apprentice

      I'm building a query that contains numerous subnets. I add them by using a field like "network tcpic address like 0.0.0.0 and so on and so forth. Everything is gravy until i want to exclude a device or a username. normally on a small query i would add login name <> username and it will exclude the user or i also use device name <> and it will normally exclude that device . Also for each field i specify it by an or between each one.The query that i am currelty building is to specify subnets to reboot the devices if they are left on at night. When i add these exclusions in this current query for some reason it wants to add every device that is out there. Is this not working because my query is too large? Any suggestions.