Unknown Computers in a specific IP range

[syparon]

Hello gents,

 

I would like to create a device collection which contain computers which have not been deployed already and which are in a specific IP range.

After this I would like to deploy a task sequence on this device collection in order to install new computers located on a specific site of our company.

 

So I created the following WQL query : (does not work)

 

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.ResourceId in (select ResourceId from SMS_CM_RES_COLL_$ID) and SMS_R_System.IPAddresses like "10.10.10.%"

 

$ID is the ID of the collection which contain unknow computers (using direct rules)

 

Any idea ?

[newadmsccm]

Perhaps can help you,see this link's:

 

http://www.windows-noob.com/forums/index.php?/topic/8903-sccm-2012-unknown-computers-query/

 

http://social.technet.microsoft.com/Forums/systemcenter/en-US/e3e44123-711c-4752-b3c1-3517ba3d3086/create-a-collection-targeting-with-particular-computer-names-or-network-range?forum=configmgrsetup

[syparon]

thanks for your reply newadmsccm, but it is not exactly what i am looking to achieve.

Actually I already know how to query machines in a specific subnet and I know that there is direct rules in order to gather unknown machines.

But I would like to create a query which combine both, unknown computers which are in a specific subnet.

[Peter van der Woude]

What do you mean exactly with unknown computers? The unknown computer objects (the two defaults), or just computer objects without client.

[syparon]

The unknown computer objects (the two defaults) (those which are in SMS000US)

[Peter van der Woude]

Those are two generic objects that are not location or ip bound, so that is not possible. You can filter in a task sequence itself on, for example the gateway of the client running the task sequence.

[syparon]

Thanks for your answer Peter