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

%3CLINGO-SUB%20id%3D%22lingo-sub-978604%22%20slang%3D%22en-US%22%3EHow%20to%20get%20All%20Azure%20AD%20devices%20with%20the%20column%20values%20from%20the%20Azure%20GUI%20app%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-978604%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20extract%20a%20list%20(csv%20or%20excel)%20file%20for%20all%20Azure%20AD%20devices%20with%20the%20properties%20displayed%20on%20the%20Azure%20Portal%20(see%20attached%20picture)%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F154677i5EFAB39F87FADE30%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Annotation%202019-11-04%20105845.jpg%22%20title%3D%22Annotation%202019-11-04%20105845.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-978604%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20AD%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-978690%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20All%20Azure%20AD%20devices%20with%20the%20column%20values%20from%20the%20Azure%20GUI%20app%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-978690%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F123820%22%20target%3D%22_blank%22%3E%40Faiza%20Qadri%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20familiar%20with%20Powershell%3F%26nbsp%3B%20%26nbsp%3BSimple%20option%20is%20to%20run%20the%20following%20in%20powershell%20to%20export%20all%20your%20list%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%23Connect%20into%20Azure%20AD%3C%2FP%3E%3CP%3EConnect-Azure%20AD%26nbsp%3B%3C%2FP%3E%3CP%3E%23Download%20all%20Azure%20AD%20Device%26nbsp%3B%3C%2FP%3E%3CP%3EGet-AzureADDevice%20-All%20%24true%20%7C%20export-csv%20AADDevice.csv%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Sankara%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-988509%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20All%20Azure%20AD%20devices%20with%20the%20column%20values%20from%20the%20Azure%20GUI%20app%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-988509%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F441378%22%20target%3D%22_blank%22%3E%40Sankara_Subramanian%3C%2FA%3E%26nbsp%3BThanks%20I've%20run%20that%20but%20still%20missing%20the%20Join%20Type%20and%20Owner%20columns%20how%20do%20I%20get%20those%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-990723%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20All%20Azure%20AD%20devices%20with%20the%20column%20values%20from%20the%20Azure%20GUI%20app%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-990723%22%20slang%3D%22en-US%22%3E%3CP%3ESince%20you%20seem%20familiar%2C%20I'll%20refer%20you%20to%20the%20documentation%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fazuread%2F%3Fview%3Dazureadps-2.0%23devices%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fazuread%2F%3Fview%3Dazureadps-2.0%23devices%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20I%20like%20to%20do%20when%20creating%20a%20report%20like%20this%20is%20piping%20Format-List%20(FL%20for%20short)%20so%20I%20can%20see%20what's%20all%20the%20information%20available%20to%20me.%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20start%3A%20%3CFONT%20face%3D%22courier%20new%2Ccourier%22%20color%3D%22%23333399%22%3EGet-AzureADDevice%20-Searchstring%20%22YourDeviceName%22%20%7C%20Format-List%3C%2FFONT%3E%3CBR%20%2F%3EYou%20can%20them%20combine%2Fpipe%20with%20others%20to%20find%20what%20you%20need.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIt%20looks%20like%20there%20is%20a%20specific%20command%20to%20find%20the%20owner.%20If%20you%20can't%20find%20what%20you%20need%2C%20you%20might%20need%20to%20use%20Graph%20API%20to%20retrieve%20those.%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fintune-graph-overview%3Fview%3Dgraph-rest-1.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fintune-graph-overview%3Fview%3Dgraph-rest-1.0%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1346708%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20All%20Azure%20AD%20devices%20with%20the%20column%20values%20from%20the%20Azure%20GUI%20app%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1346708%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F328428%22%20target%3D%22_blank%22%3E%40jerome317%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGet-AzureADDevice%20will%20help%26nbsp%3B%3CSTRONG%3EDeviceTrustType%3C%2FSTRONG%3E%20is%20the%20column%20to%20check%20in%20the%20result%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20DeviceTrustType%20%3D%26nbsp%3B%3CSTRONG%3EServerAd%3C%2FSTRONG%3E%20then%20the%20device%20is%26nbsp%3B%3CSTRONG%3EHybrid%20Azure%20AD%20joined%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIf%20DeviceTrustType%20%3D%20%3CSTRONG%3EWorkplace%3C%2FSTRONG%3E%20then%20the%20device%20is%26nbsp%3B%3CSTRONG%3EAzure%20AD%20registered%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1438449%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20All%20Azure%20AD%20devices%20with%20the%20column%20values%20from%20the%20Azure%20GUI%20app%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438449%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F90835%22%20target%3D%22_blank%22%3E%40Shaik%20Hameed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20this%20information.%26nbsp%3B%20And%20based%20on%20the%20other%20responses%2C%20I%20was%20able%20to%20establish%20counts%20for%20each%20join%20type%3A%3C%2FP%3E%3CP%3E(Get-AzureADDevice%20-All%20%24true%20%7C%20Where%20%7B%24_.DeviceTrustType%20-eq%20%22ServerAd%22%7D).count%3C%2FP%3E%3CP%3E(Get-AzureADDevice%20-All%20%24true%20%7C%20Where%20%7B%24_.DeviceTrustType%20-eq%20%22AzureAd%22%7D).count%3C%2FP%3E%3CP%3E(Get-AzureADDevice%20-All%20%24true%20%7C%20Where%20%7B%24_.DeviceTrustType%20-eq%20%22Workplace%22%7D).count%3C%2FP%3E%3CP%3EOr%20combine%20a%20couple%3A%3C%2FP%3E%3CP%3E(Get-AzureADDevice%20-All%20%24true%20%7C%20Where%20%7B(%24_.DeviceTrustType%20-eq%20%22ServerAd%22)%20-or%20(%24_.DeviceTrustType%20-eq%20%22AzureAd%22)%7D).count%3C%2FP%3E%3CP%3EOr%20all%20Azure%20AD%20Devices%3A%26nbsp%3B%3C%2FP%3E%3CP%3E(Get-AzureADDevice%20-All%20%24true).count%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

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)Annotation 2019-11-04 105845.jpg

5 Replies
Highlighted

@Faiza Qadri 

 

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

 

Highlighted

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

Highlighted

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

Highlighted

@jerome317 

 

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

 

Highlighted

@Shaik Hameed 

 

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