Home

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%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%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
Faiza Qadri
Occasional 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

3 Replies

@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

 

@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.0

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies