Many of my blog viewers have requested through comments and some of them are via social networking sites ,that they want drill down the 2nd report to see the list of clients with each office edition and version.

Having drilled report to see the list of clients will certainly help to investigate and upgrade them to latest version of Microsoft office.

You can always create collection for office editions but having a report like this would help to export them to excel and other SSRS supported formats.

This request is pending from very long ,it was lying in my to-do list and finally going out through this blog post.

So what all you need to get this report (Count of MS office editions ) implemented in your SCCM site ?

Download the 3 reports from the TechNet Gallery ,upload the reports into your SSRS folder (make sure they all in same folder),change the data source for each report and you are good to run.

Note: This report will list only Microsoft Office 2003,2007,2010 and 2013 but not office 365. If you need office 365, you may have to wait for next update ,otherwise you can edit the RDL file and customize it.

Hi Jermoe,
for office 2016 ,you can replace office 2013 version with 2016 in the existing report. You can simply edit the RDL ,append 2016 ,run the report.
I will try to update the report to include office 2016 and office 365 when time permits.

Hi Eswar,
Thanks for your update on Office 2016.
But there is one thing that is not working:
In the "Count of MS Office Editions with Versions" all numbers of versions are shown, but there is no hyperlink for the number of Office 2016 to see further details.
Do you think, you can fix it?

sure ,i will try to add office 2016 and visio as they are installed on my laptop which i can use to update in report but if you have other versions ,you may have to edit the report and update all other 2016 versions.

collection ,you can only create one per office version and if so ,you can use installed installed instance to create collection for each office version.
I will look at and post query for how to create collection for office 2010 or 2013 so you can take it forward.