Report AAD Users together with their Registered Device

[Simphiwe_Mkhize01]

Hi Guys

Need assistance to get a report of Azure AD users together with their registered device name, I`m trying the following command but I`m not getting the correct results:

Foreach User in “Get-ADUser -All” {

              UserCreds = Get-AzureADUserRegisteredDevice -ObjectId $User              

}

[#2]

This has been answered several times already, do a search next time :)

Get-AzureADUser | % {$DeviceOwner = $_.UserPrincipalName; Get-AzureADUserRegisteredDevice -ObjectId $_.ObjectId } | select @{n="DeviceOwner";e={$DeviceOwner}},DisplayName,DeviceOSType,ApproximateLastLogonTimeStamp

[#3]

@Vasil Michev thanks for the script and I did try it but it doesn`t bring the results, please see attached screenshot. 

[#4]

Try using an account that has sufficient permissions to enumerate users in the directory as well as call the Get-AzureADUserRegisteredDevice cmdlet.

[#5]

@Simphiwe_Mkhize01  Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Azure Active Directory space - please post Azure Active Directory questions here in the future. 

[#6]

@Eric Starker thank you for your assistance.

[#7]

@Vasil Michev will try that and give feedback.

[#8]

@Vasil Michev This returns value with single user. Please suggest query with same results for all users.

[#9]

You should do 'Get-AzureADUser -all $true'

[#10]

Hi@Simphiwe_Mkhize01 

You can use GUI mode (Azure Portal) to get the report with details.

Login to Azure portal>> Devices>>All Devices

Hope this will help you

[#11]

Long term approach:

You use Intune Data warehouse reporting to have insight on your environment.

https://docs.microsoft.com/en-us/intune/developer/reports-nav-create-intune-reports

Moe

[#12]

Try using our PowerShell script now to export report on Azure AD devices with the users and other attributes. Get to know more about Azure AD devices and how to generate reports on them from here.
https://o365reports.com/2023/04/18/get-azure-ad-devices-report-using-powershell/