O365 Powershell 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 Non-owner Mailbox Access Report to CSV

February 4, 2020February 4, 2020Exchange Online, O365 Powershell, Office 365, SecurityNo Comments

Since mailboxes have sensitive data, granting access permission to multiple users increases the risk of a security breach. You can use the audit log to detect and prevent such security vulnerabilities. Using the audit log, you can track who has accessed the mailbox and […]

Enable Mailbox Auditing in Office 365 Users using PowerShell

January 21, 2020January 21, 2020Exchange Online, O365 Powershell, SecurityNo Comments

Auditing mailbox activities play a vital role in security and compliance. Mailbox auditing allows you to track user’s actions on their own mailbox and others’ mailboxes. So, you can track who logs on to the mailbox and what operations are performed. […]

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 […]

Connect Exchange Online PowerShell without Basic Authentication

Connect to Exchange Online PowerShell without Basic Authentication

December 11, 2019February 14, 2020Exchange Online, O365 Powershell, SecurityNo Comments

Most admins rely on PowerShell to manage and audit their Office 365 organization. As an admin, you might have heard about Microsoft deprecating Basic Authentication in Exchange Online by Oct 31, 2020. So, how will you easily connect to Exchange […]

Install all Office 365 PowerShell Modules

November 1, 2019Exchange Online, O365 Powershell, Office 365, SharePoint OnlineNo Comments

Office 365 includes a wide variety of cloud services like Azure AD, Exchange Online, SharePoint Online, Security and Compliance Center, Skype for Business, and Teams. To manage multiple Office 365 services, you need to navigate different admin portals as each […]

Connect to all Office 365 Services PowerShell (Supports MFA too)

October 5, 2019January 11, 2020Exchange Online, O365 Powershell, Office 365, SharePoint Online2 Comments

As an Office 365 admin, you spend most of the time in PowerShell to accomplish administrative tasks. Office 365 includes a wide variety of cloud services like Exchange Online, Azure Active Directory, SharePoint Online, Skype for Business Online, Teams, and Security & […]

Quickly Connect to Exchange Online PowerShell

August 22, 2019February 14, 2020Exchange Online, O365 Powershell, Office 365No Comments

Exchange Online PowerShell Cmdlets are always handy for us as the Exchange Admin Center and Office 365 Admin Center has become less capable of doing many tasks. Many useful administration tasks can be done using PowerShell cmdlets that are not […]

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 […]