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 > >
