Starting in SCCM 1610, you can use the new Office 365 Client Management dashboard from the Configuration Manager console. This is the fourth dashboard since the Current Branch release which is a great effort from the product group to give better visibility on the data gathered by your Configuration Manager clients. We already made an overview of the Windows 10 Servicing dashboard and the Software Update dashboard if you’re interested to read that out. You can also refer to our post about managing Office 365 Updates with SCCM and our free Office 365 report if want complete information about how to deploy and inventory Office 365 in your environment.
SCCM Office 365 Client Management Dashboard Overview
To open the dashboard :
- Open the SCCM console
- Go to Software Library / Office 365 Client Management
The dashboard displays charts for the following:
- Number of Office 365 clients
- Office 365 client versions
- Office 365 client languages
- Office 365 client channels
You can also create an Office 365 Automatic Deployment Rule and Office 365 Client Setting directly from the dashboard.
At the top of the dashboard, use the Collection drop-down setting to filter the dashboard data by members of a specific collection.
The Office 365 Clients section show the number of Office 365 clients in the selected collection.
The Office 365 Client Versions section shows the breakdown per version. You can refer to the Technet article for a full list of Office 365 versions. The pie chart show an hand icon when you hover over it but you cannot click it to have a detailed list of clients.
The Office 365 Client Language section shows the breakdown per language. The chart is not clickable.
The Create ADR button let you launch the Automatic Deployment Rule wizard to create an Office 365 rule. The wizard is the same as if you create one by going to Software Library \ Software Updates \ Automatic Deployment Rules
The Create Client Settings button let you create a Client Setting to manage Office 365 updates.
The Office 365 Client Channels section shows the breakdown per channel. As the other charts, it’s not clickable. You can refer to the Technet article for full list of Office 365 Channels
If you have created an Automatic Deployment Rule, the deployment statistic will show in the Office 365 Deployments Summary section. You can select your ADR from the drop down menu. If you haven’t created an ADR, this pane will be empty.
Loading? I cannot see it at all anymore and we have upgraded to 1806, ugh.
We recently started looking at deploying Office 365 to our environment and finally took a look at the 0365 Client Management Dash board. We were experiencing the same loading tile issue that seems to be plaguing certain environments. (We are currently running SCCM 1802 Hotfix KB4163547)
I believe we may have found a fix for this issue (it at least fixed the loading tile issue in our environment).
I was digging around the SMSProv.log on the server and ran across the following error string. This error string occurs anytime someone uses their console and tries to open up the 0365 Client management dashboard.
*** EXEC spDashboardsGetChartData @chartGuid=N’0eee5653-518b-4508-b00c-d4766b39b79c’, @chartConfigData=N’SMS00001′, @userSids=N’010500000000000515000000F6E1A4E57A8C1ED2E5132F3A1FB00100,010500000000000515000000F6E1A4E57A8C1ED2E5132F3A52BE0100,010500000000000515000000F6E1A4E57A8C1ED2E5132F3A64890100′ $$
*** [Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object ‘spGetO365ClientCount’, database ‘CM_UJS’, schema ‘dbo’. : spGetO365ClientCount $$
~*~*~[Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object ‘spGetO365ClientCount’, database ‘CM_***’, schema ‘dbo’. : spGetO365ClientCount ThreadID : 1464 , DbError: 229 , Sev: 14~*~*~ $$
~*~*~..\sspconsoledashboards.cpp(70) : SQL command failed: ~ SQL Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object ‘spGetO365ClientCount’, database ‘CM_***’, schema ‘dbo’. : spGetO365ClientCount~*~*~ $$
We showed that error string to our DBA. He was able determined that the userSid trying to run the command was “smsdbuser_ReadOnly” on our SCCM DB. Our DBA gave that “ReadOnly account” execute rights to our SCCM DB and the console is displaying as it should be.
My Dashboard was working no problem up to this week monday. same “loading data” problem.
Any resolutions found yet?
Running 1710 with the new hotfix (KB4057515) and the dashboard is showing everything (was showing everything before the hotfix as well). No problem loading data. Does everyone here not able to see the data have GPO turned on for CM to manage the O365 updates? Client settings have CM mgmt. turned on? Installed the client with the OfficeMgmtCOM=”True” inside your install xml files?
My only problem is the data is not refreshing or reflecting the correct count of machines.
Noticed something strange. O my Office 365 Client Management Dashboard is missing the “Office 365 Installer” Button. Do you guys have same issue?
Are you running 1702 ?
Something new? Same problem with “Loading data”…have two primary SCCM (2008 R2 and 2012 R2) servers in different domains and last version of SCCM.
This is still a problem but no solution so far.
Same issue with “Loading Data,,,”
This is unfortunately a known issue and there’s no resolution as for now. Will update when I’ll have more information from the product group.
Any updates on this?
My dashboard also shows “loading data.” It was working on 1/17/17 so not sure why it stopped. Will see if rebooting the server fixes it.
Just updated to v1610 and am seeing the same thing as Rob. Not finding much of anything as to the cause, other than a quick reply on technet saying this was a known issue. Can’t seem to find a workaround either.
Great write up. This dashboard stopped working for me last week. All of the tiles are stuck on “Loading Data”. Has anyone else encountered this?