SCCM Office 365 Inventory Report

Benoit LecoursHardware Inventory, OFFICE, REPORT, SCCM98 Comments

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.

98 Comments on “SCCM Office 365 Inventory Report”

  1. @Benoit

    I’m also having the same issue. Can someone please help investigate this?

    An error has occurred during report processing. (rsProcessingAborted)
    Query execution failed for dataset ‘DataSet1’. (rsErrorExecutingCommand)
    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    1. We are experiencing the same _sde.v_generalinfo error, running on CB2006. This report came bundled with our purchase of all the custom reports. Anyone figure out why this isn’t working?

        1. Hi Nicolas,

          Thank you for the update. We purchased the entire SCCM Reports Bundle. The new version fixes the issue. I’m curious, what is the difference between the “Asset – Office 365” and “Asset – Office 365 2008” report?

          Thanks!

          1. Hi Abfsailor,

            the only difference is for compatibility with older SQL reporting services. Otherwise, the exact same query.

            Jonathan

  2. @tocatech

    I have the same problem, looking at two separate instances of SCCM and neither have _sde.v_generalinfo as a Table or a View. I’m curious if this was a custom table written for one of the reports.

    An error has occurred during report processing. (rsProcessingAborted)
    Query execution failed for dataset ‘DataSet1’. (rsErrorExecutingCommand)
    Invalid object name ‘_sde.v_generalinfo’.

  3. HI Guys,

    I imported the report but receive an error

    “Invalid object name ‘_sde.v_generalinfo’.
    —————————-
    Query execution failed for dataset ‘DataSet1’. (rsErrorExecutingCommand)
    —————————-
    An error has occurred during report processing. (rsProcessingAborted)”

    When i copy the query from the dataset into SQL management studio i can see it cannot find sde.v_generalinfo view or table….

    Does anyone know why my sccm DB would not have this table or view?
    I’m on version 1910 hotfix KB4537079

  4. Hi thanks for that nice Report. Does anybody has a solution for also getting all the Home and Business Versions?
    The H&B Versions 2016 are named like “Microsoft Office Home and Business 2016 – de-de” , or “Microsoft Office Home and Business 2016 – en-us”.

    I tried to update the query by myself but after that try i got around 45k Office versions instead of something around 5k 🙂

  5. Hi,
    This is a great report, thank you.
    However, I seem to have a bit of an issue and wondered if you could throw some light on it.
    I have over 200 machines that appear in the report that I am certain DON’T have Office365 installed.
    But the only fields that are populated in the report (and in the h/w inventory) are the ‘Key Name’, ‘Version to Report’, and ‘CDN Base URL’. All other fields are empty.
    Any idea why these are populated for a relatively small group of PCs that do not have Office365?

  6. its works perfectly but how to add more dataset? i tried to modify the dataset to show product name as well but it doesnt show.
    i want to see the office products installed?

  7. Hello,
    First, I would like to thank you! Works great! but, I have this issue when I click on the devices name I’m getting this error Device’ cannot be found. (rsItemNotFound).

    Please help. Thanks again

    1. Roland – if you hover over one of the device names in the report, it tells you that you also need the ‘Dashboard – Device’ report for the click-through to work.

    1. Launch the report editor. Then open the first Dataset in the report. Edit the query and add a line for Username after the line for DeviceName, like so:

      SELECT
      SYS.ResourceID DeviceID,
      SYS.Name0 DeviceName,
      SYS.User_Name0,
      OFI.Platform0 Platform,

      Note that you need to do this twice – scroll down the query until you see the UNION statement and then the SELECT statement is repeated. You need to add it here too. Click OK to save the query.

      Then you need to add the column in the report. Click on the ‘Device Name’ column and use ‘Insert Column – right’. Then click in the lower text box and add ‘Username’.

      1. Sorry I missed off part of the line when copying:

        SELECT
        SYS.ResourceID DeviceID,
        SYS.Name0 DeviceName,
        SYS.User_Name0 Username,
        OFI.Platform0 Platform,

  8. I just wanted to say thanks for creating and offering the free report. This is really helpful in our organization! Worked like a charm.

  9. I have uploaded the same RDL and change the Correct Datsource, but not showing any Result for installed O365 ProPlus version – 15.0.4823.1002.

    I am using SCCM CB 1710

  10. Hi There,

    With the latest update to SCCM 1710, the graphs in the report seems to be missing. Is there something additional I need to do. This report was working perfectly before.

  11. HI and thx for your Blog 😉

    what’s the meaning of
    LastScenarioResults Success / Failure in the sql table ?

    All my servers are in a Failure state and when i did a Machine Policy Retrieval & Evaluation Cycle and a Hardware inventory Cycle .
    I don’t get the actual gpo value.

    Is it mean than SCCM is unable to grab the data ?

    Thx

  12. How can I tell the difference between the Office 365 suite being installed and Project Pro or Visio being installed? This report shows any click to run installation and it would be great if they could be differentiated. Let me know.

    1. Hi Jeff,
      Were you able to find the answer for “difference between the Office 365 suite being installed and Project Pro or Visio being installed”. I am in the same boat

  13. Pingback: SCCM; SSRS; Пара базовых отчётов; CPU | RAM has changed; Part1: Скачать отчёты? Что может быть проще! | Sergey Korotkov's Blog

  14. Pingback: Telemetría Office 365 – JoseMCT

  15. Hi, Thanks for this having an issue though. What needs to be put in the “search” field I get prompted with when trying to run the report? I presume channel is the one I use but I’m unsure of what to put in the search box.

    thanks

  16. Hi, Getting this below error while running report on SCCM 1511. Please help

    Invalid object name ‘v_GS_OFFICE365PROPLUSCONFIGURATIONS

  17. First thank you for building this and making it available. I do have a question around the reported office version. I’m running the Monthly channel and the CDNBaseUrl matches that of the Current Channel however the report shows these machines as Unknown\Other. Is this by design?

  18. My understanding that setting client setting to manage O365 will create a registry key:

    HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\office\16.0\common\officeupdate
    “officemgmtcom”=dword:00000001

    Or this can be set with GPO.

    Also after setting the sccm policy to manage O365 “GPO Office Mgmt COM” should be 1

    I have a bunch of clients that do not have this set:

    And i am trying to create a collection for clients where “GPO Office Mgmt COM” != to 1

    select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_Office365ProPlusConfigurations on SMS_G_System_Office365ProPlusConfigurations.ResourceID = SMS_R_System.ResourceId where SMS_G_System_Office365ProPlusConfigurations.GPOOfficeMgmtCOM != “1”

    But i am not getting any results.

    What have i missed?

    Thank you.

  19. I know this post is a bit old but what do i do when the hardware inventory is setup correct but is only displays the Key name in ressource explorer?

  20. As others, I am getting the “Cheating, huh?” message when trying to download the RDL using multiple browsers. Please email if possible.

  21. Hi,

    Having a bit of trouble getting this report, keep getting the “Cheatin Huh?” Message.

    Tried with my corporate & personal mail adresses.

    Could you perhaps email it to me?

    Regards,

  22. Pingback: Hilfreiche ConfigMgr-Reports aus der Community | clientmgmt.de by André Picker [MVP]

  23. 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……

  24. 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)

  25. I have tried four different browsers, but the report will not download (Cheatin, huh?). Could you sent the report to me directly?

  26. 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

  27. 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. 🙁

  28. Pingback: Switch from Office 365 Deferred Channel to Current Channel using SCCM |

  29. 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. 🙂

  30. 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?

    1. 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.

  31. 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!

  32. 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?

  33. 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!

  34. I’m unable to download your RDL (tested with my professional email and personal email), could you send me directly by email, please ?

      1. 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+.

Leave a Reply