AD Password Output to CSV or TXT file

wxrodrig · 2021-10-28T19:46:41.000Z

Hi, this simple script has saved me a lot of time for setting passwords for AD users from my TXT file, However, I would like to know, what I can change/alter the below Powershell script to have it write to a .txt or .csv file on my local drive, rather than display the passwords in the dialog box ?? TY

# Load user list
$ListOfUsers = Get-Content C:\temp\list.txt
foreach ($user in $ListOfUsers) {
    #Generate a 12-character random password
    $Password = -join ((33..126) | Get-Random -Count 8 | ForEach-Object { [char]$_ })
    #Convert the password to secure string
    $Pass = ConvertTo-SecureString $Password -AsPlainText -Force
    #Reset the account password
    Set-ADAccountPassword $user -NewPassword $Pass -Reset
    #Force user to change password at next logon
    Set-ADUser -Identity $user -ChangePasswordAtLogon $true
    #Display userid and password values
    Write-Host $user, $Password
}

@powershelllearner

Neally · 2021-10-28T20:30:10.000Z

Welcome

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

192033ab-bb8f-4032-88a5-8e2313af0344-codebutton_small.png

Neally Bot

wxrodrig · 2021-10-28T20:34:21.000Z

my bad. i fixed it .

Neally · 2021-10-28T20:39:14.000Z

here ya go.

# Load user list
$ListOfUsers = Get-Content "C:\temp\list.txt"
foreach ($user in $ListOfUsers) {
    #Generate a 12-character random password
    $Password = -join ((33..126) | Get-Random -Count 8 | ForEach-Object { [char]$_ })
    #Convert the password to secure string
    $Pass = ConvertTo-SecureString $Password -AsPlainText -Force
    #Reset the account password
    Set-ADAccountPassword $user -NewPassword $Pass -Reset
    #Force user to change password at next logon
    Set-ADUser -Identity $user -ChangePasswordAtLogon $true
    #Display userid and password values
    Write-Output $user, $Password 
    
    # For txt file:
    Write-Output $user, $Password |
    out-file "UserCreds.txt" -Append

    # For CSV file:
    
    [pscustomobject]@{
        User     = $user
        Password = $Password
    } | 
    # -append with 'export-csv' requires PowerShell v3+
    export-csv "UserCreds.csv" -NoTypeInformation -Append
}

wxrodrig · 2021-10-28T21:14:55.000Z

That worked so well…thank you so much!!

Neally · 2021-10-28T21:18:13.000Z

wxrodrig:

That worked so well…thank you so much!!

No worries. if you have questions, please ask.