Managed devices are devices that are under some sort of organization control. You administrator can setup or restrict some feature or control how device can be used. The devices managed by Microsoft Intune are called Intune Managed Devices.
The Managed Devices details can be exported from Microsoft Endpoint Manager Admin Center. We can also use PowerShell SDK for Microsoft Intune Graph API to export the device details in CSV file.
In this article
- Export device details from Endpoint Manager Admin Center
- Export device details using PowerShell SDK for Microsoft Intune Graph API
Export Device Details from Endpoint Manager Admin Center
Sign in Into Microsoft Endpoint Manager Admin Center and Navigate to Devices > All Devices
When you export the data from Endpoint Manager admin center, you will have two options.
- Only include the selected column in exported file
- Include all exported data in exported file
The first option will include all columns visible in current view. If you want to add additional columns or remove any existing columns, then current view can be customized.
To add / remove column in current view, click on Column, and select / unselect column from flyer display and click on Apply.
To export the device details, click on Export
A Popup will appear with below options. Select the option which you want to go for and click on Yes.
The export process will begin. You can monitor the progress in notification area. You may get a dialogue box to save the file once export completed.
The exported data will be downloaded in .zip format. To open the file, double click on downloaded zip file and then open CSV file.
You can open CSV file in Microsoft Excel and analyze the data.
Export Device data using PowerShell SDK for Intune Graph API
We need PowerShell SDK for Intune Graph API to export the data using PowerShell. Follow this article to know how to install PowerShell module for Intune Graph API and connect with MSGraph.
Once connected with MSGraph, you can use Get-IntuneManagedDevice cmdlets to view / export the data from PowerShell.
Let’s go through few examples
List all device with selected inventory details in tabular format
Get-IntuneManagedDevice | select-object deviceName,manageDeviceOwnerType,OperatingSystem,ComplianceState,userName,model,SerialNumber | Format-Table
Export all devices with selected inventory data in CSV
Get-IntuneManagedDevice | select-object deviceName,manageDeviceOwnerType,OperatingSystem,ComplianceState,userName,model,SerialNumber | Export-csv -Path c:\temp\manageddevices.csv
Export all devices with all inventory data in CSV
Get-IntuneManagedDevice | select-object * | export-csv -Path c:\temp\ManagedDevices.csv
Export all inventory data for virtual devices
Get-IntuneManagedDevice | Where-Object {$_.model -match 'Virtual'}| Export-csv -Path c:\temp\virtualdevices.csv
Related Posts
- Install PowerShell SDK for Intune Graph API
- Get AAD Group Members Details Using PowerShell SDK for Microsoft Intune Graph API
