User Reporting
Review account status, licensing state, department and job title details from one searchable user report.
Free M365 Reporting Tool • Microsoft Graph Powered
Free Microsoft 365 Reporting Tool with 55+ Ready-to-Use Reports
Generate Users, Groups, Teams, Entra ID Audit Logs, Azure AD Sign-in Logs, Admin Role Audit Logs, and Admin Role Assignment reports from one lightweight reporting solution built for Microsoft 365 tenant admins.
- Runs locally with SQLite
- Simple HTML/JS frontend
- Advanced report filters
- Export-ready admin reports
- Users, Groups and Teams visibility
- Audit and Sign-in investigations
Read Installation Instructions for set up guidance.
Preview: filter-ready Microsoft 365 reports inside the M365Corner Reporting Tool.
55+Reports covering Microsoft 365 Users, Groups, Teams, Audit logs, Sign-ins and Admin Roles.
GraphBuilt on Microsoft Graph for accurate tenant reporting.
LocalUses a lightweight Node.js and SQLite architecture that runs locally on your OS. No data is tracked or captured.
FreeDesigned as a free reporting solution for Microsoft 365 admins.
One Tool for Tenant Visibility, Auditing and Investigation
Stop switching between Microsoft 365 Admin Center, Teams Admin Center, Entra Admin Center, Azure AD sign-in logs and audit logs just to answer everyday admin questions.
Reduce Portal Hopping
Bring User, Group, Teams, Audit and Sign-in insights into one reporting experience.
Improve Tenant Hygiene
Identify disabled users, empty groups, groups with disabled users, Teams without descriptions and other cleanup opportunities.
Speed Up Investigations
Use actor UPN**, target UPN**, logged-in user, application name, error code and role filters to find the records that matter.
Support Governance
Track ownership, membership, admin roles, role assignment activity and sign-in behavior from practical admin-focused reports.
** TargetUPN -- refers to UserPrincipalName/Display Name of the entity that was the "Target" of the action. Could be user, group or any other resource.
See the Reporting Tool in Action
Real report screens from the Free M365 Reporting Tool show how admins can filter, review and export Microsoft 365, Azure AD and Entra ID reporting data from a simple interface.
Group Governance
Identify groups with disabled users and use group/member filters to support tenant cleanup and access reviews.
Teams Visibility
Track Teams ownership, visibility, archival status and channel counts without jumping between admin portals.
Built for Faster Investigations
Audit and sign-in reports are designed around practical investigation filters, helping admins quickly answer who did what, who was affected and why a sign-in failed.
Audit Log Filtering
Use actor UPN and target UPN filters to narrow Entra ID audit log events to the exact admin action or target object.
Failed Login Review
Investigate failed sign-ins by logged-in user, application name and logon error to reduce troubleshooting time.
Failure Code Summary
Quickly see which sign-in error codes are most common and prioritize the authentication issues affecting users most.
Reports Included in the Free Edition
The Free Microsoft 365 Reporting Tool includes Users, Groups, Teams, Entra ID, Azure AD, audit log, sign-in log and admin role related reports.
User Reports
Get clear visibility into Microsoft 365 users, account status and licensing gaps. These reports help admins filter users by department, job title and licensing state without relying on multiple admin center views.
- Microsoft 365 User Report
- Enabled Users Report
- Disabled Users Report
- Unlicensed Users Report
Group Reports
Get a 360-degree view of Microsoft 365 groups, including unified groups, security groups, distribution lists, empty groups, group ownership and membership.
- All Microsoft 365 Groups
- Unified Groups
- Empty Groups
- Security Groups
- Mail-Enabled Security Groups
- Distribution Lists
- Recently Created Groups
- Group Members Report
- Group Owners Report
- Groups with Disabled Users
Teams Reports
Manage Teams visibility, ownership and governance with reports for public Teams, private Teams, archived Teams, recently created Teams, and Teams with private or shared channels.
- All Teams
- Public Teams
- Private Teams
- Archived Teams
- Team Owners
- Recently Created Teams
- Teams Without Description
- Teams with Private Channels
- Teams with Shared Channels
User Audit Log Reports
Track user lifecycle changes in Entra ID and quickly identify who created, deleted, enabled, disabled or hard deleted user accounts.
- Audit Created Users
- Audit Deleted Users
- Audit Enabled Users
- Audit Disabled Users
- Audit Hard Deleted Users
Common filters: Actor UPN and Target UPN.
Group Audit Log Reports
Investigate group lifecycle, membership and ownership changes. Quickly answer who created, deleted, updated, restored or permanently deleted groups, and who changed members or owners.
- Audit Created Groups
- Audit Deleted Groups
- Audit Updated Groups
- Audit Group Member Additions
- Audit Group Member Deletions
- Audit Group Owner Additions
- Audit Group Owner Deletions
- Audit Group Restores
- Audit Group Hard Deletions
Common filters: Actor UPN and Target UPN.
Admin Role Audit Log Reports
Track when sensitive admin roles were assigned, who assigned them and who received them. This is ideal for privilege assignment audits and security reviews.
- Audit Global Admin Role
- Audit Teams Admin Role
- Audit User Admin Role
- Audit Password Admin Role
- Audit Groups Admin Role
Shows assignment activity: when the role was assigned, by whom, and to whom.
Admin Role Assignment Reports
View current administrative role assignments and understand what role is assigned and to whom. These reports help identify disabled admins, department-specific admins and group-assigned role access.
- Global Admins Report
- Teams Admins Report
- User Admins Report
- Password Admins Report
- Groups Admins Report
Filters: Department, Sign-in Status and Principal Type.
User Sign-in Log Reports
Analyze Entra ID and Azure AD sign-in activity to troubleshoot failed logins, review successful logins, track application-based logins and investigate failure codes.
- All Logins Report
- Failed Logins Report
- Successful Logins Report
- Application Based Logins Report
- Login Failures by Code Report
Filters may include Logged-in User, Operation, Login Error, Application Name and Error Code.
Complete Report Catalog at a Glance
Users
- All users
- Enabled users
- Disabled users
- Unlicensed users
- Licensed users
Groups
- All groups
- Unified groups
- Empty groups
- Security groups
- Distribution lists
- Owners and members
- Recently Created Groups
- Groups with Disabled Users
- Mail-Enabled Security Groups
Teams
- All Teams
- Public and Private Teams
- Archived Teams
- Team Owners
- Private and shared channels
- Teams without description
- Recently Created Teams
- Teams with Hidden Memberships
Audit Logs
- User changes
- Group changes
- Role assignment activity
- Actor and target UPN filters
Admin Roles
- Global Admins
- Teams Admins
- User Admins
- Password Admins
- Groups Admins
Sign-ins
- All logins
- Failed logins
- Successful logins
- Application logins
- Failure codes
Filters
- Department
- Job title
- License state
- Principal type
- Application name and more
Use Cases
- Tenant cleanup
- Governance
- Access reviews
- Audit investigations
- Export-ready reporting
See What You'll Get
The Free Microsoft 365 Reporting Tool gives admins full-width, export-ready reports with built-in filters, searchable tables and practical investigation views.
Example: Login Failures by Code Report with failure reason, count and percentage summary.
Ready to Simplify Microsoft 365 Reporting?
Download the Free M365 Reporting Tool and generate Microsoft 365, Azure AD and Entra ID reports in minutes from a lightweight local reporting solution.
Frequently Asked Questions
Is this Microsoft 365 reporting tool free?
Yes. The Free Edition is available at no cost and includes 55+ reports for Microsoft 365 admins.
Does it support Entra ID/Azure AD reports?
Yes. The tool includes Entra ID audit log reports, Azure AD sign-in reports, admin role reports and role assignment reports.
Does the tool use Microsoft Graph?
Yes. The reporting tool uses Microsoft Graph to fetch tenant data and generate admin-focused reports.
Does it run locally?
Yes. The tool is built with Node.js, SQLite and a simple HTML/JS frontend, giving admins a lightweight local reporting experience.
Can admins filter reports?
Yes. Depending on the report, filters include department, job title, licensing state, actor UPN, target UPN, logged-in user, application name, error code, sign-in status, principal type and more.
Who is this tool built for?
It is built for Microsoft 365 tenant admins who need faster visibility into users, groups, Teams, audit logs, sign-in activity and administrative roles.
Download the Free Microsoft 365 Reporting Tool
Get Users, Groups, Teams, Entra ID, Azure AD, Audit Logs, Sign-in Logs and Admin Role reports from one practical reporting solution.