Office 365 User Reports Tool

Run a report on all your Office 365 Users, this includes any users you may be syncing from onprem Active Directory. Select any Azure AD attribute from your users from the manage columns.  Filter your reports, selecting which Office 365 / Azure AD attribute you would like to run a report on.  Schedule reports when to run to automatically email you and also export reports as (CSV, Excel, PDF, HTML, CSVDE).

Create reports against your Azure AD Audit logs for Sign-in activity for your Office 365 login activity. Filter on number of days within the last month for Office 365 user login history and the following: 

• What location they logged in from
• Which IP Address they logged in from
• Device Used
• Device OS
• Device is Compliant
• Device is Managed
• Device Trust Type
• Browser Used
• Application logged in from
• Geo Location
• Risk Details
• Risk Event Types
• Risk State
• Sign-in Status
• Sign-in Failure reason
• Conditional Access Status
• Interactive Status
• And more..

Run an Azure AD Audit log report on your Azure AD / Office 365 user changes based on 58 different Azure AD Activities from User Management category from your Azure AD log.

The following columns can be configured to filter your Office 365 audit reports:

• Activity
• When (Date)
• Result Status (Success / Failure)
• Result Failure Reason
• Initiated by Actor
• Actor (IP Address)
• Initiated by App
• Initiated by Service
• Operation Type
• Target
• Modified Properties
• Additional details

Run a report against your Azure AD audit log and filter by the last 30 days and detect user accounts that are having failed logins.  Get the following details about your failed Office 365 user / Azure AD user logins. Use our filter to filter your reports based on entries on any of these activities:

• Client IP Address 
• Client App Used
• Date / Time of failure
• Device Name
• Interactive Status
• Location City
• Sign-in Resource
• Sign-in Status
• App display name
• APP ID
• Conditional Access Policy
• Device ID
• Device Trust type
• Device OS
• Device Browser
• Device is compliant or not
• Device is managed status
• Location Country
• Location GEO
• Location State
• ID
• Risk Details
• Risk Event Types
• Risk Level Aggregated
• Risk Level During Sign-in
• Risk State
• User ID
• User Agent
• Conditional Access Status

Run a report against your Azure AD audit log and filter by the last 30 days and detect user accounts with successful logins.  Get the following details about your successful Office 365 user / Azure AD user logins. Use our filter to filter your reports based on entries on any of these activities:

• Client IP Address 
• Client App Used
• Date / Time of failure
• Device Name
• Interactive Status
• Location City
• Sign-in Resource
• Sign-in Status
• App display name
• APP ID
• Conditional Access Policy
• Device ID
• Device Trust type
• Device OS
• Device Browser
• Device is compliant or not
• Device is managed status
• Location Country
• Location GEO
• Location State
• ID
• Risk Details
• Risk Event Types
• Risk Level Aggregated
• Risk Level During Sign-in
• Risk State
• User ID
• User Agent
• Conditional Access Status

Run a report and get a list of your Office 365 users / Azure AD users who have never logged on.

Get a report on Azure AD / Office 365 disabled, locked, blocked users.

This report is based on cloud only users you have setup in Azure AD.  Create custom report based on selected Azure AD attributes for your Office 365 Users. For example check Office 365 User License status.

The Office 365 managers report will allow you to find out which users have managers configured and which users don't have managers. You will also be able to find out a managers direct reports, which users report to which manager.  You can filter any user attribute based on this report.

Run a report to find out about any guest users you have in your Azure AD.  A good report to find any active accounts that shouldn't still need access.  You should make sure any guest accounts are regularly reviewed and if they still require access.

Filter your reports to find users with specific Azure AD attributes that are missing. Create custom reports based on any attribute that are empty.

Create reports to find users with the same Azure AD attribute. Filter any column / attribute in your reports.

Create reports based on users you're syncing from your on prem Active Directory.  Filter your reports based on synced users and create custom reports.  You can also get reports on users with Azure AD Connect sync errors and find out what error is causing users not to sync to Azure AD.

Displays all ActiveSync enabled users in your Office 365 environment. It generates critical details such as server name, database, and more. To manage the access of Office 365 data from mobile devices.

Create a report on recently deleted Office 365 users (Azure AD users) and filter by number of days.  Find the date and time an account was deleted.

Create a report on recently created Office 365 users (Azure AD users) and filter by number of days.  Find the date and time an account was created.  Set filters to see when the last password change happened also.

This report will allow you to find out what Azure AD objects users have created, for example Azure AD applications, Service principal accounts, Groups and details about these objects, dates and times they were created.  This report will only show objects created by non admins.  Useful to audit what users are doing within your Azure AD environment.  

Find out which users have profile photos setup on their Office 365 profiles and which users don't have a picture configured.

Run a report to get the status on Azure AD users (Office 365 users) who have MFA enabled or disabled.  Also get the following details about users multi-factor authentication status:

• Users registered with MFA
• Registered strong auth method for MFA
• Authentication Methods
• Registered Passwordless Strong Authentication
• Default MFA Method
• Allowed Self-service Password (SSPR)
• Met Auth Methods for SSPR
• MFA Status (Enabled or Disabled)

Get details on Office 365 users OneDrive usage by reporting on:

• OneDrive user quotas
• OneDrive user free space state
• OneDrive remaining size for users

Get a report on Azure AD registered devices and owned devices for users.  Get the following details about your Azure AD Devices:

• Device Name (Hostname)
• Operating System (OS)
• Version (OS Version)
• Registered date, time
• Last activity date, time