Question

Your organization requires a nightly, automated export of the full Intune managed device inventory (approximately 40,000 devices) into a data lake for a custom Power BI model. A scheduled service runs unattended using an app registration. The built-in reports in the Intune admin center cannot be scheduled, and manual CSV exports are capped and cannot be automated. Which approach should you implement to retrieve the complete dataset reliably each night?

Accepted Answer

Call the Microsoft Graph exportJobs endpoint (deviceManagement/reports/exportJobs) to request the Devices report, then poll the job status and download the resulting file when the state is 'completed'.

Answer

Query the deviceManagement/managedDevices endpoint page-by-page and rely on the default response, since Graph returns all 40,000 records in a single call.

Answer

Configure a recurring email subscription on the Intune Devices report so the CSV is delivered nightly to a shared mailbox for automated parsing.

Answer

Use the Intune Data Warehouse OData feed with an interactive user sign-in each night to pull the device entity into the data lake.