Trying to extract a list (csv or excel) file for all Azure AD devices with the properties displayed on the Azure Portal (see attached picture)
Are you familiar with Powershell? Simple option is to run the following in powershell to export all your list
#Connect into Azure AD
#Download all Azure AD Device
Get-AzureADDevice -All $true | export-csv AADDevice.csv
@Sankara_Subramanian Thanks I've run that but still missing the Join Type and Owner columns how do I get those?
Since you seem familiar, I'll refer you to the documentation: https://docs.microsoft.com/en-us/powershell/module/azuread/?view=azureadps-2.0#devicesWhat I like to do when creating a report like this is piping Format-List (FL for short) so I can see what's all the information available to me.To start: Get-AzureADDevice -Searchstring "YourDeviceName" | Format-ListYou can them combine/pipe with others to find what you need.
It looks like there is a specific command to find the owner. If you can't find what you need, you might need to use Graph API to retrieve those. https://docs.microsoft.com/en-us/graph/api/resources/intune-graph-overview?view=graph-rest-1.0