Office 365 Usage Statistics: Office 365 Analytics Simplified, Automated & Script Free

Having moved to Office 365, administrators must now start looking at regaining complete command and control of Microsoft Office 365 cloud infrastructure. The health and security of Office 365 is no longer determined by home grown processes and tools of the on premise environment. Administrators now have to come to terms with an infrastructure that is not completely under their control. However, getting the right reporting tools that have built-in Office 365 Usage Statistics reports will help them gradually monitor usage and manage the cloud environment.One such must-have tool is Vyapin Office 365 reporting tool that reports on all administrative aspects of Office 365 – Inventory, Management, Security and Compliance and Usage Statistics and Analytics. Vyapin Office 365 reports for SharePoint online and Exchange online have a broad category of reports such as a Dashboard Statistics reports and charts, Mailbox Size Reports, Mailbox Permissions Reports, Users and Groups Reports, Mobile devices reports, license reports and so on. In this section we will examine the Vyapin office 365 Reports presented in the Dashboard Summary.

Office 365 Dashboard – Easy to use Summary Reports

When IT Administrators access Office 365 to create or edit users, assign admin roles to other users, reset user passwords, manage user licenses, manage different types of groups and manage domains and so on among other things, they are constantly looking for important reports along with top level usage statistics and summary that will allow them to carry out their routine and critical tasks effectively without errors or corrections.

Given the volume of data and the different types of reports that can be generated out of Office 365, administrators almost always prefer to have a bird’s eye view of important statistics and summary that they can further drill down only if necessary given the limitations on their time and resources. An administrator managing the Office 365 would find the Dashboard reports in Vyapin Office 365 Management Suite very handy as it offers a wide range of Summary reports and Usage statistics on users/groups created or changed, password changes, connected mobiles devices, shared devices, mail traffic statistics and more. All the reports were displayed both as chart and text data table.

All O365 Dashboard Usage statistics reports and charts can be extracted and presented in management presentations and shared with relevant stake holders for further action. The reports can be exported to a variety of formats such as Excel, Word, PPT and PDF. The reports can be scheduled to be sent by email at regular intervals such as daily or weekly.

Here are some of the important dashboard reports from Vyapin Office 365 reporting tool.

Read more in detail about the Dashboard reports in Vyapin Office 365 Management Suite


Top Users Mailbox Size Report

This report shows the top 10 users based on mailbox size. Other information like User’s Last Login time, Last Log-Off time, type of Mailbox can also be viewed.

Top Users by Mailbox Size


Top Users by Mail Items Count

Top Users Mail Items Count Report

This report shows the list of top Office 365 users based on their number of Mails. Other information like Deleted Item Count, Item Count, Total Deleted Item Size(MB), Total Item Size(MB) are also shown in this report.


Top Public Folders by Size Report

This report gives you the List of top Public Folders based on their size. Other information like User Name, Created Date, Modified Date, Identity, Deleted Item Count, Item Count, Total Deleted Item Size(MB), Total Item Size(MB) can be obtained from this report.

Top Public Folders by Size


Users with Admin Roles

Users with Admin Roles Report

This report helps you to view users with administrative roles. User’s role member type and other properties are also shown in this report.


Groups Report

This report shows you the List of Available Groups and Security Groups. Other information like User, Identity, Display Name, Recipient Type, Recipient Type Details, Notes, Group Type, Created Date, Modified Date also shown in this report.

List of Groups & Distribution Groups


List of Mobile Devices with configuration

Mobile Devices Configuration Report

This report shows you the List of Mobile Devices Connected with your Office 365 account. Other information like User, Mobile Number, IMEI Number, Device OS, Mobile Operator, OS Language, Mobile Number, Device Type, First Time Sync, Device Access State, Disabled, Identity Device Access State Reason, client Version, Client Type, Created Date, Modified Date are also displayed in this report.


Office 365 Users Report

This report shows you the List of Available Users in your Office 365 account. Other information like User Name, First Name, Last Name, Alias, Location, Mail Address, Mobile, Company, Department, Designation, Reporting Manager, Office, City, Country, Account Disabled, Created Date, Modified Date are also shown in this report.

List of Available Office 365 Users and Mailboxes


List of Mobile Devices with configuration

List of External Users

This report shows you the List of Available External Users in your Office 365 account. Other information like User Name, First Name, Last Name, Alias, Location, Mail Address, Mobile, Company, Department, Designation, Reporting Manager, Office, City, Country, Account Disabled, Created Date, Modified Date are also shown in this report.


Office 365 Mailboxes Report

This report shows you the List of Available Mailboxes in your Office 365 account. Other information like User Name, First Name, Last Name, Alias, Location, Mail Address, Mobile, Company, Department, Designation, Reporting Manager, Office, City, Country, Account Disabled, Created Date, Modified Date are also shown in this report.

List of Available Office 365 Users and Mailboxes


List of Shared Mailboxes in Office 365

Office 365 Shared Mailboxes Report

This report shows you the List of Mailboxes that are shared with others in your Office 365 account. Other information like User Name, Alias, Location, Mail Address, Account Disabled, Created Date, Modified Date are also shown in this report.


Recently Added Users Repors

This report shows the list of users who were added recently. Other information like User’s First Name, Company name, Designation, Department, City are also shown in this report.

List of Recently Added Office 365 Users / Groups


List of Recently Added Office 365 Users / Groups

Recently Added Groups Report

This report shows the list of groups who were added recently. Other information like User’s First Name, Company name, Designation, Department, City are also shown in this report.


Non-Admin Users Groups Report

This report shows you the List of Groups managed by Non-Admin users in your Office 365 account. Other details like Identity, Display Name, Alias, Mail Address, Recipient Type, Group type, Managed By, Created Date, Modified Date are also shown in this report.

List of Office 365 Groups managed by Non-Admin users