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
- Faiza QadriNov 06, 2019Iron Contributor
Sankara_Subramanian Thanks I've run that but still missing the Join Type and Owner columns how do I get those?
- jerome317Nov 07, 2019Brass Contributor
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 HameedApr 29, 2020Copper Contributor
Get-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
- Yazo97Nov 09, 2020Copper ContributorNice! Thanks for this