How to obtain OS MUI Language via a Query

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

How to obtain OS MUI Language via a Query

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> How to obtain OS MUI Language via a Query

Page: [1]

Message

<< Older Topic Newer Topic >>

How to obtain OS MUI Language via a Query - 8/21/2008 11:08:38 AM

Steph_A

Posts: 3
Score: 0
Joined: 8/21/2008
Status: offline

Hi folks,

I would like to obtain the OS MUI language setting of SMS clients via a query in the SMS database. Any idea in which view or table this info may be available?

Thanks,

Steph

Post #: 1

RE: How to obtain OS MUI Language via a Query - 8/21/2008 1:04:34 PM

nastle

Posts: 23
Score: 0
Joined: 4/15/2008
Status: offline

The view is V_GS_OperatingSystem and the field is OSLanguage0.
you can find out all the languages via this query on your SMS DB

SELECT
distinct [OSLanguage0]

FROM [SMS].[dbo].[v_GS_OPERATING_SYSTEM]

(in reply to Steph_A)

Post #: 2

RE: How to obtain OS MUI Language via a Query - 8/21/2008 1:05:13 PM

nastle

Posts: 23
Score: 0
Joined: 4/15/2008
Status: offline

correction --> v_GS_Operating_System

(in reply to nastle)

Post #: 3

RE: How to obtain OS MUI Language via a Query - 8/21/2008 1:33:37 PM

Steph_A

Posts: 3
Score: 0
Joined: 8/21/2008
Status: offline

Thanks for the info but this field does not provide you the OS "MUI" language. This is why I'm stuck and looking for the info elsewhere.

(in reply to nastle)

Post #: 4

RE: How to obtain OS MUI Language via a Query - 8/21/2008 3:57:18 PM

jnelson993

Posts: 896
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

I believe that's what the LOCALE field is on the same view...

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to Steph_A)

Post #: 5

RE: How to obtain OS MUI Language via a Query - 8/21/2008 4:34:02 PM

Steph_A

Posts: 3
Score: 0
Joined: 8/21/2008
Status: offline

Thanks ... I'll have a look.

(in reply to jnelson993)

Post #: 6