Generate and Email User Reports Using Graph PowerShell

Managing and reporting on Microsoft 365 users can be time-consuming—especially if you’re trying to track licensing, sign-in status, or guest access manually. With Microsoft Graph PowerShell, you can automate the generation and delivery of tailored user reports straight to your inbox. Whether you're an IT admin overseeing the entire tenant or a department manager keeping tabs on specific groups, these scripts will make your life easier.

This guide consolidates the most useful user reporting scripts from M365Corner.com, making it your one-stop hub for email-ready Microsoft 365 user reports.

Why Generate and Email User Reports Using Graph PowerShell?

PowerShell offers unmatched flexibility for automating daily admin tasks. By combining Graph PowerShell with email functionality, you can:

• Schedule reports and reduce manual workload
• Get visibility into licensing gaps or inactive users
• Support compliance and auditing by maintaining regular logs
• Customize reports to meet departmental or organizational needs

Instead of logging in to the admin portal and exporting reports each time, automate the process and let the reports come to you.

How to Generate and Email User Reports Using Graph PowerShell

You’ll find below a series of ready-to-use scripts that can help you create and deliver reports for different types of user accounts in your Microsoft 365 environment. Each script explains how the logic works and includes examples to help you modify as needed.

• Generate and Email All Microsoft 365 Users Report

This script fetches a complete list of all Microsoft 365 users in your tenant and sends the compiled data as a CSV attachment via email. It's ideal for tenant-wide audits or user lifecycle management.

👉 How to email a full Microsoft 365 users report using Graph PowerShell

• Generate and Email Licensed Microsoft 365 Users Report

Use this script to extract and email a list of only licensed users. It's particularly helpful for license reconciliation, cost analysis, or onboarding/offboarding tracking.

👉 Fetch and email licensed Microsoft 365 users using Graph PowerShell

• Generate and Email Unlicensed Microsoft 365 Users Report

This script pulls out all unlicensed users and sends their details via email. This can help identify inactive accounts or provisioning issues.

👉 How to email unlicensed user reports using Graph PowerShell

• Generate and Email Sign-in Disabled Microsoft 365 Users Report

Get a list of users who are blocked from signing in—great for tracking suspended users, ensuring account security, or auditing offboarded employees.

👉 Fetch and mail disabled Microsoft 365 users report using PowerShell

• Generate and Email Microsoft 365 Guest Users Report

This script retrieves all guest users in your tenant and emails the results. It’s useful for managing external collaboration and ensuring guest access policies are being followed.

👉 How to email a guest users report in Microsoft 365 using PowerShell

• Generate and Email Microsoft 365 Departmental Users Report

Need department-wise segmentation? This script allows you to extract users belonging to a specific department and send a report via email—ideal for HR or department leads.

👉 How to fetch and mail Microsoft 365 users from a department using PowerShell

Conclusion

Automating Microsoft 365 user reporting with Graph PowerShell helps streamline IT operations and improve visibility across your organization. Whether you're tracking license usage, guest access, or sign-in activity, these scripts from M365Corner empower you to stay ahead—with minimal effort.

📩 No more manual exports. Just schedule and receive insightful reports, right in your inbox.