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


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

Запрос на получение компьютеров с Windows 7 x86:

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"

 

Запрос на получение компьютеров с Windows 7 x64:

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"

Добавить комментарий

Do NOT follow this link or you will be banned from the site!