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.
Related
Related
Related
Related