How to Export All Devices Data from Intune Portal | Endpoint Manager

Let’s see what are the improvements in Intune. Learn more about Export All Devices Data From Intune Portal (Endpoint Manager portal). Microsoft has recently added a new option for export device data in All devices. This allows you to filter and improve the report. The following new options are available when exporting device data –

  • Only include selected columns in the exported file.
  • Include all inventory data in the exported file.

Related post Backup Your Intune Data and Settings Using Script | MEM

Export All Devices Data From Intune Portal

Let’s Get Started-

Export All Devices Data from Intune Portal | Endpoint Manager
Export All Devices Data from Intune Portal | Endpoint Manager
  • Under All devices, Click on the Export. The popup will appear with following new available options when exporting all managed devices data, Choose the option and Click Yes, This will export data to a comma-separated values (.csv) file.
Only include selected columns in the exported file - The CSV file only includes the columns which you see within the Microsoft Endpoint Manager admin center Under All devices. However you can add or remove the columns for better experience and visibility.


Include all inventory data in the exported file - The CSV file includes all available inventory data in your report. 
Export All Devices Data from Intune Portal | Endpoint Manager
Export All Devices Data from Intune Portal | Endpoint Manager
  • A notification will be appear automatically in the top right-hand corner with message Export is in progress. You can also see the status by selecting the notification icon.
How to Export All Devices Data from Intune Portal | Endpoint Manager 1
Export All Devices Data from Intune Portal | Endpoint Manager
  • All exported data will be automatically downloaded in a .zip file format to your browsers and a notification message will be appear Export completed.
How to Export All Devices Data from Intune Portal | Endpoint Manager 2
Export All Devices Data from Intune Portal | Endpoint Manager

 All device list exports will be downloaded in a .zip file format containing a single .csv file.

Export All Devices Data from Intune Portal | Endpoint Manager
Export All Devices Data from Intune Portal | Endpoint Manager
  • Extract the downloaded CSV file, and Open to exported report of device data details as shown below.

Exported data with Only include selected columns in the exported file option.

Export All Devices Data from Intune Portal | Endpoint Manager
Export All Devices Data from Intune Portal | Endpoint Manager

Exported data with Include all inventory data in the exported file option.

Export All Devices Data from Intune Portal | Endpoint Manager
Export All Devices Data from Intune Portal | Endpoint Manager

Add or Remove Columns in All Devices Node – Intune

  • In MEM Portal, Navigate to Devices > All devices. Click on the Columns, A flyout displays, here you can Check or Uncheck the columns that you want to include in console. Select Apply.

This will allow you to add selected columns in CSV file when you choose Export (Only include selected columns in the exported file) option.

Export All Devices Data from Intune Portal | Endpoint Manager
Export All Devices Data from Intune Portal | Endpoint Manager

Resource

5 thoughts on “How to Export All Devices Data from Intune Portal | Endpoint Manager”

  1. When we export the data, WIFI MAC address shows the one which is being used at the time by the device which is mostly the VPN address. By any chance can we get the Unique Address that the device comes with

    Reply

Leave a Comment