Trying to Download user list with Last Password Change Date Time

Question

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!

Answer 1

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.

Answer 2

Connect-MsolService : The term 'Connect-MsolService' is not recognized as the name of a cmdlet, function, script file, or

operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try

again.

At line:1 char:1

• Connect-MsolService

• 
      + CategoryInfo          : ObjectNotFound: (Connect-MsolService:String) [], CommandNotFoundException
  
      + FullyQualifiedErrorId : CommandNotFoundException