PowerShell Free Office 365 Reporting Tool

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

 

Exchange Online Reports (89 reports):

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.

azure-overall-dashboard   exchange-overall-dashboard exchange-audit-overall-dashboard   sharepoint-overall-dashboard AdminDroid MFA Dashboard  Office 365 Password expiry report  Office 365 license usage report   AdminDroid Overall Dashboard Office 365 group reports Office 365 mailbox report Exchange Mailbox usage report Office 365 reporting tool Office 365 email traffic report usage_adoption_dashboard PowerShell free Office 365 reporting tool  Office 365 reporting tool technet

 

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.
  • Rich Filters – 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.
  • Report Export – 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.
  • Non-admin Delegation – Allow non-admins to view reports and statistics.
  • Easy Setup – Easy to set up. No prerequisites to install.
  • Auto Update – 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.