password last set export csv

Welcome Forums General PowerShell Q&A password last set export csv

This topic contains 4 replies, has 4 voices, and was last updated by

1 year ago.

  • Author
  • #88439

    Points: 0
    Rank: Member

    Hi All,

    I have created quick script for password last set

    $users=Get-ADUser -filter * -Properties name, passwordlastset | Select-Object name, passwordlastset
    $users | export-csv "c:\passwordlastset.csv"
    $PWLS = $users.passwordlastset
    $date = Get-Date
    foreach ($user in $users)
        if($pwls -lt $date.AddDays(-1))
        {write-output "'$($'this needs changing"

    although how would I export the results of the foreach loop /if statement to a csv? my idea is that once I export the results, I will then import that csv underneath the above code, and start my next bit of the script working off that csv of the affected users.


  • #88448

    Points: 270
    Helping Hand
    Rank: Contributor

    You could de something like this:

    $Today = Get-Date
    Get-ADUser -Filter * -Properties name, passwordlastset -OutVariable ADUserList | 
        Select-Object -Property Name,
                                @{Name = 'Change needed';Expression = {If($_.passwordlastset -lt $Today.AddDays(-1)){$true}Else{$false}}} -OutVariable PWChangeList

    This way you have your "results" in the two variables ADUserList and PWChangeList and you could export it or do more things as needed. Maybe like this:

    $ADUserList | Export-Csv -Path ADUserList.csv -Delimiter ',' -NoTypeInformation
    $PWChangeList | Export-Csv -Path PWChangeList.csv -Delimiter ',' -NoTypeInformation
  • #88480

    Points: 332
    Helping Hand
    Rank: Contributor


    You are going after this data repeatedly / dynamically from ADDS.

    Why take the extra steps of serializing dynamic data to the drive, just to read it back in?

    IMHO, that is a lot of unnecessary steps and you can simplify this down to a PSCustomObject for easier use / manipulation.
    Again, PoSH is all about discovery, flexibility and choice. Not all of us will agree on the same things.

    Anyways, this would be my approach at this use case. Always dynamic, no serialization to disk required, no extra variables.
    Using object properties and as a function for, well, you know.

    Function Get-PasswordLastSet


    Get-ADUser -filter * -Properties PasswordLastSet |
    ForEach-Object {
    Name = $_.Name
    PassWordLasSet = $_.PasswordLastSet
    ChangeNeeded = ($_.PasswordLastSet -lt (Get-Date(Date)).AddDays(-1))

    Get-PasswordLastSet |
    Select -First 2 |
    Format-Table -AutoSize

    # Results
    Name PassWordLasSet ChangeNeeded
    —- ————– ————
    Administrator 3/31/2017 2:34:34 PM True
    Guest True

    But if you really wanted to serialize to disk you could of course.

    # Full PWLS Report
    Get-PasswordLastSet | Export-Csv -Path "$env:USERPROFILE\Documents\UserPwlsReport.csv" -NoTypeInformation

    # Or just the User Name list
    Get-PasswordLastSet | Select Name | Export-Csv -Path "$env:USERPROFILE\Documents\UserPwlsReport.csv" -NoTypeInformation

    psEdit -filenames "$env:USERPROFILE\Documents\UserPwlsReport.csv"

  • #88481

    Points: 1
    Rank: Member

    by looking at your original post. it seems to look like your trying to create a script or function. you can also try something like this

    $users = Get-ADUser -filter * -Properties name, passwordlastset | Select-Object name, passwordlastset
    $users | export-csv "c:\Scripts\ passwordlastset.csv"
    $PWLS = $users.passwordlastset
    $date = Get-Date
    foreach ($user in $users)
        if($pwls -lt $date.AddDays(-1)){
            $PWCUsers = [pscustomobject]@{
                                    "User" = $
                                    "PasswordLastSet" = $user.passwordlastset
             $PWCUsers | Export-Csv -NoTypeInformation C:\scripts\temp.csv -Force -Append
    • #88709

      Points: 0
      Rank: Member

      Thanks shihan, this is helpful!

The topic ‘password last set export csv’ is closed to new replies.