Close Menu
    Facebook X (Twitter) Instagram
    Sunday, July 13
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»CM2012»Configmgr report for count of MS office versions with architecture type 32bit and 64bit

    Configmgr report for count of MS office versions with architecture type 32bit and 64bit

    Eswar KonetiBy Eswar KonetiNovember 02, 11:53 am4 Mins Read CM2012 18,534 Views
    Share
    Facebook Twitter LinkedIn Reddit

    This blog post is going to be version 3 on the same topic (report for MS office versions) but with different requirements.My previous posts on ssrs report for count of MS office versions and drilled report to see client names etc will have some limitations like they will not give you bit type(architecture) like 32bit or 64bit of office installed on the client. They simply get the count of the MS office edition installed and then drill down further to get you the list of client computers with office edition,version,its OS and hardware scan date info.

    Both the versions with ssrs report can be found on https://gallery.technet.microsoft.com/office/SCCM-Configmgr-Report-for-2c36f1b9 https://gallery.technet.microsoft.com/office/SCCM-Configmgr-2012-SSRS-c482cca2 and

    https://support.microsoft.com/en-us/help/928516/description-of-product-code-guids-in-2007-office-suites-and-programs

    After posting these 2 reports, blog viewers ,TechNet gallery and in forums have asked to get bit type (32bit or 64bit) information for the office product that is installed on the client.

    I have lot of requests /posts in my To-DO list to blog about ,but due to time limitations ,i cannot bring all them.

    So for this requirement to get 32bit and 64bit for MS office ,i found microsoft article to identify if the MS office is 32bit or 64bit. https://support.microsoft.com/en-us/help/928516/description-of-product-code-guids-in-2007-office-suites-and-programs and it is based on the product code.

    This product is that we use to uninstall any software using msiexec /x {productID} /x

    Below is the screenshot from the support article .

    image

    From the product code ,21st character from left (substring(productID,21,1) ) will tell you if it is 32bit or 64bit .

    0 for x86

    1 for x64

    If you read support article ,there are lot of other information like release version (RTM,SP1,SP2 etc) ,release type (Volume,retail,trail) ,

    This product ID is stored in different SQL views in CM database ,of which  we are going to utilize v_Add_Remove_Programs. For more information about SQL views in SCCM, please refer https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b

    Following are the office editions are added into the report . If you have any other office editions which are not in below list ,please edit the report and append it.

    'Microsoft Office Personal 2007'
    'Microsoft Office Professional 2007'
    'Microsoft Office Professional 2007 Trial'
    'Microsoft Office Professional Hybrid 2007'
    'Microsoft Office Professional Plus 2007'
    'Microsoft Office Professional Plus 2007 (Beta)'
    'Microsoft Office Standard 2007'
    'Microsoft Office Standard 2007 Trial'
    'Microsoft Office Ultimate 2007'
    'Microsoft Office Enterprise 2007'
    'Microsoft Office Ultimate 2007'
    'Microsoft Office Ultimate 2007'
    'Microsoft Office 2010'
    'Microsoft Office Professional Plus 2010'
    'Microsoft Office Standard 2010'
    'Microsoft Office Professional 2010'
    'Microsoft Office Home and Student 2010'
    'Microsoft Office Home and Business 2010'
    'Microsoft Office Professional Plus 2010 (Beta)'
    'Microsoft Office Starter 2010 - English'
    'Microsoft Office 2013'
    'Microsoft Office Professional Plus 2013'
    'Microsoft Office Standard 2013'
    'Microsoft Office Professional 2013'
    'Microsoft Office Home and Student 2013'
    'Microsoft Office Home and Business 2013'
    'Microsoft Office Professional Plus 2013 (Beta)'
    'Microsoft Office Starter 2013 - English'
    'Microsoft Office 2016'
    'Microsoft Office Professional Plus 2016'
    'Microsoft Office Standard 2016'
    'Microsoft Office Professional 2016'
    'Microsoft Office Home and Student 2016'
    'Microsoft Office Home and Business 2016'
    'Microsoft Office Professional Plus 2016 (Beta)'
    'Microsoft Office Starter 2016 - English'

    As usual ,download the SSRS reports (rdl) files from Technet gallery here ,upload to your reporting folder in SCCM reports,change the data source and run the report.

    Output:

    SNAGHTML2377b296

    Linked report:

    SNAGHTML23790def

     

    This report supports RBA (role based administration) functionality.

    Note that, 2nd report (drilled report) cannot be run individually and to run that, you must run the 1st report which is count of office versions and drill to 2nd report.

    SQL code and parameter values for dataset (RBA): The following information is for your information only and no input required from you to run this report.

    DataSetAdminID:select dbo.fn_rbac_GetAdminIDsfromUserSIDs(@UserTokenSIDs) as UserSIDs

    Parameter for UserTokenSIDs: General—>Parameter visibility—>Internal, default values—>specify values—>=SrsResources.UserIdentity.GetUserSIDs(User!UserID)
    Parameter for UserSIDs:General—>Parameter visibility—>Internal, default values—>Get values from a query and choose DatasetAdminID

    you can always edit the RDL files ,customize it.

    Happy reporting!

    32bit 64bit office configmgr count of office versions retail SCCM SQL SQL Report for Office SSRS trail version volume licensed
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    17 Comments

    1. Denis on December 4, 2021 12:09 PM

      Hello.
      Please send me you report mikhaylovd@outlook.com

      Reply
      • Eswar Koneti on December 4, 2021 12:23 PM

        Hi,
        you can download the technet gallery post using this link http://eskonr.com/2021/02/did-you-miss-to-download-your-samples-from-technet-gallery-here-is-how-you-can-do-it/

        Thanks,
        Eswar

        Reply
    2. Pingback: Identify Office Products with its architecture using SCCM report

    3. Matt on July 24, 2019 11:42 AM

      Thanks for this! Any luck with adding Office 365 versions? It would be a huge help to a lot of people!

      Reply
      • Eswar Koneti on July 24, 2019 12:01 PM

        Hi Matt,
        Not yet but I think I will get this figure out this week.
        Hope I get the reports updated by this week. Let see.

        Regards
        Eswar

        Reply
        • Randy Jones on August 22, 2019 7:42 AM

          I know you’re a busy guy. Have you had any luck on the 365 versions yet?

          –Thanks Randy

          Reply
          • Eswar Koneti on August 22, 2019 7:48 AM

            Hi Randy,
            Yes report is ready. Will post it this week.

            Regards
            Eswar

            Reply
            • Randy on September 27, 2019 5:49 AM

              Are you still working with this?

              Reply
              • Eswar Koneti on October 2, 2019 11:51 PM

                Hi Randy,
                I have published post on this ,here you go https://www.systemcenterdudes.com/sccm-report-office-product/

                Thanks,
                Eswar

    4. Randy Jones on November 29, 2018 11:43 PM

      I love this report. Is there a way to tweak it to also include installations of Office 365?

      Reply
      • Eswar Koneti on December 19, 2018 12:01 AM

        I havent looked at office 365 yet but that would be interested to know 32bit and 64bit. I will take a look at this very soon and post an article on this.

        Thanks,
        Eswar

        Reply
    5. pedroroeseler on June 15, 2018 10:24 PM

      Hi Eswar.

      Thanks for taking the time to share this great report.
      Unfortunately I'm not getting the data I was expecting. We have more than 900 devices and the report only shows less than 100, and not even 1 with a version above 2013.

      Any idea of what's causing this?

      Cheers,
      pedro

      Reply
      • Eswar Koneti on June 17, 2018 12:03 AM

        Hi Pedro,
        this is something need to be looked at using SQL code. If i were u ,i will take the SQL code, identify the PC that is giving wrong information and drill down further into SQL what is wrong.
        Here is the SQL code that is actuall looking for versions: Do you have office editions that do not exist in this ? if so ,please add to the report.

        where (displayname0 ='Microsoft Office Personal 2007'
        OR displayname0 = 'Microsoft Office Professional 2007'
        OR displayname0 = 'Microsoft Office Professional 2007 Trial'
        OR displayname0 = 'Microsoft Office Professional Hybrid 2007'
        OR displayname0 = 'Microsoft Office Professional Plus 2007'
        OR displayname0 = 'Microsoft Office Professional Plus 2007 (Beta)'
        OR displayname0 = 'Microsoft Office Standard 2007'
        OR displayname0 = 'Microsoft Office Standard 2007 Trial'
        OR displayname0 = 'Microsoft Office Ultimate 2007'
        OR displayname0 = 'Microsoft Office Enterprise 2007'
        OR displayname0 = 'Microsoft Office Ultimate 2007'
        OR displayname0 = 'Microsoft Office Ultimate 2007'
        OR displayname0 = 'Microsoft Office 2010'
        OR displayname0 = 'Microsoft Office Professional Plus 2010'
        OR displayname0 = 'Microsoft Office Standard 2010'
        OR displayname0 = 'Microsoft Office Professional 2010'
        OR displayname0 = 'Microsoft Office Home and Student 2010'
        OR displayname0 = 'Microsoft Office Home and Business 2010'
        OR displayname0 = 'Microsoft Office Professional Plus 2010 (Beta)'
        OR displayname0 = 'Microsoft Office Starter 2010 - English'
        OR displayname0 = 'Microsoft Office 2013'
        OR displayname0 = 'Microsoft Office Professional Plus 2013'
        OR displayname0 = 'Microsoft Office Standard 2013'
        OR displayname0 = 'Microsoft Office Professional 2013'
        OR displayname0 = 'Microsoft Office Home and Student 2013'
        OR displayname0 = 'Microsoft Office Home and Business 2013'
        OR displayname0 = 'Microsoft Office Professional Plus 2013 (Beta)'
        OR displayname0 = 'Microsoft Office Starter 2013 - English'
        OR displayname0 = 'Microsoft Office 2016'
        OR displayname0 = 'Microsoft Office Professional Plus 2016'
        OR displayname0 = 'Microsoft Office Standard 2016'
        OR displayname0 = 'Microsoft Office Professional 2016'
        OR displayname0 = 'Microsoft Office Home and Student 2016'
        OR displayname0 = 'Microsoft Office Home and Business 2016'
        OR displayname0 = 'Microsoft Office Professional Plus 2016 (Beta)'
        OR displayname0 = 'Microsoft Office Starter 2016 - English'
        OR displayname0 = 'Microsoft Outlook 2013'

        Regards,
        Eswar

        Reply
    6. Paul Edwards on November 3, 2017 6:45 PM

      I got double-entries for every Office install in my environment because of the Release Type field. As well as an entry for Volume License I was also getting either 'f', 'T', 'A', or 'O' as a second entry even though they are not even listed as possible values on the MS page? I added another clause to the 'Where' statement to get round this - 'substring(sof.prodid0,3,1) not in ('f', 'T', 'A', 'O').

      Reply
      • Eswar Koneti on November 5, 2017 9:58 AM

        Good info Paul. Thanks for sharing.

        Regards,
        Eswar

        Reply
    7. Fred on November 2, 2017 10:33 PM

      I'm not seeing the 64 bit versions listed, only 32 bit.

      Reply
      • Eswar Koneti on November 2, 2017 10:37 PM

        Hi Fred,
        which means you dont have 64bit office ? can you check the product code if you see 1 (x64) as per the article. Let me know what you find.

        Regards,
        Eswar

        Reply

    Leave a ReplyCancel reply

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

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.