I'm trying to raise an alert when an IP address over 192.168.1.200 appears on the network. The "Greater than" test doesn't work in this case, as it also matches 192.168.1.3.
What's the UDT way to identify IPs in this range?
SQL doesn't have a data format for subnets, so solarwinds is storing them as a string and you are trying to greater than against a string, which tends to be a complete mess. I expect the way I would get this to work would be a fully custom SQL alert condition that breaks the last octet off with a substring, converts it to an integer, then does the greater than compare.
Not easy to do at all on a Friday afternoon.
If you really want to stick to it I guess you could also try and do something like starts with "192.168.1.2" and does not end with 1.2 and does not end with 1.21,.22, .23, etc etc It's caveman style but would work if you aren't actually a DBA on the side.
-Marc Netterfield
Loop1 Systems: SolarWinds Training and Professional Services
