Let’s SCCM Microsoft 365 App Report Dashboard. This post is a continuation of Part1, in my previous we imported two Raw data reports that gave us information about different Microsoft Office versions and Information on Office 365 Inventory after enabling the Hardware class.
In this post, we will create a Dashboard by importing the rdl file and see how can we interlink the previous post with this one. We will also understand a few Columns which we have enabled in the Hardware Inventory of ‘Office365 ProPlusConfigurations‘ and how to use those columns.
Microsoft has defined different channels when it comes to Managing 365 Apps. With the help of updated channels, you can control how often your organization gets the new features.
Different Types of channels
The following table gives the details of types of Office 365 channels.
|New name||Previous name|
(sometimes referred to as Insider Fast)
|Current Channel||Monthly Channel (Targeted)|
(sometimes referred to as Insider Slow)
|Current Channel||Monthly Channel|
|Monthly Enterprise Channel|
|Semi-Annual Enterprise Channel (Preview)||Semi-Annual Channel (Targeted)|
|Semi-Annual Enterprise Channel||Semi-Annual Channel|
Channels and CDN Values
The channels and CND values for Office 365 or Microsoft 365 apps are given in the below table.
|Channel Name||CDN Values|
|Semi-Annual Enterprise channel(Preview)||http://officecdn.microsoft.com/pr/b8f9b850-328d-4355-9145-c59439a0c4cf|
|Semi-Annual Enterprise Channel||http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114|
|Monthly Enterprise Channel||http://officecdn.microsoft.com/pr/55336b82-a18d-4dd6-b5f6-9e5095c314a6|
Note: To know more information on Update channels follow the Overview of Update channels
Columns of O365ProplusConfigurations
After enabling the hardware inventory of O365Proplusconfigurations we get information on different columns.
|Hostname||Hostname of machine|
|Architecture||x86 or x64|
|Version||a version of O365 installed|
|UpdateEnable||True or False|
|OfficeMgmtCOM||True or false|
|Client Folder||Click to run Path|
|Installation Path||Application installation Path|
|Auto Upgrade||Yes or No|
|CCM Managed||Yes or No|
By default, installations of Microsoft Office are configured to automatically update your Office installation when new updates are made publicly available. But many environments prefer to update it in a controlled manner. This column tells us the information if auto-update is ‘enabled’ or ‘disabled’.
Below is the registry key which either you can manage via GPO or via SCCM Baseline and change according to your environment.
- Microsoft 365 Apps for enterprise, Office 2019, and Office 2016
- Office 2013
- DWORD: EnableAutomaticUpdates
0 = automatic updates are disabled
1 = automatic updates are enabled
- DWORD: HideEnableDisableUpdates
1 = hide the menu option to enable or disable automatic updates
0 = show the menu option to enable or disable automatic updates
There are different options available on how we can manage Microsoft Office 365 apps.
Office 365 clients to receive updates from Configuration Manager
This Option provides us with three methods that can be used so that Office 365 clients can receive updates from Configuration Manager.
You can configure the client settings using the following method. This helps to define the inventory for O365. In the Configuration Manager console, click Administration > Overview > Client Settings.
Open the client settings, click Software Updates and select Yes for the Enable management of the Office 365 Client Agent setting.
You can enable Configuration Manager to manage Office updates on specific computers by using Group Policy. You can apply this setting to multiple computers, an organizational unit (OU), or a domain.
To use Group Policy, do the following:
- Download and install the Administrative Template files (ADMX/ADML) for Office from the Microsoft Download Center.
- Enable the Management of Microsoft 365 Apps for enterprise policy setting. You can find this policy setting under Computer Configuration\Policies\Administrative Templates\Microsoft Office 2016 (Machine)\Updates.
Office Deployment Tool
If you have used Office Deployment Tool then you can have settings in the configuration.xml file to achieve the results
<Configuration> <Add OfficeClientEdition="32" Channel="Current" OfficeMgmtCOM="True" > <Product ID="O365ProPlusRetail"> <Language ID="en-us" /> </Product> </Add> <Updates Enabled="True" /> </Configuration>
Office 365 clients to receive updates from the Office CDN
You can follow the steps tp receive updates from Office CDN. In the Configuration Manager console, click Administration > Overview > Client Settings.
Open the appropriate device settings to enable the client agent. For more information about default and custom client settings, see How to configure client settings in Microsoft Endpoint Configuration Manager.
- Click Software Updates and select No for the Enable management of the Office 365 Client Agent setting.
Download and install the Administrative Template files (ADMX/ADML) for Office from the Microsoft Download Center.
Disable the Management of Microsoft 365 Apps for enterprise policy setting. You can find this policy setting under Computer Configuration\Policies\Administrative Templates\Microsoft Office 2016 (Machine)\Updates
Note – The Microsoft Office Click-to-Run Service is responsible for registering and unregistering Office COM applications during service startup. Change domain policy or Configuration Manager client settings require explicit Disable selection for Office COM to be successfully deregistered and restore the default configuration. Toggling Management of Microsoft 365 Apps for enterprise via Group Policy or Client Settings for Configuration Manager from Enabled to Not Configured is not sufficient.
- For more detailed information check Managing 365 Apps.
Office 365 – Microsoft 365 App Report -Dashboard
Download the RDL file ‘Microsoft Office Client Management Dashboard’ Download and use the same the get below the dashboard. The highlighted section below links to the RDL file provided in the previous posts.
For larger environments, the pie charts have been selected as Top 10 in decreasing order of count which can be changed accordingly.
How to edit a report check Create Custom Report using Report builder.
After uploading the report edit it in ‘Report Builder’, select the highlighted column in Report builder, and right-click to select ‘text box properties’.
Inside text box Properties, go to the Actions tab and select the option below, you have to browse the previous ‘Different Office Version’ Report here.
Do the same for the O365 Inventory report and browse the same in the other highlighted section in the first image and it’s done.
Now when you will run this dashboard report and click on the highlighted section it will redirect you to Raw Data for the same dashboard.
In this post, we learned about Different columns, how to Manage Office 365 updates with different options, Auto upgrade features, etc.
Wait for my next post which will be Part3 which will have some more useful information and will help you in Upgrading your Microsoft Office.
1 thought on “SCCM Microsoft 365 App Report Dashboard | Part 2 | ConfigMgr”
I can see that you are referencing “Different Office Version” report. Where can i find that report? On the github there are 4 reports and none are “Different Office Version”