For quite a long time, I’ve been doing reports for O365 services. That include Out of the Box reports and custom (mostly PowerShell-based) reports.
Most of the out of the box reports can be found by accessing the official Microsoft article “Office 365 Reporting Features”
For the rest of the custom reports, you can find lots of them on this site, and I will provide some of them below:
- [O365] Get a complete licensing report on your services
- [MS Teams] – Get all teams sites using PowerShell
- [SPO] Find out when a site was created using CSOM
- [SPO] Get a list of all external users in SPO
- [O365] Send service health reports via e-mail
- [LYO] Get the list of domains allowed for SfB federation
- [SPO] List installed Apps through CSOM
- [O365] Get ODB Storage per user (Ver 2)
- [SPO] List all OneDrive for Business provisioned sites using CSOM
- [O365] Export SPO UPA Properties using CSOM
- [O365] Get a report of used browsers
- [O365] Get OneDrive used space for a specific user
But I wanted a more user-friendly way of getting these reports and also, a lot more information in an easy and intuitive way.
Searching for a tool to help me, I came across this article: “Office 365 Reporting Tool” and since it’s listed on Microsoft’s site, I said to give it a go.
You can also find the official page of the Tool at: https://admindroid.com/
The installation is super simple. Just run the “Office365-Reporter.exe” file:
and the Tool will install itself (by default) in C:\Program Files\AdminDroid\Office 365 Reporter
At the end of the installation, the Tool will open-up a browser window (normally on the IP of the machine you installed it on, on port 8000) and ask you to authorize the Tool. You will need Global Admin permissions on your O365 tenant in order to do that:
Note: the tool will show up as a Site in your server’s IIS console:
The site’s application pool is a .NET 4.0 app pool and will run under the”LocalSystem” identity.
The tool will request the following permissions:
Then you will be presented with the full GUI of the Tool and you can explore the Tool’s features:
Now, since I’m a SharePoint Admin, I’ll focus more on these features.
You will have to use a service account or use the global admin’s account in order for the Tool to collect SharePoint data:
This will create a new (unlicensed) user in your tenant’s AzureAD.
Now, back to the SharePoint reports. Below you can have a bird’s eye view o your SharePoint online environment:
As for the reports, there are a lot of available reports you can request directly from the home screen
Will tons more (more than 100 reports) from the search menu:
For testing purposes, I chose the “All activities Related to SharePoint Pages report”. Below you can see such a sample report:
Thinking on how much time it took me to get O365 licensing reports, I wanted to try the Tool and see what it can offer for me:
And digging deeper literally takes seconds:
As you can see from the screenshot above you have all the subplans for the E1 license + the expiry date of the license. All in one place and easy to read.
Going back to SharePoint and OneDrive, I found some nice reports on how my OneDrive storage evolved:
I will briefly show below some bird’s eye views and reports available on the other O365 services for anyone to have an idea on the main features of the Tool:
Exchange
Teams:
Since one of the most important topics in any company is to know what was shared with whom, the Tool offers about 60+ reports for that:
And talking about companies. Since most of them use a proxy server to access the Internet, the Tool also support proxy servers:
That being said, even if the Tool that not provide you with every possible report you can get via PowerShell, it sure does contain more than 1000 pre-build reports that can help you with most of the reporting situations you will encounter.
You can judge that by yourself by using the Tool’s online demo, available at: https://demo.admindroid.com/
Hope you’ll find it as useful as I did!.