PowerShell Free Office 365 Reporting Tool

This Office 365 reporting tool offers 750+ 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 (44 reports)
  • Security Reports (22 Reports)
  • Exchange Online (103 reports)
  • SharePoint Online (42 reports)
  • OneDrive for Business  (11 reports)
  • Skype for Business (22 reports)
  • Yammer (20 reports)
  • Microsoft Teams (16 reports)
  • General Office 365 Reports (9 reports)

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

 

Azure Active Directory Reports: (44 Reports)

  • Office 365 User Reports (12 Reports)

    • All Office 365 Users
    • External Users Report
    • Sign-in Disabled Users
    • Sign-in Enabled Users
    • Recently Created Users
    • Deleted Users
    • User Not in Any Group
    • Synced users from on-premise Active Directory
    • Users created in Office 365
    • 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
    • Details of License Provisioning Report
    • Unlicensed Users
    • Users with Free Subscription
    • Users with Trial Subscription

 

  • Office 365 Subscription Reports (5 Reports)

    • Subscription usage
    • Expired Subscriptions
    • Unused Subscription
    • Trial Subscriptions
    • Free Subscriptions

 

  • License /Subscription Expiry Reports (4 Reports)

    • Subscription Expired Users
    • Users with Soon-to-Expire Subscriptions
    • Users with Soon-to-Expire Trial Subscription
    • Users with Suspended Subscriptions

 

  • Office 365 Group Reports (12 Reports)

    • All Groups
    • Group Members
    • Nested Groups
    • Empty Groups
    • Deleted Groups
    • Security Groups
    • Distribution Groups
    • Mail-enabled groups
    • Cloud Groups
    • Synced groups
    • Groups size
    • Groups with Contact as Member

 

  • Manager Reports (4 Reports)

    • Managers and Direct Reports
    • Users with Manager
    • Users without Manager
    • All Managers

 

Security Reports: (22 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 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 (5 Reports)

    • All Admins
    • Admin Roles by Users
    • Administrative Apps
    • Admins without MFA
    • Admins with Password Never Expires

 

Exchange Online Reports: (103 Reports)

  • Mailbox Info Reports (4 Reports)

    • All Mailboxes.
    • All User Mailboxes
    • Active Mailboxes
    • 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)

    • Inactive mailboxes by last login time
    • Inactive Mailboxes by Users’ Last Activity
    • Never Logged in Mailboxes

 

  • 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

 

  • Mail Protection Reports (5 Reports)

    • Spam emails sent
    • Spam emails received
    • Malware emails sent
    • Malware emails received
    • All Emails (Message trace of Incoming and Outgoing emails)

 

  • Mail Traffic Reports (8 Reports)

    • Top mail senders
    • Top mail receivers
    • Top spam senders
    • Top spam receivers
    • Top malware senders
    • Top malware receivers
    • Daily overall traffic summary
    • Daily user traffic summary

 

  • Mail Statistics ( 4 Reports)

    • Daily Overall Email Traffic
    • Daily Exchange Active Users’ Activities Count
    • Daily Mail Read Count by Users
    • Mail Statistics Summary

 

  • Mailbox App Usage (12 Reports)

    • Daily Email App Usage Statistics
    • Daily Email App Usage Statistics by Users
    • Dailly Outlook App Usage by Version
    • Active Exchange Users with ‘Mail for Mac’ App
    • Active Exchange Users with ‘Outlook for Mac’ App
    • Active Exchange Users with ‘Outlook for Windows’ App
    • Active Exchange Users with Browser Access
    • 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
    • Office 365 Basic Authentication report

 

  • Mailbox Settings (9 Reports)

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

 

  • Email Message Settings (7 Reports)

    • Email Signature Settings
    • Out-of-Office Email Settings
    • Out-of-Office Event Settings
    • Message Format Configuration
    • Important Settings for Messages
    • Message Delivery Restrictions
    • Message Size Restrictions

 

  • Mailbox Permission (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
    • Mailbox with Internal Forwarding
    • 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 (3 Reports)

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

 

  • 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)

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

 

  • Exchange Groups (2 Reports)

    • Dynamic Distribution Groups
    • Role Groups

 

  • Other Reports( 4 Reports)

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

 

SharePoint Online Reports: (42 Reports)

  • Site Collection Reports (3 Reports)

    • All Site Collections
    • Site Collection Sharing Configurations
    • Site Collection Upgrade Information

 

  • SharePoint Site Reports (5 Reports)

    • All Sites Report
    • Sites without Recycle Bin
    • Site Sharing configurations
    • Sites with Custom Permissions
    • 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

 

  • Inactive SharePoint Users Reports (5 Reports)

    • Inactive SharePoint Users by Last File Accessed Date
    • Inactive SharePoint Users by Last File Synced Date
    • Inactive SharePoint Users by Last External File Sharing Date
    • Inactive SharePoint Users by Last Internal File Sharing Date
    • Inactive SharePoint Users by Last Page Accessed Date

 

  • SharePoint List Reports (8 Reports)

    • All Lists Report
    • Hidden Lists Reports
    • Inactive Lists Report
    • Empty Lists Report
    • List with IRM enabled
    • Lists with No Versioning
    • Attachement Enabled Lists Report
    • Lists with Custom Permission

 

  • Document Libraries (8 Reports)

    • All Document Libraries Report
    • Hidden Document Libraries Report
    • Inactive Document Libraries Report
    • Empty Document Libraries Report
    • Document Libraries with IRM enabled
    • Document Libraries with No Versioning
    • Attachement Enabled Document Libraries Report
    • Document Libraries with Custom Permission

 

  • SharePoint Site Users (4 Reports)

    • SharePoint Users by Sites
    • SharePoint Site Admins
    • SharePoint Guest Users
    • SharePoint Site Owners

 

  • SharePoint Site Groups (4 Reports)

    • SharePoint Groups by Sites
    • Security Groups by Sites
    • Empty SharePoint Groups by Sites
    • SharePoint Group Members Report

 

  • SharePoint Daily Summary (2 Reports)

    • Daily Active Files
    • Daily Active Users

 

Skype for Business Reports: (22 Reports)

  • User Activities

    • Daily Peer-to-Peer Sessions Summary
    • Organized Conferences of Users
    • Participated Conferences of Users
    • User’s File Transfers
    • User’s Instant Messages

 

  • User’s App Usage

    • Recent Skype Activities on Windows App
    • Recent Skype Activities on Windows Phone
    • Recent Skype Activities on Android Phone
    • Recent Skype Activities on iPhone
    • Recent Skype Activities on iPad

 

  • Client Devices

    • User Activities by All Devices Types
    • User Activities by Mobile Client
    • User Activities by Desktop Client

 

  • Call Details Summary

    • Daily Organizers Call Duration Summary
    • Daily Participants Call Duration Summary
    • Daily Peer-to-Peer Call Duration Summary

 

  • Overall Summary

    • 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

 

OneDrive for Business: (11 reports)

  • Inactive OneDrive Users Report

    • Inactive OneDrive Users by ‘Last File Access Date’
    • 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

    • OneDrive Storage Over Time by User
    • Overall OneDrive Storage Used

 

  • Daily Summary

    • Daily OneDrive Activities Performed by Users
    • Daily Activities Count on OneDrive Files
    • Daily User Activities Count
    • Daily Active OneDrive Users Count
    • Daily Active OneDrive Files Count

 

Yammer Reports: (20 reports)

  • Inactive Yammer Users Report

    • 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

    • Daily Active Yammer Users Detail
    • User Overall Activity Count

 

  • Inactive Yammer Groups 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

 

  • Groups Activities

    • Daily Activity Details by Groups
    • Overall Yammer Group Activity Summary

 

  • Device Usage

    • 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

 

Microsoft Teams Reports: (16 reports)

  • Inactive MS Teams Users 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

 

  • User Activities

    • Daily Teams Activities by Users
    • Overall Teams Activities by Users

 

  • Device Usage

    • 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

 

  • Daily Summary

    • Daily Active Devices
    • Daily Activities
    • Daily Active Users by Activities

 

General Office 365 Reports: (9 reports)

  • Office 365 Active Users

    • Last Active Time of Users by Office 365 Services
    • Daily Active User Count by Office 365 Services

 

  • Office 365 Groups

    • All Office 365 Groups
    • Groups with External Members
    • Office 365 Groups Usage Trend
    • Office 365 Groups Activity Trend

 

  • Software Installs

    • Office Pro Plus 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.

 

Release History:

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.