You can write a query that says that if a computers IP address is like "X" than to include it in the query. I think this is the most common thing that I have seen.
Then you can name the query a location name.
I think we actually have more subnets - real PITA. I agree with Dave use like in your queries much easier. Some tips to help:
We created query group called locations. Then created groups under location - Locations | Business Unit Name | Query Names
To help create the queries quickly -
Create one and export it out
Then use a text editor and change <name value=
Then change ip address %010.001.%
Maybe just me but I find it easier to use and editor to create a lot of similiar queries. Also if you are an AD shop and have the sites broken down by OU you could use OU.
The above suggestions are right on. Name the query the "real location name" you want. You might find it easier to use Subnet Broadcast Address then IP address, though.
thanks to ALL .. i've implemented everyone's ideas..
Love the export - edit - import. I'm actually having my packager script this for 100+ subnets using a spreadsheet of subnet listings as source.
The newyork example reminded me that I don't have a strict class c network.. we have more then 255 devices per so i eventually need to put a RANGE in my query insetad of using the subnet address as I do now.. it will work for now.
As you say.. this was pretty obvious to do.. it was right in front of me.. My helpdesk thinks I'm walking on water today.. thanks guys!
Is there a way to actually have the Subnet convert into a name? I've used the query function to make reports for each site but our purchasing team would like a monthly report on PC Name, Primary User, Location (by Subnet info), PC Model, PC Serial, Monitor Model and Monitor Serial. I can give them the data for all of these but I have to export the report into a CSV and then manually replace the subnets.
The Data Analytics add on (formerly Managed Planet) can do this. It can map any existing data to a new value.