How to use SMS 2003 to query OS language
Use the following SQL Statement to query the OS language.
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_SoftwareProduct on
SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where
SMS_R_System.OperatingSystemNameandVersion like "%Server 5.2%" and
SMS_G_System_SoftwareProduct.ProductLanguage = 1028
* %Server 5.2%=Windows Server 2003
* 1028=Traditional Chinese, 1033=English..etc
Source: My 8th Microsoft KB Article