Creating Device Query based on Language ID in SCCM

Hi!

To create a collection populated with computers based on their language ID use 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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.OSLanguage = 3082

Where 3082 is the language ID that you are interested.

In the following link you can find all language IDs

https://msdn.microsoft.com/en-us/goglobal/bb964664.aspx

Regards!

Anuncios