Reporting password expiration to admins

Copper Contributor

Doesn't anyone know if there is a field I can use for reporting of password expiration dates?  Our organization still wants awareness of people who have passwords expiring at the administrator level and since moving to Azure AD we have lost that visibility as I cannot find where to grab that information.

2 Replies
best response confirmed by heathboroff (Copper Contributor)

Hello @heathboroff 


This script will do the job. Please, see below.


Export Office 365 Users’ Last Password Change Date to CSV (




Thank you.