Article ID: 555528 - Last Review: December 3, 2005 - Revision: 1.0

HOWTO: Configure System Management Server 2003 to query the Operating System Language

Author: Ka Lung Lai MVP
Expand all | Collapse all

SUMMARY

This is the SQL Statement that used to query the Operating System Language in System Management Server 2003.

CAUSE

You may want to create a query to find out the computers based on their Operating System Language for the collection, software distribution and software update distribution etc.

MORE INFORMATION

Use the following SQL Statement to query the Operating System 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.0%" and
SMS_G_System_SoftwareProduct.ProductLanguage = 1033

* %Server 5.0%=Windows Server 2000
* 1028=Traditional Chinese, 1033=English


APPLIES TO
  • Microsoft Systems Management Server 2003
Keywords: 
kbpubmvp kbpubtypecca kbhowto KB555528
Community Solutions ContentCOMMUNITY SOLUTIONS CONTENT DISCLAIMER
MICROSOFT CORPORATION AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, OR ACCURACY OF THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN. ALL SUCH INFORMATION AND RELATED GRAPHICS ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, WORKMANLIKE EFFORT, TITLE AND NON-INFRINGEMENT. YOU SPECIFICALLY AGREE THAT IN NO EVENT SHALL MICROSOFT AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OF OR INABILITY TO USE THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF MICROSOFT OR ANY OF ITS SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES.
 

Article Translations

 

Related Support Centers