Microsoft 365 User Reporting Tool

Office 365 Manager is a desktop-based Microsoft 365 user reporting tool designed to simplify the extraction of Azure AD User details. Its intuitive and user-friendly interface eliminates the need for complex PowerShell scripting. This tool supports a wide range of pre-configured reports and allows you to effortlessly track crucial information about your Office 365 users with just a few clicks.

With this application, you can generate different types of Azure AD user reports. Export the generated report to a different format (CSV, PDF, and Excel). Additionally, you can e-mail the report to a specified email address and schedule reports to send an e-mail or save as a local copy.

Some of the reports are listed below. You can find more reports on the app.

All Users

This report lists all the available users in your Azure AD environment. You can view user account details such as display name, userprincipalname, sign-in status, created date, department, job title, manager, office, email, phone number, is licensed, license details, is guest user, password settings, MFA settings, user object id, and more.

All Azure AD Users report

Account Status Reports

  • Enabled Users: List the enabled user accounts with sign-in access allowed.
  • Disabled Users: Get the list of disabled user accounts with sign-in access blocked and you can instantly enable the required accounts from the app itself.
  • External or Guest User Accounts: This report gives you the complete list of external users that are configured in your Azure AD environment.
  • Guest Users with Pending Accept: This report extracts guest users who yet to accept the external user invite request.
  • Resource Accounts: List of resource type accounts in Azure AD.
Unblock disabled user from sign-in blocked users report

License Reports

  • Licensed Users: This report gives you the list of licensed users along with their applied license details.
  • Unlicensed Users: This report helps you to track the users who are without any license assigned. You can assign the required license from this app.
  • Users based on Applied License: This report helps you to track the users with a specific license (ex: Get the list of users with E3 license, find the list of users with E5 license, Check users with Teams license, find users without Exchange Online license, and more).
Office 365 user license report

Last Logon Reports

  • Users True Last Login Date: This report provides real-time last login date information for all Azure AD Users.
  • Inatcive Users in Last N days: This report assists in identifying inactive users who have not logged in within the last N days.
  • Never Logged-in Users: This report helps to find the users who have never logged in to any of the Microsoft 365 services.
  • Licensed and Never Logged-in Users: This report facilitates the tracking of users who have been assigned a valid Microsoft 365 (M365) license but have never logged in to any of the Microsoft 365 services.
Office 365 user last login report

MFA Status Reports

This app helps you to track the MFA status of Office 365 users with the help of the following reports.

  • MFA Enabled users: List of MFA enabled Azure AD users.
  • MFA Enforced users : List of MFA enabled users with MFA status as Enforced.
  • MFA Disabled users : List of users with MFA disabled status.
  • MFA Registered users : List of users who have registered their MFA security authentication methods and set default authentication method. Also list users who have enrolled their MFA settings through the Conditional Access policy which enforces Multi-factor authentication.
  • MFA Enabled users without registration : List of MFA enabled users who have not completed (or yet to register) their MFA security authentication methods.
MFA  Enabled Users report

Organization Based Reports

  • Users with Manager: List of users who have been assigned under anyone of Manager.
  • Users without Manager: Find users who are without Manager. You can set Manager for the required users from the app itself.
  • All Managers :Get a list of users who have been assigned as a manager for other users.
  • Users based on Manager: Find users who are managed by the selected manager.
  • Users based on Department: Find users who belong to a specific department (ex: Finance, Marketing, HR, and more).
  • Users based on Job Title : Get users with a specific job role (ex: HR Manager, Product Manager, Developer, and more).
Users by Department, Job Title, Manager, Company

Password Status Reports

  • Password Never Expire users: List of user accounts whose password never expires.
  • Password Expired users: Find users with an expired password and you can easily reset the password for the required users from the app itself.
  • Soon to Expire User Password: Find a list of users whose password will expire in the next N days.
  • Recently Password Changed users: Get a list of users who have reset their password in the last N days.
Password Status report

Admin Role Based Reports

  • All Admin Users: List of users with anyone of Admin role.
  • Users without Admin access: List normal user accounts who are without any Admin role.
  • Global Administrators: Get the list of users with Global or Company administrator permission.
  • SharePoint Administrators : Get the list of users with SharePoint administrator permission.
  • Exchange Administrators: Users with Exchange administrator permission.
  • Users by Admin Role: Users with a specific Admin role (ex: User administrator, Helpdesk administrator, Password administrator, etc..).
Office 365 Users with admin role

Recently Created Users

This report gives you the list of Microsoft 365 users that are created in the last N days.

Deleted Users

This report lists all the users that are deleted from Office 365. When a user account is deleted, Azure AD stores the deleted user details until the retention period (ex: 30 days) ends, after that the user account will be permanently deleted, and it cannot be restored. Using this report, you can easily locate the required deleted account and restore it by this app itself.