This post describes how to inventory Office 365 using SCCM 1606. We will also provide a free report at the end of the post that you could use on your Reporting Point to easily display Office 365 inventory data.

SCCM 1606 introduces new hardware inventory classes for Office 365 configurations. You no longer need to edit your MOF files to gather Office 365 inventory. If you are using SCCM 1602 or below, follow Jason Sandys post which describes Office 365 inventory process using a MOF customization.

If your goal is to deploy Office 365 updates, refer to our post on how to manage Office 365 updates using SCCM.

SCCM Office 365 inventory report post summary :

  • Office 365 Inventory Data explained
  • How to enable Office 365 Inventory classes
  • Verify Office 365 Inventory data on a client
  • How to upload and use our free Office 365 report

SCCM Office 365 Inventory Report – Direct Download link

SCCM Office 365 Report

If you don’t want to read the whole post, you can download the RDL file directly using this link :

  • You can download this free report by visiting our product page. The Asset – Office 365 report is available in the Report / Asset Section.

Office 365 Inventory Data

Office 365 is using new update channels and update mechanisms. Tracking versions and update channels is an important task. The good news is that it’s easy to do using SCCM 1606 but the data needs to be interpreted as it’s not straightforward (mostly for the update channel).

Here’s the complete definition of the update channel and its meaning :

Update Channels

ChannelValues
Insider Preview / Monthly (Targeted)http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be
Monthlyhttp://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60
Semi-Annual (Targeted) http://officecdn.microsoft.com/pr/b8f9b850-328d-4355-9145-c59439a0c4cf
Semi-Annualhttp://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114

Other data

Here’s the definition of other information gathered by the new hardware class. We haven’t found definitions for all fields, unfortunately, Technet documentation is not completed. If you have any information on your environment, feel free to share it using the comment section.

FieldValue Example
InstallationPathC:\Program Files (x86)\Microsoft Office
ClientInstallationFolderC:\Program Files\Common Files\Microsoft Shared\ClickToRun
VersionToReport (Version)16.0.6741.2056
ClientCulture (Language)en-us / fr-fr
CDNBaseUrl (Channel)See Channels table
UpdatesEnabledTrue / False
Platform (Architecture)x86 / x64
LastScenarioUpdate
LastScenarioResultsSuccess / Failure
CCMManagedUpdateNotify Object
AutoUpgradeTrue / False
GPOChannelSee Channels table
OfficeMgmtCOM?
SharedComputerLicensing?
UpdateURL?

How to enable Office 365 Inventory

After upgrading to SCCM 1606, your Default Client Settings should already gather the new inventory class. Here’s the step to check if it’s enabled :

  • Open the SCCM Console
  • Go to Administration / Client Settings
  • Right-Click your Default Client Setting, select Properties
SCCM Office 365 inventory report
  • Click on Hardware Inventory
  • Click on Set Classes
SCCM Office 365 inventory report
  • Ensure that Office365ProPlusConfiguration is enabled, click OK (remove unneeded field if necessary)
SCCM Office 365 inventory report

Verification

Now that our classes are enabled, trigger a Machine Policy Retrieval & Evaluation Cycle (to have the latest Client Settings) followed by an Hardware inventory Cycle on a computer that has Office installed. Once the inventory is completed, check the inventory using Resource Explorer :

  • In the SCCM Console
  • Right-Click your device, select Start / Resource Explorer
  • Confirm that you have OFFICE365PROPLUSCONFIGURATIONS listed
SCCM Office 365 inventory report

SCCM Office 365 inventory report

Now that your inventory is gathering Office 365 data, we created a report to display the results. This report is free to use.

Sccm office 365 report

To use the report :

Is this information useful? Share your comments using the comment section.

Comments (98)

Viv

06.14.2017 AT 10:07 PM
Thanks for the report. Is it possible to add Collection parameter on the report?

Guy

06.08.2017 AT 03:52 AM
I can enter my email and get the download link but the zip file is 0Kb. Tried in various browsers and on different internet connections......

Benoit Lecours

06.21.2017 AT 09:00 AM
This issue should now be fixed.

Hussein

06.07.2017 AT 05:34 PM
Download Link not working.

Freyr

06.07.2017 AT 10:27 AM
Is there no way to download this report without entering an email, I constantly get that "Cheatin' huh?" page.

John

06.06.2017 AT 10:01 AM
The download link still does not work - and never has. Can you please FIX?

Neil

06.05.2017 AT 04:20 PM
Im getting these errors Microsoft.Reporting.WinForms.ReportServerException The report server cannot process the report or shared dataset. The shared data source 'CM_SCD' for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. (rsInvalidDataSourceReference) Stack Trace: at Microsoft.Reporting.WinForms.ServerReportSoapProxy.OnSoapException(SoapException e) at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod) at Microsoft.Reporting.WinForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) at Microsoft.Reporting.WinForms.ServerReport.EnsureExecutionSession() at Microsoft.Reporting.WinForms.ServerReport.SetParameters(IEnumerable`1 parameters) at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerWindowsForms.SetParameterValues_DoWork(Object sender, DoWorkEventArgs e)

Benjamin John

05.29.2017 AT 09:04 AM
Tried different email addresses. All say Cheatin' huh? meh...

Nick

05.21.2017 AT 05:59 PM
Unable to download the SCCM Office 365 Inventory Report. Can you please email it to me? Thank you

Jason Telling

05.18.2017 AT 02:20 PM
I have tried four different browsers, but the report will not download (Cheatin, huh?). Could you sent the report to me directly?

Marc R.

05.08.2017 AT 12:33 AM
The link to download the report is not working ! Getting a "Cheatin' huh" everytime I enter my email. Is it possible to fix this or send it to me by email. Thanks

Marc R.

05.08.2017 AT 12:38 AM
Never mind, worked by using a gmail address.

Brad

05.01.2017 AT 09:23 AM
Unable to download the 365 report. Can you send it directly to me?

Russell

04.20.2017 AT 07:51 PM
Followed the instructions - worked great. Thanks. Great addition to help troubleshoot our lack of O365 updating 🙂

Philipp Ketelhut

04.18.2017 AT 04:47 AM
Firefox, IE 11, Edge, IE 11 with comp. Mode, Safari on MacOS as well es on iPhone and Android Browser. No Luck to get this report. this is not a good solution. 🙁

Benoit Lecours

04.18.2017 AT 05:50 AM
Hi Philipp, Any errors? Which version of SCCM are you running ?

Denise Pellegrini

03.27.2017 AT 05:41 AM
How can I get this report - I am having the same issues as the others who have posted here. I am using Internet Explorer. I really really need to have this report. 🙂

Iamsiraskalot

03.24.2017 AT 10:01 AM
Can I please get this report as well?

Iamsiraskalot

03.24.2017 AT 10:03 AM
Nevermind, you can only use IE apparently. I was using Safari. Thanks Dudes, you guys are awesome.

Martin Williams

03.06.2017 AT 02:47 PM
Has the report been removed? when I try to obtain it via my email address I get a page which states "Cheatin' huh?"

Martin Williams

03.06.2017 AT 02:52 PM
It would seem that my problem was a google chrome one. I was able to download the report via IE 11.

Leon

02.27.2017 AT 02:26 AM
Hi, I have bought your full bundle reports for SCCM already and really like them but I am trying to download this report and cannot. Please can we get this report or get the link sorted out?

Benoit Lecours

02.27.2017 AT 12:32 PM
Hi Leon, It's just a matter of entering your email address to download it. Maybe you could try a different address from the one you bought the bundle ? Let me know, otherwise I could send it to you directly.

tod elliott

07.25.2017 AT 05:05 PM
hi, can i please get the report. I am unable to download it no matter what browser i use

Denise Pellegrini

03.27.2017 AT 05:46 AM
Could you send to me directly Benoit? I have put two different email addresses and the same thing occurs each time.

Kaspars

02.17.2017 AT 08:42 AM
Cant download your report file. Please help.

Denise Pellegrini

03.27.2017 AT 07:21 AM
nevermind - i was able to grab the report using Microsoft Edge. Thank you.