SCCM ile 32 bit x86 ve 64 Bit x64 Windows 7’leri bulmak

System Center Configuration Manager (SCCM) ile Windows 7 64 bit ve Windows 7 32 bit bilgisayarların listesini çıkarmak için aşağıdaki sorguyu kullanabilirsiniz.

İyi çalışmalar.

64 Bit – x64 Windows 7 Sorgusu

[box color=”orange” icon=”flag”] 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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType = “x64-based PC” and SMS_G_System_OPERATING_SYSTEM.Caption like “Microsoft Windows 7%” [/box]

 

 32 Bit – x32 Windows 7 Sorgusu

[box color=”orange” icon=”flag”]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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType = “X86-based PC” and SMS_G_System_OPERATING_SYSTEM.Caption like “Microsoft Windows 7%”[/box]

NOT: Kodları eksik almamak için, kutunun içerisinde 2 kere tıklayarak almanızı tavsiye ederim.

Yorum yapın

This site uses Akismet to reduce spam. Learn how your comment data is processed.