Microsoft 365 Discovery Tool

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 and more from your Microsoft 365 tenant.

Current Update - V7.08 - January 2025

Completely re-written recently to remove the need for the PowerShell modules for PNP Online, SharePoint, Teams. As it now uses MsGraph extensively. The Application Registration and certificates are now fully created in the script making the setup of the data collection incredibly simple and easy. As it uses Graph now, the speed is also massively better than ever before. Also no more excessive login requests with the SPO/PNP modules for constant connections. You can now kick off the script, connect to a single prompt with EXO then walk away and leave it to run completely. Even the connection XML is updated completely by the script itself.

Full instructions updated and included in the delivery package.

To get this script for 50% off, subscribe to my YouTube channel and then email me at mark@thecloudgeezer.com. I will send you the coupon code.

https://youtube.com/thecloudgeezer?sub_confirmation=1

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.

Full mailbox details, showing aliases, SMTP addresses, storage used, inbox counts, delegated permissions, roles, licenses, mailbox types, last access times and legacyExchangeDN details.

OneDrive reports, line matched against the mailbox report, again showing usage and last access times.

Full Tenant SharePoint report, sites, usage, storage, teams links. Including SharePoint Libraries.

Full Tenant Teams report, teams, channels, private channels, ownership and usage.

MFA details for all users, MFA registration status, MFA type, enforcement details and last usage times.

Full Distribution Lists with membership, Contact Lists, Guest Membership

Security Groups and Unified Groups.

Azure AD Devices details including Join Type, Last Use, Registration Dates, OS Versions and User Information.

M365 License Information and Consumption.

MX Records, Transport Rules, Send/Receive Connectors.

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