locked
Report - OS Language RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Can someone assist me with creating an SCCM report which displays OS languages in use - and count.

    I am trying to create this report so I can see what languages are in use for our remote sites around the world.

    (I'm trying to only package & replicate the absolute required software update languages.)


    Any help is greatly appreciated!!

    Thanks!

    Eric
    Monday, October 26, 2009 7:02 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    It is not recommend to query against the tables directly, this can lead to table locking issues.

     

    It is recommend that you always query against the views, on top of that I would not use the Installed Software for OS info. I would use the v_GS_OPERATING_SYSTEM for this.

     

    select

          OS.Caption0,

          OS.OSLanguage0,

          Count(*)

    from

          dbo.v_GS_OPERATING_SYSTEM OS

    group by

          OS.Caption0,

          OS.OSLanguage0

    Order by

          OS.Caption0,

          OS.OSLanguage0

     

    http://www.enhansoft.com/
    • Marked as answer by Yog Li Monday, November 9, 2009 3:57 AM
    Friday, October 30, 2009 1:18 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    select count(*)as OS_Count, isd.ProductName00, lang.alias as OS_English_Name, lang.name as OS_Lang

    from INSTALLED_SOFTWARE_DATA isd left outer join sys.syslanguages lang

    on isd.Language00 = lang.lcid

    where isd.SoftwareCode00 like '%microsoft windows%' or isd.SoftwareCode00 like '%microsoft® windows%'

    group by isd.SoftwareCode00, isd.ProductName00, lang.alias, lang.lcid, lang.name

    order by OS_Count

    Thanks to http://social.technet.microsoft.com/forums/en-US/configmgrai/thread/5977cba0-1a0b-4c22-9a9c-d522998fa2cd/ 

    You can work around the query to group this based on remote sites name etc.

    Monday, October 26, 2009 7:53 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I tried running the report but it comes back with an error. Can you help me to understand why it is failing?? THANKS!

    An error occurred when the report was run. The details are as follows:
    The SELECT permission was denied on the object 'INSTALLED_SOFTWARE_DATA', database 'SMS_xxx', schema 'dbo'.
    Error Number: -2147217911
    Source: Microsoft OLE DB Provider for SQL Server
    Native Error: 229
    Thursday, October 29, 2009 2:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The error is primarily because There are no Select permissions on that specific table.

    I think you have imported the query in a SCCM Report. If thats the case then you will need to add select permissions to the table   "Installed_Software_Data"  using Table Properties - Permissions for the following users
    smsschm_users
    webreport_approle


    On the other hand have you tried running the query from SQL query analyzer?

    Friday, October 30, 2009 12:41 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    It is not recommend to query against the tables directly, this can lead to table locking issues.

     

    It is recommend that you always query against the views, on top of that I would not use the Installed Software for OS info. I would use the v_GS_OPERATING_SYSTEM for this.

     

    select

          OS.Caption0,

          OS.OSLanguage0,

          Count(*)

    from

          dbo.v_GS_OPERATING_SYSTEM OS

    group by

          OS.Caption0,

          OS.OSLanguage0

    Order by

          OS.Caption0,

          OS.OSLanguage0

     

    http://www.enhansoft.com/
    • Marked as answer by Yog Li Monday, November 9, 2009 3:57 AM
    Friday, October 30, 2009 1:18 PM