This Office 365 reporting tool offers 950+ pre-built reports on Office 365 Users, License, Group, Group Members, Security, MFA/2FA, Password Expiry, License Expiry, Subscription Usage, Mailbox Usage, Spam, Malware, Emails Sent/Received, Mail Traffic, Browser Usage, OS Usage, Mailbox Quota, Mailbox Size, Mailbox Auditing, Mailbox Forwarding, External Forwarding, Inactive Mailboxes, Maibox Permissions, Mailbox Protocols, ActiveSync, Mobile Devices, Mailboxes on Hold, Exchange Groups, Inbox Rules, Site Usage, Site Collection Auditing, Inactive Sites, SharePoint Admins, Guest Users, External Users, Anonymous Users, Site Group Members, PSTN Usage, Skype Conferences, Skype Active Users, Yammer Groups, Teams Channels, Device Usages, Internal/External File Sharing, Office 365 Active/Inactive Users, Pro Plus Activations, Inactive Groups etc.

Never struggle with PowerShell scripts for office 365 reports anymore. This GUI tool offers you more reporting features like scheduling, customization, advanced filtering, exporting(CSV, HTML, PDF, XLS, XLSX) and more.

Along with these reports, this O365 reporting software offers 18 smart visually appealing analytical dashboards in which you can get statistics about your Office 365 environment very easily.

You can Download the tool by clicking here.

Supported Services:

Azure Active Directory (45 reports)

Security Reports (28 Reports)

Exchange Online (89 reports)

SharePoint Online (43 reports)

OneDrive for Business (11 reports)

Skype for Business (22 reports)

Yammer (20 reports)

Microsoft Teams (50 reports)

General Office 365 Reports (13 reports)

This tool also provides 500+ Auditing reports on Office 365.

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

Azure Active Directory Reports (45 reports):

Office 365 User Reports (11 reports):

All Users

Disabled Users

Enabled Users

Recently Created Users

Recently Deleted Users

Users Not in Any Group

Cloud Users

Synced Users

Release Track Users

Users with Validation Errors

All Contacts

Office 365 License Reports (7 reports):

All Licensed Users

Licenses can be Regained

Users by Subscription Assigned

Detailed License Provisioning Report

Unlicensed Users

Users with Free Subscription

Users with Trial Subscription

Office 365 License Expiry Reports (5 reports):

Users with Soon-to-Expire Purchased Subscriptions

Purchased Subscription Expired Users

Users with Soon-to-Expire Trial Subscriptions

Trial Expired Users

Users with Suspended Subscriptions

Office 365 Subscription Reports (6 reports):

Subscription Usage

Expired Subscription

Unused Subscriptions

Purchased Subscription

Trial Subscriptions

Free Subscriptions

Office 365 Group Reports (12 reports):

All Groups

Group Members

Nested Groups

Security Groups

Distribution Groups

Mail Enabled Groups

Cloud Groups

Synced Groups

Groups Size

Empty Groups

Recently Deleted Groups

Groups with Contact as Member

Manager Reports (4 reports):

Managers and Direct Reports

Users with Manager

Users Without Manager

All Managers

Security Reports (28 reports):

MFA/2FA Reports (8 reports):

Users with MFA

Users without MFA

MFA Enabled Users

MFA Enforced Users

MFA Activated Users

MFA Non-activated Users

MFA Device Details

User’s MFA Details

Password Reports (9 reports):

Password Expired Users

Users with Soon-to-Expire Password

Users with Password Never Expires

Users with Password Expiry

Password Never Changed Users

Password Not Changed in 90 Days

Recently Password Changed Users

Users with Weak Password Allowed

Password Policy

Office 365 Admin Reports (6 reports):

All Admins

Admin Roles by Users

Administrative Apps

Admins with Password Never Expires

Admins without MFA

Recently Created Admins

External User Reports (5 reports):

External/Guest Users

Recently Created External Users

Recently Deleted External Users

External User Group Membership

Groups by External Users Count

Mailbox Info Reports (6 reports):

All Mailboxes

User Mailboxes

Active vs Inactive

All Active Mailboxes

Recently Created Mailboxes

Recently Deleted Mailboxes

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

SharePoint Online Reports (43 reports):

Site Collection Reports (3 reports):

All Site Collections

Site Collection Sharing Configurations

Site Collection Upgrade Information

SharePoint Site Reports (6 reports):

All Sites

Recently Created Sites

Sites without Recycle Bin

Site Sharing Configurations

Sites with Custom Permission

Project Web Apps

Inactive Office 365 Sites Reports (3 reports):

Inactive SharePoint Sites by Last Change Time

Inactive SharePoint Sites by Last File Activity

Inactive SharePoint Sites by Last Page View

SharePoint Site Users (4 reports):

SharePoint Users by Sites

SharePoint Site Admins

SharePoint Guest Users

SharePoint Site Owners

Inactive SharePoint Users Reports (5 reports):

Inactive SharePoint Users by Last File Accessed Time

Inactive SharePoint Users by Last File Synced Time

Inactive SharePoint Users by Last External File Sharing

Inactive SharePoint Users by Last Internal File Sharing

Inactive SharePoint Users by Last Page Accessed Time

SharePoint List Reports (8 reports):

All Lists

Hidden Lists

Inactive Lists

Empty Lists

List with IRM Enabled

Lists with No Versioning

List with Attachment Enabled

Lists with Custom Permission

Document Libraries (8 reports):

All Document Libraries

Hidden Documents

Inactive Document Libraries

Empty Document Libraries

Document Libraries with IRM enabled

Document Libraries with No Versioning

Document with Attachment Enabled

Document Libraries with Custom Permission

SharePoint Site Groups (4 reports):

SharePoint Groups by Sites

Security Groups by Sites

Empty SharePoint Groups by Sites

SharePoint Group Members

SharePoint Daily Summary (2 reports):

Daily Summary of Activities on SharePoint Files

Daily Summary of SharePoint Active Users

OneDrive Business Reports (11 reports):

Inactive OneDrive Users Report (4 reports):

Inactive OneDrive Users by Last File Accessed

Inactive OneDrive Users by Last Internal Sharing Activity

Inactive OneDrive Users by Last External Sharing Activity

Inactive OneDrive Users by Last File Synced Time

OneDrive Storage (2 reports):

OneDrive Storage Over Time by User

Overall OneDrive Storage Used

Daily Summary (5 reports):

Daily OneDrive Activities Performed by Users

Daily Activities Count on OneDrive Files

Daily User Activities Count on OneDrive Files

Daily Active OneDrive Users Count

Daily Active OneDrive Files Count

Microsoft Teams Reports (50 reports):

Teams Report (9 reports):

All Teams

Public Teams

Private Teams

Archived Teams

Recently Created Teams

Recently Deleted Teams

Teams Without Description

Teams with Private Channel

Teams Statistics

Teams Membership Report (4 reports):

Teams Members

Teams Owners

Teams with External Members

Teams without Owner

Channels Reports (6 reports):

Teams Channels

Standard Channels

Standard Channel Owners

Standard Channel Members

Channels with External Members

Channels Without Description

Private Channels Reports (6 reports):

Private Channels

Private Channel Owners

Private Channel Members

External Members / Guests in Private Channels

Private Channels by External Member Count

Private Channels without Team Owner

Apps and Tabs (3 reports):

Microsoft Teams – Apps

Microsoft Teams – Tabs

Settings on Apps, Tabs and Connectors

Teams Settings (6 reports):

Mentioning in Teams/Channels

Teams Message Settings

Teams Settings by Member Permissions

Teams Settings by Guest Permissions

Teams Fun-stuff Settings

Teams with Default Settings Modified

User Activities (2 reports):

Daily Teams Activities by Users

Overall Teams Activities by Users

Inactive MS Teams Users Reports (4 reports):

Inactive Teams Users by Last Team Chat Message Sent

Inactive Teams Users by Last Private Chat Message Sent

Inactive Teams Users by Last Call Activity

Inactive Teams Users by Last Meeting Activity

Daily Summary (3 reports):

Teams Daily Active Devices

Teams Daily Activities

Daily Active Teams Users by Activities

Device Usage (7 reports):

Active Teams Users with Web Browser Access

Active Teams Users with Windows Phone

Active Teams Users with Android devices

Active Teams Users with iOS devices

Active Teams Users with Windows devices

Active Teams Users with Mac Devices

Daily Teams Activity of Users by Device

Yammer Reports (20 reports):

Inactive Yammer Users Report (4 reports):

Inactive Yammer Users by Last like received date

Inactive Yammer Users by Last Post Posted Date

Inactive Yammer Users by Last Post Read Date

Inactive Yammer Users by Last Activity Date

User Activities (2 reports):

Daily Active Yammer Users Detail

User Overall Activity Count

Inactive Yammer Groups Reports (5 reports):

Inactive Yammer Groups by Last Like Received

Inactive Yammer Groups by Last Post Posted

Inactive Yammer Groups by Last Post Read

Inactive Yammer Groups by Last activity

Daily Inactive Yammer Groups stats

Group Activities (2 reports):

Daily Activity Details by Groups

Overall Yammer Group Activity Summary

Device Usage (7 reports):

Daily Yammer Active Devices of Users

Active Yammer Users with Web Browser

Active Yammer Users with Windows Phone

Active Yammer Users with Android Phone

Active Yammer Users with iPhone

Active Yammer Users with iPad

Active Yammer Users with Others

Skype for Business Reports (22 reports):

User Activities Report (5 reports):

Daily Peer-to-Peer Sessions Summary

Organized Conferences of Users

Participated Conferences of Users

User’s File Transfers

User’s Instant Messages

Users App Usage (5 reports):

Recent Skype Activities in Windows

Recent Skype Activities in Windows Phone

Recent Skype Activities in Android Phone

Recent Skype Activities in iPhone

Recent Skype Activities in iPad

Client Devices (3 reports):

User Activities by All Devices Types

User Activities by Mobile Client

User Activities by Desktop Client

Call Details Summary (3 reports):

Daily Organizers Call Duration Summary

Daily Participants Call Duration Summary

Daily Peer-to-Peer Call Duration Summary

Overall Summary (6 reports):

Daily Active Users by Activity Type

Daily Active Devices Summary

Daily Overall Activities Summary

Daily Organizer Activities Summary

Daily Participant Activities Summary

Daily Peer-to-Peer Activities Summary

General Reports (13 reports):

Office 365 Active Users (2 reports):

Last Active Time of Users by Office 365 Services

Daily Active User Count by Office 365 Services

Office 365 Groups (5 reports):

All Office 365 Groups

Groups by Owners Count

Group Owners

Office 365 Groups Usage Trend

Office 365 Groups Activity Trend

Office 365 Group Creations (3 reports):

Groups Created via Teams

Groups Created via Yammer

Groups Created via SharePoint

Software Installs (3 reports):

Office Suite Activation Summary by Users

Project Client Activation Summary by Users

Visio Client Activation Summary by Users

Office 365 Reporting Dashboards:

This Office 365 Reporting tool offers many analytical dashboards to cover all of your Office 365 and Exchange Online reporting and auditing needs.

Office 365 Reporting Tool – Capabilities Highlights:

This Office 365 Reporting tool comes with advanced reporting capabilities which make tedious reporting task to an easier one.

Automatic Schedule – Schedule one or more reports to run automatically at the configured time and delivered straight to your preferred mail-ids.

Schedule one or more reports to run automatically at the configured time and delivered straight to your preferred mail-ids. Rich Filters – Apply filter on any columns to see only the required information and save the filter for future use.

Apply filter on any columns to see only the required information and save the filter for future use. Easy Customization – Allow you to easily customize the reports by rearranging, adding or removing the columns and its size.

Allow you to easily customize the reports by rearranging, adding or removing the columns and its size. Report Export – Ability to export the reports to CSV, PDF, HTML, RAW, XLS or XLSX.

Ability to export the reports to CSV, PDF, HTML, RAW, XLS or XLSX. User Friendly – Do complex tasks with few mouse clicks using a simple to use web-based interface.

Do complex tasks with few mouse clicks using a simple to use web-based interface. Non-admin Delegation – Allow non-admins to view reports and statistics.

Allow non-admins to view reports and statistics. Easy Setup – Easy to set up. No prerequisites to install.

Easy to set up. No prerequisites to install. Auto Update – No maintenance as the product will automatically update to latest version.

No maintenance as the product will automatically update to latest version. Advanced Scheduling Capabilities – Easily schedule with views & filters, receive the scheduled reports only with the latest information, schedule with preferred column arrangements, etc.

Release History:

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.

This Office 365 Reporting tool originally published in Microsoft’s TechNet gallery. Since the TechNet gallery is under deprecation, you can download this tool from AdminDroid site directly.