Problem to create an ip range collection on sccm 2012 sp1

Hi everybody,

 

I need to create an ip range query to a collection, i saw a lot of explanations:

 

I create this query for the ip range 10.201.0.50 10.201.0.254

 

select *
from  SMS_R_System
where  IPAddresses like "10.201.0.[5-9][0-9]"
            or IPAddresses like "10.201.0.1[0-9][0-9]"
            or IPAddresses like "10.201.0.2[0-5][0-4]"

 

But nothing machines display

 

In the general tab it's empty, is it normal?

 

thanks guys !!

January 21st, 2014 9:53am

Hi,

Try it like this

select *
from  SMS_R_System
where  IPAddresses like '10.201.0.[5-9][0-9]%'
            or IPAddresses like '10.201.0.1[0-9][0-9]%'
            or IPAddresses like '10.201.0.2[0-5][0-4]%'

Regards,

Vah


January 21st, 2014 10:29am

Thanks Gerry!

Yes I tried this way but it didn't work for me !

Do you have an idea why?

Vah i'll try tomorrow !

thanks you to both

  • Edited by offrock85 17 hours 10 minutes ago
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2014 2:13pm

Why do you want to create such a collection? It would depend on inventory data which is not real-time; plus the collections have to be updated before a clients will become a member.
January 21st, 2014 3:15pm

Hi Torsten !

It's a request because we have a lot of boundaries on differents sites and we have to deploy an important software update. We have an ip range to exclude servers. Maybe the inventory data is not in real time but the client will still have an ip of ip range. Even if it's a laptop it will take an ip of an other site ip range (one query by site boundary). Please tell me if i'm wrong.

Bye

Free Windows Admin Tool Kit Click here and download it now
January 21st, 2014 4:18pm

Hi,

Try it like this

select *
from  SMS_R_System
where  IPAddresses like '10.201.0.[5-9][0-9]%'
            or IPAddresses like '10.201.0.1[0-9][0-9]%'
            or IPAddresses like '10.201.0.2[0-5][0-4]%'

Regards,

Vah


January 21st, 2014 6:24pm

Thanks Gerry!

Yes I tried this way but it didn't work for me !

Do you have an idea why?

Vah i'll try tomorrow !

thanks you to both

  • Edited by offrock85 Tuesday, January 21, 2014 7:15 PM
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2014 10:09pm

Hi!

It doesn't work, i've the network discovery not enabled, should i discover it?

Thanks for your help

January 22nd, 2014 3:49am

We have an ip range to exclude servers.


Why don't you exclude them based on the OS version, OU or whatever criteria. IP range is not the best one IMHO.
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2014 3:59am

As Torsten said, IP Range is a poor way to target deployments. However, there should be no reason why you should not be able to create the collection. I've just done it again as follows:

There were three criteria in my query:

1.

2. Same but less than or equal to 172.24.25.145

3. ConfigMgr client is installed

As expected the query returns only a couple of devices.

The full query is:

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.IPAddresses >= "172.24.25.140" and SMS_R_System.Client = "1" and SMS_R_System.IPAddresses <= "172.24.25.145"

 

January 22nd, 2014 5:04am

Hi Torsten!

I agree with you but there are a lot of site but not OU by site, only ip range by site in sccm permit to me to deploy the update application (it's a request and i can't do otherwise but you're absolutly right)

Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2014 5:32am

Thanks Gerry!

Yes i did it but it displays too much computer out of the ip range, the "and" in the query is a problem for me, for example in a ip subnet query if i make 2 ip subnet nothing is displayed with "and" however with "or" it displays the both. Do you have an explanation?

Thanks

January 22nd, 2014 8:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics