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

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!

17 Responses to "Configmgr report for count of MS office versions with architecture type 32bit and 64bit"

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

Post Comment