I'm trying to get 32-bit Windows 7 collection on SCCM 2007.

Here is my query:

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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where (SMS_R_System.OperatingSystemNameandVersion like "%Workstation 6.1%" or SMS_R_System.OperatingSystemNameandVersion like "%Windows 7%") and SMS_G_System_COMPUTER_SYSTEM.SystemType = "x86-based PC"

However, this query does not pull in all the systems.  Is there anything wrong with this query?

Thank you,

try 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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "%Microsoft Windows 7%" and SMS_G_System_SYSTEM.SystemType = "X86-based PC"

Hello,

Not sure you really need the "%Windows 7% bit since that column should always look something like "Microsoft Windows NT Workstation 6.1".

You say "does not pull in all the systems". Does this mean that only some are left out, or that none of the systems are added?

I am guessing that it might have something to do with the lower-case "x" in "x86"? You could change the operator to LIKE instead of =, or simply go with an upper-case X and see if it makes any difference.

I mean that not all of the Windows 7 systems are showing up in the collection, only about a half.

Yes, It's working.

Thank you.