Forum Discussion
How to get All Azure AD devices with the column values from the Azure GUI app?
Are you familiar with Powershell? Simple option is to run the following in powershell to export all your list
#Connect into Azure AD
Connect-Azure AD
#Download all Azure AD Device
Get-AzureADDevice -All $true | export-csv AADDevice.csv
-Sankara
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#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.0Get-AzureADDevice will help DeviceTrustType is the column to check in the result
If DeviceTrustType = ServerAd then the device is Hybrid Azure AD joined
If DeviceTrustType = Workplace then the device is Azure AD registered
Thank you for this information. 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"}).count
Or combine a couple:
(Get-AzureADDevice -All $true | Where {($_.DeviceTrustType -eq "ServerAd") -or ($_.DeviceTrustType -eq "AzureAd")}).count
Or all Azure AD Devices:
(Get-AzureADDevice -All $true).count
