Trying to Download user list with Last Password Change Date Time

Nick Marchese 0 Reputation points

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!

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,366 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Harpreet Singh Matharoo 7,471 Reputation points Microsoft Employee

    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.

    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.