One of my friends asked me : "How can I create a SRS report for OS languages with ConfigMgr 2007 R2 or R3?”
Well, it’s easy and you just need to follow these steps :
1. On the ConfigMgr console, under “Reporting Services” node, right-click your server name, and then click Create Report.
2. Select “SQL-Based Report”, enter a name for the report and choose a path.
3. Click on “Edit command text”.
4. Use this query in the command text:
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
5. Click next.
6. Click next.
7. Now just run the report.
8. And you will see a wonderful result.
Ed Price - MSFT edited Original. Comment: Minor edits and title casing