Office 365 Reports Archives - Office 365 Reports

Office 365 users last password change date report

Export Office 365 Users’ Last Password Change Date to CSV

February 17, 2020February 17, 2020Exchange Online, O365 Powershell, Office 365 ReportsNo Comments

Office 365 users’ last password change date can be retrieved from the LastPasswordChangeTimeStamp attribute. Using PowerShell, we can quickly get this attribute from Get-MsolUser cmdlet. You can use below PowerShell code to export password last change date to CSV.

Get-MsolUser -All | select DisplayName,LastPasswordChangeTimeStamp | Export-CSV LastPasswordChangeDate.csv -NoTypeInformation

1	Get-MsolUser -All \| select DisplayName,LastPasswordChangeTimeStamp \| Export-CSV LastPasswordChangeDate.csv -NoTypeInformation

Note: Since Get-AzureADUser doesn’t support last […]

Export Shared Mailbox Permission Report to CSV using PowerShell

January 3, 2020January 3, 2020Exchange Online, O365 Powershell, Office 365 ReportsNo Comments

What is Shared Mailbox in Office 365? Shared Mailbox allows a group of users to view and send emails from a common email address. I.e., any member of the shared mailbox can respond to an email that sent to a […]

Export Office 365 Users’ Logon History Report to CSV Using PowerShell

December 23, 2019December 23, 2019Exchange Online, O365 Powershell, Office 365 Reports, SecurityNo Comments

Logons are the one common activity in most attack patterns. Tracking Office 365 user’s login activities is a crucial one in detecting potential security breaches and suspicious behavior. To get Office 365 User logon history, you can use either Office […]

How to Schedule PowerShell Script using Task Scheduler

August 2, 2019February 18, 2020O365 Powershell, Office 365 Reports, ToolsNo Comments

PowerShell script reduces manually doing repetitive tasks. If you are frequently executing scripts at pre-defined times or specified time intervals, you may be tired of executing scripts repeatedly. Then, you can utilize Windows’ Task Scheduler to automate script execution for […]

Export Office 365 Users’ Real Last Logon Time Report to CSV

June 18, 2019January 11, 2020Exchange Online, O365 Powershell, Office 365, Office 365 ReportsNo Comments

LastLogonTime retrieved from Get-MailboxStatistics is not accurate but most of the administrators/scripts use this to identify inactive mailboxes. Nowadays, I see most forums have questions like “Why the Last Login Date reported by the Get-MailboxStatistics cmdlet is not correct”,” Some […]

Office 365 users real last logon time report

Why Office 365 Users’ Last Logon Time Reported by Get-MailboxStatistics is inaccurate?

June 18, 2019November 27, 2019Exchange Online, O365 Powershell, Office 365, Office 365 ReportsNo Comments

As I was seeing a lot of feedback in my blog Export Office 365 users’ last logon time to CSV , regarding ‘How the script can produce recent last logon time even when the user blocked or disabled few months ago?’, I’ve decided to do […]

Export Office 365 Distribution group membership

Export Office 365 Distribution Group Members to CSV

May 23, 2019January 11, 2020Exchange Online, O365 Powershell, Office 365, Office 365 ReportsNo Comments

What is Distribution Group? Office 365 Distribution Groups (aka Distribution List) are used to send emails or meeting request to list of people (both internal and external users), without having to add the email address individually each time. Distribution Groups […]

Export Office 365 Users MFA Status to CSV

May 9, 2019January 18, 2020Exchange Online, O365 Powershell, Office 365, Office 365 ReportsNo Comments

What is MFA? Multi-factor Authentication (MFA) plays a vital role in securing user accounts. As the name suggests, it uses multiple methods to identify an authorized user. You can get to know more about what is MFA, how it works […]

Dynamic Distribution group members report

Export Office 365 Dynamic Distribution Group Members to CSV

March 23, 2019August 2, 2019Exchange Online, O365 Powershell, Office 365, Office 365 ReportsNo Comments

What is Office 365 Dynamic Distribution Group? Most people aware of Distribution Lists, but the Dynamic Distribution Group has several benefits over traditional distribution lists. In Office 365 environment, a Dynamic Distribution Group (DDL) is used to expedite the mass […]

Export Office 365 Users’ Last Logon Time to CSV

March 7, 2019February 5, 2020Exchange Online, O365 Powershell, Office 365, Office 365 ReportsNo Comments

A lot of administrators often ask in the community, “How can I export Office 365 users’ 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 […]