Microsoft 365 Tenant Discovery Tool

If you have ever tried to collate everything through the M365 console you already know how painful getting all that data together can be. That's why I made this single script that collects everything you need into a single Excel sheet. Perform a complete M365 tenant discovery with this script. Easy to run, save yourself all the effort.

This product is...... A Menu Driven PowerShell script to report on Mailboxes, OneDrive, Teams, SharePoint, DL's, Permissions, MFA Details, Contacts, Guests, Security/Unified Groups, Azure AD Devices, License Information, Conditional Access Policies, Connectors/Transport Rules, Planner, InTune, Devices, Enterprise Apps, Entra Role Assignments, Spam/SafeLink/Attachment Policies, Named Locations and more from your Microsoft 365 tenant.

Current Update - V8.12 - June 2026 - Now reports on the following items in your M365 Tenant

✅Users, Shared Mailboxes, Calendar Permissions

✅OneDrive

✅ SharePoint (including subsites & libraries)

✅ Teams — channels, memberships, policies

✅ Distribution Lists, Security Groups & Unified Groups

✅ MFA status across all users

✅ Planner Details

✅ Intune — devices, compliance policies, config profiles & managed apps

✅ Conditional Access Policies & Named Locations

✅ Entra ID Role Assignments

✅ Anti-Spam, Anti-Malware, Safe Attachments & Safe Links

✅ Email Forwarding Rules (mailbox-level and inbox rules)

✅ External Collaboration & SharePoint Sharing Configuration

✅ Enterprise Apps & OAuth Permissions — with friendly permission names

✅ Microsoft Secure Score with per-control breakdown

✅ Azure AD Devices

✅ License Information

✅ MX Records, Transport Roles, Send/Receive Connectors

✅ Named Locations

✅ Audit Log configuration and more

Full instructions updated and included in the delivery package.

It creates a spreadsheet report that can be easily used as a migration runsheet, filterable and containing a lot of very useful information. Especially in that migration stance. This spreadsheet has a nice summary page at the start showing all the details of the workload usage and consumption. Screenshot of that in the product details below.

All contained in a nicely created spreadsheet at the end.

If you are working with a Microsoft 365 tenant, whether it is for your own or for a client, it is often necessary to obtain a decent report of what is there. You may want to know about all the Mailboxes that are in Exchange Online, Sizing, Delegate information, Licenses, a full listing of Microsoft Teams with members, channels and data sizes, OneDrive sizes/usage, Distribution Lists, Contacts, Guest Accounts and SharePoint sites/data/usage, SharePoint Libraries, Unified Groups, Security Groups, Azure AD Devices, Conditional Access Policies, MX Records, Public Folders, Send/Receive Connectors, Transport Rules and License Information. Lastly it also collects MFA details, showing who has it enforced, who has registered for MFA and the type of authentication (App/Txt/Call) that they selected, the phone number and phone type used, and the last logon date/time. All of the data is bundled up nicely into a very usable Excel file.

All updates to the scripts are available for life. Whenever I update the script I push out a download link for the new version to anybody that has ever purchased it.

With this PowerShell script you can get all this information in one go, or individually, compiled into a single XLS file for easy filtering and reporting.