Azure AD Data Extract

[Faiza Qadri]

I'm trying to use the Get-AzureADusers command to get the following fields into a csv file:

NAME,ENABLED, OS, VERSION, JOIN, TYPE, OWNER, USER NAME, MDM, COMPLIANT, REGISTERED, ACTIVITY

I keep getting an error that its not valid value but I can see those values in the Azure view. 

TIA

#AzureAD

[#2]

Might help if you give us the exact cmdlet you are running. The properties you've listed seem to correspond to device objects, not users...

[#3]

@Faiza Qadri 

Hi Faiza!

You probably need to use a combination of cmdlets to get that data.  

#Get All Devices

$devices = Get-AzureADDevice -All $true

For each device you can use Get-AzureADDeviceRegisteredUser or Get-AzureADDeviceRegisteredOwner to get the person associated with it. 

[#4]

@joshuatoonGood to hear from you!

I'm running the Get-AzureADDevice -all but only get the ObjectID, DeviceID, Displayname

in the Azure portal under Azure Active Directory - Devices I can see the following:

[#5]

@Faiza Qadri as Joshua wrote combination of cmdlets should work in your case (Get-AzureADDevice, Get-AzureADDeviceRegisteredOwner).

Another alternative is to use old cmdlet which still works:

get-msoldevice -All -ReturnRegisteredOwners | ft DisplayName,Enabled,DeviceOsType,DeviceTrustType,DeviceTrustLevel,RegisteredOwners,ApproximateLastLogonTimestamp

But this doesn't return the compliant information. One method to list compliant status could be to list all devices via Graph API (https://developer.microsoft.com/en-us/graph/graph-explorer):

GET https://graph.microsoft.com/v1.0/devices