Forgot to mention criteria for OU... Considering you say "Employee OU", I am assuming we are talking about machine accounts and not user accounts.
Would look something like this, just replace the <OU-PATH> part with reflect the Employee OU... 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 inner join SMS_G_System_PROCESSOR on SMS_G_System_PROCESSOR.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PROCESSOR.AddressWidth = 32 and SMS_R_System.SystemOUName like "%<OU-PATH>%" and SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 6.1%" Elias On Thu, Jun 6, 2013 at 12:46 AM, Elias Leal <[email protected]> wrote: > Brian, > > Are you trying to create these collections because you want to do some > application deployment? If so, why not just create a single collection with > all W7 machines and from your deployment specify the program requirement > for a specific OS and architecture? I could understand creating a report to > see a break down, but for a collection...why bother creating more > collections than is necessary? > > That said...if you still need it separate, this will probably work. > This will show all W7 clients that run 32-bit. Just put this in your query > statement: > > 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 inner join SMS_G_System_PROCESSOR on > SMS_G_System_PROCESSOR.ResourceID = SMS_R_System.ResourceId where > SMS_G_System_PROCESSOR.AddressWidth = 32 and > SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT > Workstation 6.1%" > > If you want 64, just change the processor.AddressWidth accordingly. I used > the like statement for the OS to catch all W7 OSes like tablets and > embedded. > > Elias > > > On Wed, Jun 5, 2013 at 5:02 PM, Brian McDonald <[email protected]>wrote: > >> Hey everyone, >> >> I need help with a query I'm trying to build in CM12 and can't get it to >> work properly. I'm trying to setup a collection for devices in the >> Employees OU that are Win7x64 clients. I'd also like to have one for >> devices in the Employees OU that are Win7x86 clients. >> >> Does anyone have any sample queries they can share? >> >> Thanks, >> >> Brian >> >> >
