Create Custom Intune Reports for Devices Similar to SCCM/MECM

Courtney Regan 71 Reputation points
2023-02-23T17:29:37.8733333+00:00

Hi All - We've been using SCCM forever and also Intune AutoPilot for the last year. Our Windows devices are co-managed. In SCCM I have created endless queries for reporting purposes. However the Intune/MEM web interface is limited compared to what specific information/attributes I can report on compared to the SCCM console. With SCCM the possibilities are endless like the below query. What is the intune equivalent way to pull the below data out of our Azure AD systems into an excel report? I need customization that SCCM affords. MS Graph is what I hear but I'm new to that. If MS Graph is the way to go, how would I go about getting the below like information?

User's image

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,238 questions
Windows Autopilot
Windows Autopilot
A collection of Microsoft technologies used to set up and pre-configure new devices and to reset, repurpose, and recover devices.
430 questions
Microsoft Intune Reporting
Microsoft Intune Reporting
Microsoft Intune: A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.Reporting: The process of giving an account of something that has been observed, heard, done, or investigated.
66 questions
Microsoft Intune
Microsoft Intune
A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.
4,657 questions
Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Garth 411 Reputation points
    2023-02-23T23:28:29.11+00:00

    Graph or maybe the Intune Data warehouse is the way to go.

    BTW if you are pulling it into Excel, I would look at Power BI to create the report that you can reuse.

    0 comments
  2. Crystal-MSFT 45,571 Reputation points Microsoft Vendor
    2023-02-24T01:34:05.0233333+00:00

    @Courtney Regan, Agree with Garth, Here is a blog list the steps using PowerBI to build custom reports with Intune data. You can read it as a reference:

    https://techcommunity.microsoft.com/t5/intune-customer-success/support-tip-using-powerbi-to-build-custom-reports-with-intune/ba-p/294970