How can I use Powershell to retrieve Active Directory user information based on their 'departmentnumber' that matches a list of department numbers provided in a CSV file?

edit

Here is a PowerShell script that retrieves Active Directory user information based on their department number that matches a list of department numbers provided in a CSV file:

# Load the list of department numbers from the CSV file
$departments = Import-Csv -Path "C:\Temp\Departments.csv"

# Loop through each department number in the list and retrieve user information
foreach ($department in $departments) {
    # Retrieve users based on department number
    $users = Get-ADUser -Filter "DepartmentNumber -eq '$($department.DepartmentNumber)'" -Properties *

    # Display user information
    $users | Select-Object Name, SamAccountName, Title, Department, OfficePhone
}

In this script, we first load the list of department numbers from the CSV file using the Import-Csv cmdlet. We then loop through each department number in the list and retrieve user information using the Get-ADUser cmdlet. We pass a filter to the cmdlet to only retrieve users whose DepartmentNumber property matches the current department number in the loop.

We also specify the -Properties * parameter to retrieve all properties of the user object. Finally, we select and display the user information we are interested in using the Select-Object cmdlet.