A PowerShell Module with tools built for gathering data and creating reports on various areas of M365 services. This module is designed with ease of use with several baked in custom reports and the ability to export any built in Admin center usage report. Reports can be easily exported to CSV file, Excel workbook(s), or JSON.
This module leverages the Microsoft Graph PowerShell SDK, Exchange Online PowerShell, SharePoint Online PowerShell and ImportExcel. The majority of commands use the Graph SDK and seamlessly handle the permission scope and connection to Graph for you. For more information on working with the Graph SDK see my article.
To install:
Install-Module M365.Report.ToolsReport of every group including group type and source of authority.
Report of every mailbox including details such as mailbox size.
Get every group a user is a member of
Summarize all Sharepoint sites including details for each site such as storage usage and sharing capabilites.
Return all AzureAD enterprise applications with SAML SSO integration.
Return a list of every channel in each Team including members.
Return a list of all Teams and Team members.
Return a list of all licenses in a tenant including current utilization.
Return any of the baked in Admin Center period usage reports for easy export.
List every license assigned to every user
Get a summary report for all user accounts in an M365 tenant.
Get the current Admin Report setting for Admin Center period usage reports.
Change the admin report settings to hide or show names in Admin Center usage reports.
If using PowerShell Core (any version above 5.1) there is an issue with the SPO module (Microsoft.Online.SharePoint.PowerShell). You must
install this module under Windows PowerShell, then use compatability mode to import the module into PowerShell core
Import-Module Microsoft.Online.SharePoint.PowerShell -UseWindowsPowerShell
Please remember to disconnect from the Microsoft Graph / Exchange Online / SharePoint online after using any of these functions!