Solved

How to create SCCM collection with more than one IP Subnet

Posted on 2013-10-23
2
5,001 Views
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
0
Comment
Question by:Program652
2 Comments
 
LVL 35

Accepted Solution

by:
Joseph Daly earned 500 total points
Comment Utility
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.%"
0
 

Author Closing Comment

by:Program652
Comment Utility
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!
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now