Коллекции на получение компьютеров с Windows 7 x86 и x64 в SCCM 2007

Запрос на получение компьютеров с Windows 7 x86:
[cc lang=»sql» width=»100%» height=»100%» escaped=»true»]
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%»
and SMS_G_System_COMPUTER_SYSTEM.SystemType = «X86-based PC»
[/cc]

 

Запрос на получение компьютеров с Windows 7 x64:
[cc lang=»sql» width=»100%» height=»100%» escaped=»true»]
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%»
and SMS_G_System_COMPUTER_SYSTEM.SystemType = «x64-based PC»
[/cc]