Collection by IP Address
I would like to create a collection based off of location. For example I know my one office has the IP address range 172.19.10.1 - 172.19.11.255. I tried to create a query from the collection wizard which is shown below. It doesn't work
though as it captures additional IP addresses.
select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System where SMS_R_System.IPAddresses > "172.19.10.1" and SMS_R_System.IPAddresses
< "172.19.11.255"
Any help is appreciated. Thanks.
May 10th, 2010 6:26pm
Use like instead of > and <
Where IPAddress0 like '172.19.10.%' or IPAddress0 like '172.19.11.%'
John Marcum | http://myitforum.com/cs2/blogs/jmarcum |
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2010 6:37pm