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)

Jaime

02.15.2017 AT 10:10 PM
Is it Possible to add a column for users associated to the device.

Andris Brigers

02.15.2017 AT 04:47 AM
Hi! I am having some issues with this Report, could you pleases give me any advice: 1. Do i have to manually change anything in the .rdl file? 2. Which account should i use to Run the report - in case that i use SQL Server as the source? When using SCCM admin account i get this error: (Using SCCM 1610, HW inventory is enabled and showing O365 Config in resource explorer): Microsoft.Reporting.WinForms.ReportServerException Invalid object name 'v_GS_OFFICE365PROPLUSCONFIGURATIONS'. Thank You!

Derek

02.03.2017 AT 09:35 AM
I can't download the report.

Paul

02.14.2017 AT 07:15 AM
I can't download or create an account to sign in. Only option is to log in...but I don't think I have an account yet.

Jordi

01.17.2017 AT 02:52 PM
Thank you for the report! It works great! I have 1 question. I installed O365 using SCCM with First Release Channel, but then I wanted to updated via GPO to Current Channel. The report shows: Channel: Insider Preview / First Release GPO Channel: Current So the GPO is applied... but the Channel doesn't change. Any ideas?

Brandon Katz

01.15.2017 AT 03:59 AM
Hi there, Have you considered a third party analytics solution for your SharePoint portal? A solution like CardioLog Analytics drills down deep to provide much deeper insights than those available in SharePoint or Google analytics.It’s available as an On-Prem or SaaS deployment. The solution is specifically built for SharePoint, so it’s tailored to provide analytics specifically on SharePoint’s architecture. If you’re looking for more information regarding your portal visitors, navigation paths, search behaviors, and content performance check out http://www.intlock.com Hope this helps!

Jerome STIVAL

12.29.2016 AT 10:12 AM
I'm unable to download your RDL (tested with my professional email and personal email), could you send me directly by email, please ?

Benoit Lecours

01.05.2017 AT 02:52 PM
Incoming

J. Telling

05.18.2017 AT 02:50 PM
I also cannot download the report. Could you send it to me please? Thank you

John Johnson

01.12.2017 AT 10:54 AM
I also cannot get the file to download, could you send it too me. Thanks in advance.

Rick Gates

10.03.2016 AT 03:56 PM
Is it possible to add an install date field, we need to capture the install date of Office 365

Sandy

09.01.2016 AT 05:59 AM
Why "AutoUpgrade" is empty?

Benoit Lecours

09.06.2016 AT 12:42 PM
Unfortunately the Technet documentation is limited on that topic. We assume that it's related to the "Enable Updates" option (in Office) on a SCCM managed client. https://support.content.office.net/en-us/media/8418d80f-06ff-419b-b5cd-11018f96b40c.png It's also empty on our side.

Bruce

09.07.2016 AT 02:12 AM
For me some show enabled some don't. I believe the Office365 setting in hardware inventory are enabled by default because mine were already on but on the report it only show 38 computers out of 600+.