Your company's ad could live here and reach over 50,000 people a month!

Share This Post

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?

Share This Post

A community professional, keynoter, and evangelist who has driven social media and marketing strategies, editorial successes, delivered customer successes and built some of the largest and longest-running online communities. Rod has created, managed and grown small, medium, and mega-sized conferences; run entire editorial teams to deliver record traffic and market leadership; as product manager, directed the success of hundreds of product releases; supported sales and marketing to ensure customer success; developed, run and sold businesses; written thousands of technical articles, white papers, case studies, and technical documentation; hosted and delivered hundreds of attendance shattering webinars and virtual tradeshows; and delivered keynote speeches and sessions at a wide variety of events including conferences, webinars, events, and user groups.

Leave a Reply