How to create SCCM collection with more than one IP Subnet

Posted on 2013-10-23
Medium Priority
1 Endorsement
Last Modified: 2013-10-23
I need to create a collection membership based off of more than one IP subnet. I have no problems adding one subnet. Membership is accurately collected for a single subnet. But when I attempt to add a second subnet to the criteria the collection membership shows zero members. The query needs to have specific subnets referenced, so I will not be able to utilize "%" in the query. I'm sure I'm missing something...Please help
Question by:Program652
LVL 35

Accepted Solution

Joseph Daly earned 2000 total points
ID: 39594869
So the way I usually do this is to use the network adapter configuration IP address. Im not sure why you say you cant use the % wildcard.

The query below is for subnet 192.168.100.% or subnet 192.168.101.%

select *  from  SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceId = SMS_R_System.ResourceId where SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "192.168.100.%" or SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "192.168.101.%"

Author Closing Comment

ID: 39595109
Thanks for the quick response! Since your query uses the IP address with wildcard (which IS the subnet) and not the IP subnet query criteria, I was able to use this query successfully to build a collection that includes multiple subnets - Cheers!

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question