Trying to Download user list with Last Password Change Date Time

Nick Marchese 0 Reputation points
2023-03-08T17:06:45.58+00:00

Hi there. On Azure Active Directory User List, there is a column for Last Password Change Date Time. Unfortunately, I can't figure out how to export this in a report or excel file. Any tips? Clicking Download Users does not provide this field although I can see it in the interface. I'd like to do this with Azure and not run a command on the server. Thanks!

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
13,515 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Harpreet Singh Matharoo 3,351 Reputation points Microsoft Employee
    2023-03-09T07:43:26.1033333+00:00

    Hello @Nick Marchese

    Thank you for reaching out. I would like to confirm that currently Azure AD Admin or Office 365 Admin Center do not support exporting Last Password Change Date Time details. However, you can use following PowerShell commands to export these details in CSV.

    Connect-MsolService
Get-MsolUser -All | Select-Object UserPrincipalName,LastPasswordChangeTimestamp | Export-Csv -Path "C:\LastPasswordChangeTimestamp.csv" -NoTypeInformation

    Above script will retrieve all users from Azure AD and select the UserPrincipalName and LastPasswordChangeTimestamp properties.

    I hope this answer helps to resolve your issue.

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.