Close Menu
    Monday, November 25

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

    Eswar KonetiBy 2 Mins Read CM2012 14,197 Views

    Update: I have another post that shows the count of ms office version with architecture type 32 or 64 for specific collection on http://eskonr.com/2017/11/configmgr-report-for-count-of-ms-office-versions-with-architecture-type-32bit-and-64bit/

    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.

    Share.

    Related Posts

    37 Comments

    1. Kashan Nawaz on

      Hi,

      Thanks for the this as it solves my half of work. I need the same type of report for Windows. can you help me on this.

      Thanks
      Kashan Nawaz

      Reply
      • Eswar Koneti on

        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
    5. rastamoses on

      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
      • admin on

        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
    8. Lisa McCague on

      I know you just updated this report and thanks!

      I am trying to add the 32 or 64 bit version to this report starting from Count and drill down to the 2 list reports. I want to use the ProdID where the %-%-%-1000-% for 64bit and %-%-%-0000-% for 32 bit as the identifier. Is this do-able? To the 2nd Report (List MS Office Versions) I added the following:
      CASE arp.ProdID00
      WHEN '{90150000-0011-0000-0000-0000000FF1CE}' THEN '32Bit'
      WHEN '{90150000-0011-0000-1000-0000000FF1CE}' THEN '64Bit'
      END BitType,

      It does mark 32Bit in the field, but it does not mark 64Bit and just shows almost duplicate numbers.

      Office Edition Office Version BitType Total
      Microsoft Office Professional Plus 2013 15.0.4420.1017 32Bit 792
      Microsoft Office Professional Plus 2013 15.0.4420.1017 789
      Microsoft Office Professional Plus 2013 15.0.4569.1506 32Bit 7996
      Microsoft Office Professional Plus 2013 15.0.4569.1506 7998

      To the List Client report I added the ProdID00 field and it is showing 2 values, the actual Product ID (numerical) and also another value (alpha) Office15.PROPLUS.

      Am I on the right track, or wasting my time trying to use arp.ProdID00 or other means to get 32/64bit?

      Thanks
      LisaM

      Reply
      • Eswar Koneti on

        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
          • Eswar Koneti on

            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

    This site uses Akismet to reduce spam. Learn how your comment data is processed.