Skip to content

A PowerShell Module with tools for gathering data and creating reports on various areas of M365 services.

License

Notifications You must be signed in to change notification settings

djust270/M365.Report.Tools

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

37 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

M365.Report.Tools

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

PowerShell Gallery Page

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

Known Issues

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!

About

A PowerShell Module with tools for gathering data and creating reports on various areas of M365 services.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published