SOLVED Windows 7 Device collection query

[Harshit Pandey]

hi,

can some one help me with windows 7 device collection query. i want to include both 32 bit and 64 bit query and form a collection.

 

[Garth]

there are ,any example on the net for this, what isn't working for you?

 

[1bruce]

For Exmaple:
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 OperatingSystemNameandVersion like '%Workstation 6.1%'

 

[Prajwal Desai]

I think query by @1bruce will surely help you.