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

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_CountThanks 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.

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

The error is primarily because There are no Select permissions on that specific table.I think you have imported the query in aSCCM 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_userswebreport_approleOn the other hand have you tried running the query from SQL query analyzer?

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/