Jump to content


rrasco

Device Collection from AD OU

Recommended Posts

I am trying to have my device collections automatically update based on the OU each device is a member of. I found some example for doing this with user collections, but no clear cut way to do it with devices. I found an article on Technet and am trying to use this query to add devices from the 'Desktops' OU to my device collection. It doesn't seem to be working, or it is working slowly. I wasn't sure what log would contain the activity for collection membership updates. Is this the only way to do this? Is there anyway to be more granular with specifying the OU, would if there are two 'Desktop' OUs? Unless I'm supposed to be putting the full path...?

 

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.SystemOUName = "Desktops"
 

http://technet.microsoft.com/en-us/library/gg712323.aspx

Share this post


Link to post
Share on other sites

 

Is this the only way to do this?

 

No, do it the simple way!! ConfigMgr has all this built in.

 

 

Create a new collection name it appropriately, limit it to all systems.

Edit membership and use query rule and give it a name.

Click on Edit Query Statement and click criteria tab, click yellow startburst.

On Criterion properties click select

On attribute class scroll to system resource

On attribute scroll to System OU Name Click OK

On Opertator scroll to lowercase is like

 

At this stage you can click the value button and this should populate all your OUs from AD, just simply select the appropriate OU and click OK through the rest until collection is created!!

 

If your OU is nested and not showing just simply type the rest of the path manually into the value field.

 

Enjoy!!

 

Rocket Man

Share this post


Link to post
Share on other sites

No, do it the simple way!! ConfigMgr has all this built in.

 

 

Create a new collection name it appropriately, limit it to all systems.

Edit membership and use query rule and give it a name.

Click on Edit Query Statement and click criteria tab, click yellow startburst.

On Criterion properties click select

On attribute class scroll to system resource

On attribute scroll to System OU Name Click OK

On Opertator scroll to lowercase is like

 

At this stage you can click the value button and this should populate all your OUs from AD, just simply select the appropriate OU and click OK through the rest until collection is created!!

 

If your OU is nested and not showing just simply type the rest of the path manually into the value field.

 

Enjoy!!

 

Rocket Man

 

I was trying to do it that way to begin with, but I couldn't figure out the details or find documentation for it. Thanks for the details instructions!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.