You can take a look at AdminDroid Microsoft 365 reporting and auditing tool.Īdditionally, AdminDroid provides 1500+ pre-built reports and 20 smart visually appealing dashboards to know about your Office 365 environment at a glance. SharePoint inactive users based on the SharePoint activity.Teams inactive users based on last team activity date.If you want to know inactive users based on their, Get More Detailed Users’ Last Activity Date Report: If you want to get users’ last logon time based on ‘real’ user’s last activity, you can refer Export Office 365 Users Real Last Logon Time Report to CSV blog. To know more about scheduling Powershell script, refer our blog: Schedule PowerShell script using Task Scheduler.Īs LastLogonTime attribute also updated by some background tasks like Mailbox Assistant, this report(LastLogonTime retrieved from Get-MailboxStatistics) might give inaccurate data. To export last logon time of Office 365 users with non-MFA account, run the script as follows. How to: Export ‘Office 365 last login report’: You can choose any one of the below methods based on the account type. The script designed to support both MFA enabled account and non-MFA account. The script exports Office 365 users’ last-logon-date to CSV with the following attributes: User Principal Name, Display Name, Last Logon Time,Creation Time, Inactive Days, Mailbox Type, Assigned Licenses (Friendly Name), Admin Roles.

Office 365 Last Logon Report – Sample Output: The assigned licenses column will show you the user-friendly-name like ‘Office 365 Enterprise E3’ rather than ‘ENTERPRISEPACK’.Shows result with user’s administrative roles in O365 environment.Result can be filtered to lists never logged in mailbox alone.Result can be filtered based on user / all mailbox type.You can generate report based on inactive days.The script can be executed with MFA enabled account too.Single script allows you to generate 5 different last login reports.To ease your work, we have created PowerShell script to export last logon time with most required attributes like Inactive days, mailbox type, license details,creation time, administrative roles, etc. In both ways, you can’t export or use it to filter result based on Inactive days and mailbox type. To find inactive users in Office 365, you can use either Exchange admin center or Get-MailboxStatistics PowerShell cmdlet. The last-logon-time shows the time a user last accessed their mailbox using Outlook, WebMail, or their mobile phone.Įxport Office 365 User Last Logon Time Using PowerShell Getting the last-logon-date/time of O365 user is a vital task to track the user’s last logon activity, find Inactive users and remove their licenses. A lot of administrators often ask in the community, “How can I export Office 365 users’ last-logon-time using PowerShell?”.

Password reset office 365 e3