syparon Posted May 28, 2014 Report post Posted May 28, 2014 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 ? Quote Share this post Link to post Share on other sites More sharing options...
newadmsccm Posted May 28, 2014 Report post Posted May 28, 2014 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 Quote Share this post Link to post Share on other sites More sharing options...
syparon Posted May 30, 2014 Report post Posted May 30, 2014 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. Quote Share this post Link to post Share on other sites More sharing options...
Peter van der Woude Posted May 30, 2014 Report post Posted May 30, 2014 What do you mean exactly with unknown computers? The unknown computer objects (the two defaults), or just computer objects without client. Quote Share this post Link to post Share on other sites More sharing options...
syparon Posted June 2, 2014 Report post Posted June 2, 2014 The unknown computer objects (the two defaults) (those which are in SMS000US) Quote Share this post Link to post Share on other sites More sharing options...
Peter van der Woude Posted June 2, 2014 Report post Posted June 2, 2014 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. 1 Quote Share this post Link to post Share on other sites More sharing options...
syparon Posted June 3, 2014 Report post Posted June 3, 2014 Thanks for your answer Peter Quote Share this post Link to post Share on other sites More sharing options...
