Community solution: Creating a Collection based on IP Ranges

msutliff responded to a recent forum thread and provided a great example and query with which to create a ConfigMgr Collection based on IP ranges.

Here’s the solution:

Example:

To make a collection based on the IP Ranges:
10.18.16.0/20 and 10.18.32.0/20

 

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.IPSubnets like '10.18.1[6-9].0'
or SMS_R_System.IPSubnets like '10.18.4[0-7].0'
or SMS_R_System.IPSubnets like '10.18.[2-3][0-9].0'

 

Original thread: Is it possible to create a collection based on site boundaries?

email

Written by , Posted .