SCCM query to populate Device collection

Hi!

In SCCM if you want to build a Device Query based on their OS version you can apply the following 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   where    SMS_R_System.OperatingSystemNameandVersion like “%workstation%”   and SMS_R_System.OperatingSystemNameandVersion like “%6.2%” and SMS_G_System_COMPUTER_SYSTEM.SystemType = “x86-based PC”

Where %workstation% is to populate only workstations but if you prefeer servers change it for %server%

Where %6.2% is the OS version. In the below link you will find the OS version that you are loooking for, change it on the query 🙂

https://msdn.microsoft.com/en-us/library/windows/desktop/ms724832(v=vs.85).aspx

And also, if you need to know the architecture, you can indicate if 64 or 32 bits indicating “x86-based PC” or “x64-based PC” 

Regards!

 

Anuncios

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s