Solved

How to create SCCM collection with more than one IP Subnet

Posted on 2013-10-23
2
5,547 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 500 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
T-SQL to copy a database 37 67
T-SQL Query - Group By Year 3 32
SQL Syntax 6 43
Related to SQL Query 5 21
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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.

730 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