Domain 5 β€” Module 3 of 5 60%
30 of 32 overall
Domain 5: Optimize Endpoint Operations Free ⏱ ~11 min read

Intune Reporting, Workbooks & Data Export

Intune's reporting framework has four report types, and each answers a different question. Knowing which one to reach for β€” and how to get the data out via Graph β€” is the difference between a five-minute answer and a five-hour export.

The four report types

Simple explanation

Intune has four flavours of report, and they differ by how fresh the data is and how much of it you get.

One is for β€œwhat is broken right now”, one is for β€œwhat does the whole estate look like”, one is for β€œhow has this changed over months”, and one is for β€œgive me the raw data so I can build my own thing”.

Report typeAnswersData characteristics
Operational”What needs my attention right now?”Timely, targeted, record-level, drill-down, filterable
Organizational”What does the whole estate look like?”Broad summary across the tenant
Historical”How has this trended?”Aggregated over time, pattern and trend analysis
Specialist”Give me the raw data”Raw datasets built for export and custom reporting
Exam tip: pick the report type from the verb

The question rarely names the report type β€” it describes a need:

  • β€œidentify the devices that failed enrolment today” β†’ Operational
  • β€œgive leadership a summary of the whole fleet” β†’ Organizational
  • β€œshow whether compliance has improved over six months” β†’ Historical
  • β€œfeed our own Power BI model with raw records” β†’ Specialist

If the requirement mentions another tool consuming the data, you are being pointed at export, not at the portal.

Where reports live

Reports appear in two places, and both are examinable:

  • Reports node β€” the central reporting hub, organised by area (device compliance, app install status, endpoint analytics, and so on)
  • In context β€” inside the object you are looking at. A configuration profile has its own per-setting and per-device status, and that is usually the fastest path when troubleshooting a single policy.

If a question describes an admin troubleshooting one profile on one device, the in-context report on that profile beats navigating to the Reports node.

Filtering and customising

Most reports support column selection and filtering before you generate them, which matters for two reasons: readability, and export size. Generating a filtered report is significantly cheaper than exporting everything and filtering afterwards.

Scope tags are not a report filter

A recurring trap: an admin β€œcannot see” devices in a report.

Before blaming the report, check role-based access control and scope tags. Intune reports honour RBAC β€” an administrator scoped to one region sees only that region’s objects. The report is not broken; the scope is doing its job.

Distinguish clearly:

  • Filters (in the Assignments sense) target who a policy applies to
  • Scope tags control which objects an admin can see and manage
  • Report filters just narrow what is displayed

A question that says β€œthe report is empty for one administrator but populated for another” is almost always a scope tag question.

Workbooks and dashboards

For anything beyond the built-in reports, Intune data can be routed to Azure Monitor, where workbooks provide customisable, visual, shareable reporting.

Built-in reports vs Azure Monitor workbooks
FeatureBuilt-in Intune reportsAzure Monitor workbooks
SetupNone β€” available immediatelyRequires routing Intune diagnostic data to a Log Analytics workspace
CustomisationColumn and filter selectionFull query-based visualisation and layout control
CostIncludedAzure Monitor / Log Analytics ingestion and retention costs apply
RetentionService-definedControlled by the workspace retention settings
Best forDay-to-day operationsLong-term trends, cross-source correlation, executive dashboards

The exam signal for workbooks is long retention or combining Intune data with other sources. If a scenario needs two years of history, built-in reports are the wrong answer.

Getting the data out

Three routes, and the right one depends on volume and repeatability.

RouteGood forLimitation
Export button in the portalOne-off, human-sized extractsManual; not repeatable
Graph export jobs (deviceManagement/reports/exportJobs)Scheduled, automated extractionAsynchronous β€” you must poll
Data warehouse / OData feedBI tools consuming historical dataAggregated, not near-real-time

The export job pattern

Graph report export is asynchronous, and this is the detail exams like:

Connect-MgGraph -Scopes "DeviceManagementManagedDevices.Read.All"

# 1. Request the export job
$job = Invoke-MgGraphRequest -Method POST `
  -Uri "https://graph.microsoft.com/beta/deviceManagement/reports/exportJobs" `
  -Body (@{ reportName = 'Devices'; format = 'csv' } | ConvertTo-Json)

# 2. Poll until status is 'completed', then download from the returned URL

You do not get the file back from the first call. You submit a job, poll its status, and then download from the URL the service returns once it is complete. An answer option claiming the POST returns the CSV directly is wrong.

Question

Which Intune report type provides raw data intended for custom reporting?

Click or press Enter to reveal answer

Question

A report is empty for one administrator but populated for another. What is the most likely cause?

Click or press Enter to reveal answer

Question

You need two years of Intune trend data combined with sign-in data. Built-in reports or workbooks?

Click or press Enter to reveal answer

Question

Is the Microsoft Graph reports export synchronous?

Click or press Enter to reveal answer

Question

Which Intune report type is designed for what needs attention right now?

Click or press Enter to reveal answer

Knowledge Check

Leadership wants a monthly compliance trend chart covering the last 18 months, combined with Microsoft Entra sign-in data. What should you implement?

Knowledge Check

A script posts to the deviceManagement reports exportJobs endpoint but receives no file content in the response. What is happening?