Hello again :-)
I was wondering if it is possible to list hosts in the NPM database by CIDR subnets. The reason why, is that a good number of our branches use a 23 bit subnet mask, and it gets a little tiresome to have to do two searches per branch to list the devices at the site. Basically, if I have a subnet of 10.160.24.0/23 I want to be able to list everything Orion knows about. I need this to list the nodes in the database for an integration project that's coming up in a few weeks - we need to be able to prove to management that we're watching the network up to and overnight on conversion night.
I'm not afraid of SQL enterprise manager, but I still have the same issue with having to either "stack" my LIKE statements, or run two queries and tape the results together.
