SCCM Configmgr Report for Count of MS Office Versions updated with list of clients

I wrote a blog post year ago on how to get count of MS Office Editions with versions installed across my environment using SCCM Configmgr. This report consists of 2 reports .1st report is ,to get count of Microsoft Editions for ex: how many are office 2003, 2007 ,2010 and 2013 and 2nd report is actually drilled report linked to 1st report to give list of all MS Office editions (what are the editions of office 2003 ,2007,2010 and 2013) with its client count .

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.

How does the report look like ?

1. Count of MS Office editions

image

2. List MS Office editions for selected version (ex: 2003)

image

3. List of Clients by specific MS Office edition and version

image

 

Hope it helps.

16 Responses to "SCCM Configmgr Report for Count of MS Office Versions updated with list of clients"

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

      Thanks,
      Eswar

      Reply
  1. Hi Eswar ..this is a awesome report .. I have been using the older one that you did

    I just have one question ..does this report pick up both 32 and 64 bit of MS Office

    Reply
    1. You can identify based on the product code (may not be 100% correct) or go with AI data (information stored in v_gs_installed_software using the installed directory)

      Regards
      Eswar

      Reply
    1. you will need to edit the main report and linked reports and customize it. Time involved init for me to update the report. I will check and update the report .

      Thanks,
      Eswar

      Reply
        1. 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.

          Regards,
          Eswar

          Reply

Leave a Reply