The User Console provides download options for Microsoft 365 client license information and user activity reports.

Generating Microsoft 365 or custom user reports

Navigate to the User console:
1. From the Clients console, select a specific client.
2. Click the Users menu to access personnel data.
Apply filters or customize Columns:
1. Use filters such as In Microsoft 365 Status, MFA Status, or Last Activity to refine the dataset.
2. Adjust visible columns to include only the metrics you need for your report.
Select the Download Option:
1. For spreadsheets:
  1. Click the Spreadsheet download button and choose between visible or all columns.
2. For detailed M365 reports:
  1. Click the User Report download button to generate the desired report type.

Here’s what is included in the available options:

This is ideal for generating quick snapshots or sharing customized datasets with stakeholders.

Export data as a CSV file or an Excel spreadsheet.
Options include:
- Visible Columns: Exports only the data currently displayed in the User Console.
- All Available Columns: Exports all data fields, regardless of visibility in the current view.

Provides a report containing all Microsoft 365 data for users under the selected client.

Includes details such as:
- User activity and role information.
- MFA status and authentication methods.
- Assigned licenses and usage data.
Additional Option: Generate a Custom User Report with selected columns and filters applied to the data.

Additional articles to read