Exporting AAD users with specific information via powershell

Question

Hi, I am trying to export AAD users with below information but I can't get the script working and i think I am missing something in somewhere. Can someone please help? Information I need to include in CSV; id, upn, display name, Group, license name, Company, extentionattribute9, extentionattribute10, extentionattribute11, extentionattribute12 Thanks

Answer 1

@Comp_tech

Thank you for your post and I apologize for the delayed response!

From your issue, I understand that you're trying to export/download a list of users from Azure AD but you're running into issues with the script not working. To hopefully point you in the right direction, you should be able to reference the following PowerShell script in order to download all your Azure AD users to include your required properties.

#Connect to Azure AD
#For more info - https://learn.microsoft.com/en-us/powershell/azure/active-directory/install-adv2?view=azureadps-2.0#installing-the-azure-ad-module

#Install-Module AzureAD
Connect-AzureAD


#Path sets the Output location of the CSV file.
param(
    [string] $path = "C:\Users\<userName>\Desktop\ADUsers-$(Get-Date -format "MM-dd-yyyy").csv"
)

#For Each will get all Enabled Azure AD Users and the following properties:
#Employee ID, First Name, Last Name, Work Email, Job Title, Department, Management Email, License
& {
    foreach($azuser in Get-AzureADUser -All $true -Filter 'accountEnabled eq true') {
        [pscustomobject]@{
            "Employee ID"   = $azuser.ExtensionProperty["employeeId"]
            "First Name"    = $azuser.givenName
            "Last Name"     = $azuser.surname
            "Work Email"    = $azuser.UserPrincipalName
            "Job Title"     = $azuser.JobTitle
            "Department"    = $azuser.CompanyName
            "Manager Email" = (Get-AzureADUserManager -ObjectId $azuser.ObjectId).UserPrincipalName
            "License"       = $azuser.ExtensionProperty["extension_a92a_msDS_cloudExtensionAttribute1"]
        }
    }
} | Export-CSV -Path $path -NoTypeInformation

If you'd like to change the user properties that're downloaded, you can run the following to get Azure AD user properties.

#Get a list of 5 Azure AD Users
Get-AzureADUser -Top 5

#From the list of 5 users - Get a single Azure AD User by Object ID
Get-AzureADUser -ObjectId "<ObjectID>" | Format-List


#Add the properties needed to the PowerShell script, for example you can add UserType to the list of properties downloaded.

            "Employee ID"   = $azuser.ExtensionProperty["employeeId"]
            "First Name"    = $azuser.givenName
            "Last Name"     = $azuser.surname
            "Work Email"    = $azuser.UserPrincipalName
            "Job Title"     = $azuser.JobTitle
            "Department"    = $azuser.CompanyName
            "UserType"      = $azuser.UserType

I hope this helps!

If you have any other questions, please let me know. Thank you for your time and patience throughout this issue.

---

If the information helped address your question, please Accept the answer. This will help us and also improve searchability for others in the community who might be researching similar information.