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:


To make a collection based on the IP Ranges: and


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?


Written by , Posted .

Leave a Comment

You must be logged in to post a comment.