![]() ![]() ![]() Microsoft Office 2021 for Mac – October 13, 2026 Microsoft Office 2019 for Mac – October 10, 2023 Microsoft Office 2016 for Mac – October 13, 2020 ![]() Microsoft Office 2011 for Mac – October 10, 2017 Michael Spice can help you with replacement and updating to a supported version of Office, Windows and Windows Server. You should not run software that is not supported, since it may contain security issues that are not fixed and can put your computer and information at risk. Below is a list of software that has or soon will reach its end of life and support. 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.Microsoft has a support lifetime for each of their products. 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. This is something need to be looked at using SQL code. Happy reporting! Filed in: CM2012, configmgr, ConfigMgr (SCCM), Configmgr 2012, Reporting Services, SCCM, SCCM 2007, SCCM 2012, SCCM 2016, SCCM Reports, SQL Queries, SSRS, SSRS Reports, System Center 2012 Configuration Manager, System Center Products Tags: 32bit 64bit office, configmgr, count of office versions, retail, SCCM, SQL, SQL Report for Office, SSRS, trail version, volume licensed You can always edit the RDL files ,customize it. Parameter for UserSIDs:General->Parameter visibility->Internal, default values->Get values from a query and choose DatasetAdminID Parameter for UserTokenSIDs: General->Parameter visibility->Internal, default values->specify values-> =(User!UserID) 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. 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. This report supports RBA (role based administration) functionality. 'Microsoft Office Starter 2016 - English'Īs 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. 'Microsoft Office Professional Plus 2016 (Beta)' 'Microsoft Office Home and Business 2016' 'Microsoft Office Professional Plus 2016' 'Microsoft Office Starter 2013 - English' 'Microsoft Office Professional Plus 2013 (Beta)' 'Microsoft Office Home and Business 2013' 'Microsoft Office Professional Plus 2013' 'Microsoft Office Starter 2010 - English' 'Microsoft Office Professional Plus 2010 (Beta)' 'Microsoft Office Home and Business 2010' 'Microsoft Office Professional Plus 2010' 'Microsoft Office Professional Plus 2007 (Beta)' 'Microsoft Office Professional Plus 2007' 'Microsoft Office Professional Hybrid 2007' 'Microsoft Office Professional 2007 Trial' If you have any other office editions which are not in below list ,please edit the report and append it. For more information about SQL views in SCCM, please refer įollowing are the office editions are added into the report. This product ID is stored in different SQL views in CM database ,of which we are going to utilize v_Add_Remove_Programs. If you read support article ,there are lot of other information like release version (RTM,SP1,SP2 etc) ,release type (Volume,retail,trail) , įrom the product code ,21st character from left ( substring(productID,21,1) ) will tell you if it is 32bit or 64bit. This product is that we use to uninstall any software using msiexec /x /xīelow is the screenshot from the support article. 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. I have lot of requests /posts in my To-DO list to blog about ,but due to time limitations ,i cannot bring all them. 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.īoth the versions with ssrs report can be found on andĪfter 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. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |