SCCM 2012 SP1 Collection query based on DN

I had problem to create query that would show me all systems from specific OU. I have tested all queries that I could find in internet but none of them returned all computers only some. Perhaps it has to do something with our sccm setup (sccm in one domain and all clients in another untrusted domain). After few days struggle with it I almost gave up when it hit me. Why to try all the time to use SMS_R_System.SystemOUName when it clearly does not work for me instead I have used SMS_R_System.DistinguishedName with “like” operator and wildcard in computer name to pull all computers from specific OU. Now it works like a charm. The query looks like this

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.DistinguishedName like “CN=%,OU=Windows 7,OU=Laptops,DC=domain,DC=com”

This query can be tweaked to pull systems from specific OU based on some prefix in their name, for example

%-D for desktops

%-L for Laptops

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s