List of users in Azure AD

GuestGuivenchi 105 Reputation points
2023-07-28T20:44:03.8766667+00:00

Good day,

I manage a cloud-based Active Directory.

I want to download a list of users with specific columns, when downloading the .cvs file it doesn't contain the columns I chose.

How can I get the data I need?

Thank you.

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
18,561 questions
{count} votes

5 answers

Sort by: Most helpful
  1. Gérald Döserich 760 Reputation points
    2023-07-28T20:46:00.8666667+00:00

    You can try use the Azure PowerShell Module and see if the fields are avaialble there.


  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  3. Sandeep G-MSFT 13,396 Reputation points Microsoft Employee
    2023-07-31T04:29:18.6966667+00:00

    @GuestGuivenchi

    Use below steps to pull the list of all users with the properties that you are looking for,

    • Open Windows PowerShell as administrator.
    • Run below commands
    • Install-Module AzureAD
    • Import-Module AzureAD
    • Connect-AzureAD (Enter the global admin credentials when it prompts for credentials)
    • Run the command "Get-AzureADUser -All $true | select UserPrincipalName, usertype | Export-Csv c:\Users.csv"

    Note: In the last command you can change the properties as per your requirement. This command will pull list of all users from Azure AD you are connected to.

    Let me know if you have any further questions on this.

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.


  4. Rohit Kumar Sinha 1,316 Reputation points
    2023-08-01T15:08:08.19+00:00

    Hi ,

    You can also directly download from the portal and manage the columns directly from there

    If this is useful , please mark as Accept Answer

    User's image

    0 comments No comments

  5. Rae Feldman 0 Reputation points
    2023-10-12T13:42:13.0333333+00:00

    Just encountered this. Get-AzureADUser only returned first 100 accounts out of just shy of 800.

    Referenced:
    https://learn.microsoft.com/en-us/powershell/module/azuread/get-azureaduser?view=azureadps-2.0

    Found including the -All Parameter resolved.

    Try:

    Get-AzureADUser -All:$true 
    
    0 comments No comments