Azure AD - Download users - Missing many users in the export

Question

Hello All,&nbsp;We are downloading the registered Guest users list from Azure portal to track and follow-up on the Invitation registration. In this list, we are missing many users.&nbsp;&nbsp;But when we search the user individually in the same screen (Active directory-&gt; Users) , we can see those specific users with various status like accepted, pending acceptance etc.&nbsp; Even we tried various options, cleared the filter and tried the download users again, still we are missing many users.&nbsp;Could somebody help??&nbsp;RegardsSen&nbsp;

floris_gs1_nl · Answer

Thank you for your reply. But as often with developers an half answer.After long searching and many trial and error I found the complete powershell script to get it done.Get-ExecutionPolicy -ListSet-ExecutionPolicy -ExecutionPolicy remotesigned -scope ProcessSet-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUserInstall-Module AzureADGet-InstalledModuleImport-Module AzureADConnect-AzureAD -Tenant {Your tenant ID}(also works for Azure B2C)$users = Get-AzureADUser -All $true$users | Select-Object -Property Id, GivenName, Surname, { ($_.SignInNames[0] -split '
')[2] -replace " Value: " } | Export-Csv users.csv

shehanjp · Answer

Hi,Have you used PowerShell by any chance?

kirubakarasen · Answer

Hello shehanjp, The issue is resolved. We generated the report with Powershell. thanks.

floris_gs1_nl · Answer

Hi, we ran into the same problem. Would have been even more helpfull if you could share the powershell commands you used to get the full/complete list.

manoj94 · Answer

You can use either Ms graph or Powershell the ps liner is given below:Get-AzureADUser -Filter "UserType eq 'Guest'" | select DisplayName, Mail

Forum Discussion

Azure AD - Download users - Missing many users in the export

Share

Resources