How to get All Azure AD devices with the column values from the Azure GUI app?

Question

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)

sankara_subramanian · Answer

Faiza Qadri&nbsp;&nbsp;Are you familiar with Powershell?&nbsp; &nbsp;Simple option is to run the following in powershell to export all your list&nbsp;#Connect into Azure ADConnect-Azure AD&nbsp;#Download all Azure AD Device&nbsp;Get-AzureADDevice -All $true | export-csv AADDevice.csv&nbsp;-Sankara&nbsp;

jerome317 · Answer

Since you seem familiar, I'll refer you to the documentation: https://docs.microsoft.com/en-us/powershell/module/azuread/?view=azureadps-2.0#devices

What 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-List
You 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

shaik hameed · Answer

jerome317&nbsp;&nbsp;Get-AzureADDevice will help&nbsp;DeviceTrustType is the column to check in the result&nbsp;If DeviceTrustType =&nbsp;ServerAd then the device is&nbsp;Hybrid Azure AD joinedIf DeviceTrustType = Workplace then the device is&nbsp;Azure AD registered&nbsp;

faiza qadri · Answer

Sankara_Subramanian&nbsp;Thanks I've run that but still missing the Join Type and Owner columns how do I get those?

steve_w_uccs · Answer

Shaik Hameed&nbsp;&nbsp;Thank you for this information.&nbsp; And based on the other responses, I was able to establish counts for each join type:(Get-AzureADDevice -All $true | Where {$_.DeviceTrustType -eq "ServerAd"}).count(Get-AzureADDevice -All $true | Where {$_.DeviceTrustType -eq "AzureAd"}).count(Get-AzureADDevice -All $true | Where {$_.DeviceTrustType -eq "Workplace"}).countOr combine a couple:(Get-AzureADDevice -All $true | Where {($_.DeviceTrustType -eq "ServerAd") -or ($_.DeviceTrustType -eq "AzureAd")}).countOr all Azure AD Devices:&nbsp;(Get-AzureADDevice -All $true).count

Forum Discussion

How to get All Azure AD devices with the column values from the Azure GUI app?

7 Replies

Resources