Hi,

I am running this script which is gathering the info for all users from input file but only the last users data is exported to the output file.

import-csv .\users.txt | foreach-object{
$users=get-ADUser -identity $_.samaccountname -properties DistinguishedName, employeeID, Enabled, Name, 

LastLogontimestamp | select DistinguishedName, EmployeeID, Enabled, Name, @{N='LastLogontimestamp'; E={
[DateTime]::FromFileTime($_.LastLogontimestamp)
     } 
   }
}
$users |export-csv c:\ad\users.csv

Please help me asap!!

Regards..

Hi,

Quick fix: change $users= to $users+=.

Longer but cleaner fix: don't create a $users array, just run everything directly through the pipeline.

Hi Mike,

Thanks, can you please show me the command modified exactly. Consider me Naive in powershell :)

Thanks!!

Hi,

Give this a try:

Import-Csv .\users.csv | ForEach {

    Get-ADUser $_.SamAccountName -Properties EmployeeID,LastLogonDate |
        Select DistinguishedName,EmployeeID,Enabled,Name,LastLogonDate

} | Export-Csv .\userDetails.csv -NoTypeInformation

This assumes you have an input CSV file with a header of SamAccountName with usernames underneath.

Thanks Mike, That worked!!

Cheers!!