[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

How to create SCCM collection with more than one IP Subnet

Posted on 2013-10-23
2
Medium Priority
?
6,339 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
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.%"
0
 

Author Closing Comment

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

656 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