Hi Everyone,
Objective:
Get active directory properties of multiple users and save the info to a CSV file.
I have a text file containing the usernames (C:\temp\test\test1.txt)
The code is working, but for some reason it only read the last line of the text file (test1.txt) so only returns value for a single user each time its run.
Its not reading the text file properly and I cant figure out why. The code is below, please help:
$Users = get-content "C:\temp\test\test1.txt"
foreach ($User in $Users) {
Get-ADUser -identity $user -Properties displayName,SamAccountName,description,mail,company,manager,accountExpires,memberOf | % {
New-Object PSObject -Property @{
UserName = $_.DisplayName
UserId = $_.SamAccountName
description = $_.description
Mail = $_.mail
company = $_.company
manager = $_.manager
accountExpires = $_.accountExpires
Groups = ($_.memberof | Get-ADGroup | Select -ExpandProperty Name) -join ","
}
} | Select UserName,UserId,description,Mail,company,manager,accountExpires,groups | Export-Csv C:\temp\ADreport.csv -NTI
}
