How to Export Managed Device Details from Intune using MEM Admin Center / PowerShell SDK for Intune

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.

MEM | Device Details | Add / Remove columns

To export the device details, click on Export

MEM | Export Device Details

A Popup will appear with below options. Select the option which you want to go for and click on Yes.

MEM | Intune | Export Device Details

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.

MEM | Notification

The exported data will be downloaded in .zip format. To open the file, double click on downloaded zip file and then open CSV file.

MEM | Exported Device Data

You can open CSV file in Microsoft Excel and analyze the data.

https://endpoint.microsoft.com/#home

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

MEM | Get-IntuneManagedDevice

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

MEM | Export Intune Managed Devices

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

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top