PowerShell Free Exchange Online Auditing and Reporting Tool

 

Get 170+ Exchange Online statistics & auditing reports along with visually appealing dashboards. This tool gives you the insights and statistics about the Mailbox Size, Mailbox Usage, Active & Inactive Mailboxes, Incoming and Outgoing Mail Traffic, Spam Emails, Malware Emails, Mailbox Permission, Send As Permission, Send on Behalf permission, Mailbox Forwarding with Internal and External Classification, Mailbox Protocols Configurations, Enabled or Inactive ActiveSync Devices, Mailboxes on Hold, Email Signatures, OOF (Out of Office) configuration, Dynamic Distribution Groups, Role Groups, Inbox Rules/Filters, Non-Owner Mailbox Access, Mailbox Logins, Active Sync Device Changes, Internal/External Forwarding, Mailbox Rule Changes and more.

You don't need to write your own script using PowerShell cmdlets like Get-Mailbox, Get-MailboxStatistics, Get-MobileDevice, Get-MailboxPermission, and Get-MessageTrace. Just download and install this GUI tool.

 

PS: Attached the screenshot of Dashboards at the end of this post.

 

Since the TechNet gallery is under deprecation, We are moving the content to o365reports.com. 

For future updates you can follow: https://o365reports.com/2020/06/02/office-365-exchange-auditing-and-reporting-tool/

 

Office 365 Exchange Online Reports

Mailbox Info Reports (6 reports): 

 

 

Mailbox Usage Reports (4 reports): 

  • Mailbox Over Warning Quota  
  • Mailbox Size Over Time  
  • Daily Storage Statistics by All Exchange Mailboxes  
  • Daily Mailbox Quota Statistics  

  

Office 365 Mailboxes Report (3 reports): 

  • All Inactive Mailboxes  
  • Inactive Mailboxes by User's Last Activity Time  
  • Mailboxes Never Logged In  

  

Office 365 Inactive Users Report (3 reports): 

  • Inactive Exchange Users by Last Mail Read Date   
  • Inactive Exchange Users by Last Mail Sent Date  
  • Inactive Exchange Users by Last Mail Received Date  

  

Mailbox App Usage (12 reports): 

  • Daily Email App Usage Statistics  
  • Daily Email App Usage Statistics by Users  
  • Daily Outlook App Usage by Version  
  • Active Exchange Users with 'Mail for Mac'  
  • Active Exchange Users with 'Outlook for Mac'  
  • Active Exchange Users with 'Outlook for Windows'  
  • Active Exchange Users with 'Outlook for Web'  
  • Active Exchange Users with Other Mobile Apps  
  • Active Exchange Users with 'Other Mobile Apps'  
  • Active Exchange Users with 'POP3' Access  
  • Active Exchange Users with 'IMAP' Access  
  • Active Exchange Users with 'SMTP' Access  

  

Mailbox Settings (9 reports): 

  • Mailbox Quota  
  • Cluttered Status  
  • Mailbox Retention Settings  
  • Unified Messaging Enabled Mailboxes   
  • MailTip Settings  
  • Moderated Mailboxes  
  • Hidden Mailboxes  
  • Archived Mailboxes   
  • Quarantined Mailboxes  

  

Email Message Settings (7 reports): 

  • Email Signature Settings  
  • Mailbox Auto Reply / Out of Office Email Settings  
  • Mailbox Auto Reply / Out of Office Event Settings  
  • Message Format Configuration  
  • Important Settings for Messages  
  • Message Delivery Restrictions  
  • Message Size Restrictions  

  

Mailbox Permissions Report (7 reports): 

  • User Access to Others Mailboxes  
  • Mailbox Permission Summary  
  • Mailbox Permission Detail  
  • Mailbox with Send On Behalf  
  • Send As Permission  
  • Full Permission  
  • Read Permission  

  

Audit Settings (5 reports):

  • Audit Enabled Mailboxes  
  • Audit Disabled Mailboxes  
  • Admin Audit Enabled Mailboxes  
  • Delegate Audit Enabled Mailboxes  
  • Owner Audit Enabled Mailboxes  

  

Mailbox Forwarding (6 reports):

  • Mailbox Forwarding Detailed Summary  
  • External Domains Configured in Mailbox Forwarding  
  • Mailbox with SMTP forwarding  
  • Internal Forwarding Set by Admin  
  • Mailbox with Forwarding (Internal&External) Inbox Rules  
  • Mailbox with External Forwarding Inboxes Rules  

  

Mailbox Protocols (8 reports): 

  • Mailbox Protocol Features  
  • Mailbox ActiveSync Settings  
  • Mailbox OWA Settings  
  • Mailbox IMAP Settings  
  • Mailbox MAPI Settings  
  • Mailbox EWS Settings  
  • Mailbox POP Settings  
  • Mailbox SMTP Settings  

  

Active Sync (4 reports): 

  • ActiveSync Enabled Mailboxes  
  • Recently Added ActiveSync Devices  
  • Inactive ActiveSync Devices  
  • ActiveSync Device Count  

  

Mobile Devices (6 reports): 

  • All Mobile Devices  
  • Mailboxes by Connected Devices  
  • Mobile Devices by OS  
  • Mobile Devices by Policy  
  • Mobile Devices by Client Type  
  • Mobile Devices by Access State  

  

Mailbox on Hold (3 reports): 

  • Mailboxes with Litigation Hold  
  • Mailboxes with Retention Hold  
  • Mailboxes with In-Place Hold  

  

Exchange Groups (2 reports): 

  • Dynamic Distribution Groups report 
  • Role Groups  

  

Other Reports (4 reports): 

  • All Mailbox Filters (Inbox Rules)  
  • Accepted Domains  
  • Exchange Online Users with Profile Picture Set  
  • Custom Attributes  

Office 365 Exchange Online Auditing Reports 

Exchange Online Mailbox Auditing Report (62 reports)

Mailbox Access Activities (5 reports): 

  • Mailbox Owner Access  
  • Mailbox Non-Owner Access  
  • User's Mailbox Logins  
  • Mailbox PowerShell Logins  
  • Mailbox Searches  

  

Mailbox Activities (4 reports): 

  • Operations on Mail (Delete, Move, Copy...)  
  • Bulk Operations on Mails (Delete, Move, Copy...)  
  • Mailbox Item Creations  
  • Binded Folders  

 

Mailbox Management Activities (11 reports): 

  • Added Mailbox  
  • Updated Mailbox  
  • Removed Mailbox  
  • Mailbox Enable/Disable Activities  
  • Mailbox Restore Activities  
  • Mailbox Configuration Changes  
  • Outlook Apps  
  • Inbox Features  
  • Inbox Rule Changes  
  • Create or Update Inbox Rules  
  • All Mailbox Operations  

  

Mailbox Permission changes (5 reports): 

  • Mailbox Permission Changes  
  • Mailbox Folder Changes  
  • SendAs Permission Changes  
  • Public Folder Permission Changes  
  • Folder Permissions  

  

Public Folder Changes (5 reports): 

  • Recently Added Public Folders  
  • Recently Updated Public Folders  
  • Recently Removed Public Folders  
  • Activities on Mail Public Folders  
  • All Activities on Public Folders  

  

Advanced Threat Protection (8 reports): 

  • Safe Attachments Config Changes  
  • Safe Link Config Changes  
  • Anti-Spam Config Changes  
  • Anti-Malware Config Changes  
  • Phishing Filter Config Changes  
  • Junk Email Config Changes  
  • DKIM Config Changes  
  • All Advanced Threat Protection (ATP) Activities  

  

Role Changes (6 reports): 

  • Management Role Changes  
  • Role Assignments Changes  
  • Role Assignments Policy Changes  
  • Role Entry Changes  
  • Role Group Changes  
  • Exchange Management Role Scope Changes  

  

Groups & Contacts Changes (6 reports): 

  • Office 365 Group Changes  
  • Distribution Group Changes  
  • Dynamic Distribution Group Changes  
  • All Group Changes  
  • Mail Contact Changes  
  • Mail User Changes  

  

Mail Flow Activities (7 reports): 

  • Mail Flow Configuration Changes  
  • Transport Rule Changes  
  • Connector Changes  
  • Accepted Domain Configuration  
  • Remote Domain Configuration  
  • Hybrid Configuration Changes  
  • Federation Configuration Changes  

  

Mobile Device Activities (3 reports): 

  • Mobile Device Configuration Changes  
  • Exchange ActiveSync Configuration Changes  
  • Text Message Settings Changes  

  

Exchange DLP Activities (2 reports): 

  • DLP Rule Detected Mails  
  • Data Loss Prevention Configuration Changes  

Email Audit Reports (21 reports): 

Email Activities (3 reports): 

  • All Mails  
  • User's Send As Activities   
  • User's Send On Behalf Activities  

  

Spam and Malware Mails (4 reports): 

  • Spam Mails Sent  
  • Spam Mails Received  
  • Malware Mails Sent  
  • Malware Mails Received  

  

User's Email Statistics Report (4 reports): 

  • Daily Mail Read/Sent/Received Count by Users  
  • Mail Statistics (Read/Sent/Received) Summary of User Mailboxes  
  • Daily Exchange Active User Count by Activity  
  • Daily Overall User Email Traffic   

  

Overall Email Statistics (4 reports): 

  • Top Mail Senders  
  • Top Mail Receivers  
  • Daily Overall Traffic Summary  
  • Daily User Traffic Summary  

  

Spam/Malware Statistics (6 reports): 

  • Top Spam Senders  
  • Top Spam Receivers  
  • Top Malware Senders  
  • Top Malware Receivers  
  • Top Malwares Received  
  • Top Malwares Sent  

Dashboards Preview:

 

 

 

Reporting Capabilities Highlights:

This product comes with advanced reporting capabilities which make tedious reporting task to an easier one.

 

Release Updates:

 

Aug 2, 2020 - AdminDroid now collects the report and audit data for multiple Office 365 tenants concurrently. The number of concurrent sync-jobs will be determined based on its nature, APIs used, Office 365 throttling limit, etc. The subsequent sync-jobs will be queued and processed automatically.

 

July 21, 2020 - You can now hide the filter pane in the reports to get extra report-view-area. A visual indicator will be displayed when you hide the filter page with the number of filters applied, on the filter icon.

 

July 19, 2020 - Office 365 Modern Authentication Support, Manage Multiple Office 365 Tenants, Tenant-based Delegation, Intelligent Filtering in Schedule, Schedule with Views & Filters, Schedule with Preferred Columns, Subscribe Scheduled Reports, 2 New Dashboards, 150+ New Reports.

 

Dec 17, 2019 - Added an option to quickly copy any value from a report result to clipboard.

Dec 14, 2019 - 
Global Reader Support, Data Retention Settings, Disk Space Alerting, Activity Alerts Reporting, OneNote Auditing, Microsoft Teams Membership Auditing, 150+ New Reports, and more.

 

June 20, 2019 - 20+ New Office 365 Reports on Auditing Risky Sign-In Attempts, User Admin Role Changes, File Access Activities by Guest Users, and more.

 

Feb 27, 2019 - 100+ New Reports on Office 365 Secure Score, MFA/2FA, License Expiry, Password Expiry and more. 2 new Security Dashboards. 

 

June 12, 2018 - 75+ New Exchange Online Reports, 5+ New Dashboards, AI Based Report Search Console and more awesome features.


Feb 27, 2018 - Added 100+ new reports: Inactive Users Report and Usage Reports on Exchange Online, SharePoint Online, OneDrive for Business, Skype for Business, Yammer, Microsoft Teams, Pro Plus and more.


Jan 11, 2018 - Added 20+ new reports: Power BI Auditing Reports, Usage & Adoption Analytics.


Dec 19, 2017 - Added 10+ new reports: Microsoft Teams Usage & Adoption Reports, External Users Reports, and more.


Oct 1, 2017 - Added 25+ new SharePoint Online Reports.


Sep 27, 2017 - Added 2 new dashboards: Users & Administrators activities trend, Office 365 Usage & Adoption.


Sep 25, 2017 - Added 15+ new Skype for Business Reports, 10+ General Auditing Reports, Smart Filters


Jun 30, 2017 - Added 30+ new OneDrive for Business Auditing Reports


May 17, 2017 - Added 170+ new Auditing Reports for Azure AD, Exchange Online, and SharePoint Online.