AdminDroid – very powerfull reporting on your M365/O365 tenant

Disclaimer: This review was done based on license provided from vendor to MVPs. Purpose of this review is to provide an overview of the software functionality, with no intention to provide free marketing or sales initiatives. Author was not compensated for this review in any way.

Each organization that uses Office 365 needs reporting from time to time. For bigger organizations, this need is even more frequent. And while you can get some basic GUI based reporting in Office 365 admin center, for more detailed reporting you would probably need to dig in to PowerShell. If you are not an expert (or fan) of the PowerShell or you simply like GUI based reporting with a lot of details, you might want to look at some third-party solutions. One of them, which does a very nice job in this field is AdminDroid.

AdminDroid is a GUI based console, that runs as a web service on your local host and connects to your Office365 tenant to pull various kinds of reports for you. In general, you can pull all these reports by yourself, by using PowerShell, but you will need a lot of knowledge and a lot of time to do it. Also, you might need A LOT more time to pack all these reports in graphic format and that’s the real magic that AdminDroid does. It “listens” to your tenant activities and provide you with almost real time info about various things. For this purpose, you will be to provide a service account on your tenant with Global reader permissions.

When you configure AdminDroid for your Office365 tenant, you will need to leave for some time to gather data. Some data will be available very fast, but for some data you will need to wait for a few hours.
AdminDroid console is divided in two parts – Dashboards and Reports/Audit Reports. While on Dashboard you can see some most important data about your tenant and objects in your tenant, in Reports section you can generate various reports using several filters and download them in appropriate format.

For example, home (Overall) dashboard shows you current state of objects in your AzureAD, Security features such as MFA, state of mailboxes on Exchange Online, as well as data about SharePoint online. See example below:

Capture1

If you need to see more detailed data, each of the key Office 365 services has its own Dashboard. If you click on Azure AD you can see details about your license usage, users and groups and their activities and many other details. On Exchange dashboard you can see details about mailboxes in your organization, but also charts on most active or inactive users, mailbox usage, mailbox traffic and mailbox delegation.

Capture2

Dashboard called Usage and Adoption is especially interesting. Here you can see details about activities per job title, city, state, country and company. So, if your users are in multiple cities/states and you want to see frequency of their activities – this is the place to look for. If you want to see how your Project Managers perform and how they use Office 365 services you should also look here.

However, while looking at the Dashboards might be very interesting, even funny, the real power of AdminDroid is in its reporting capabilities. For each of the key Office365 services you can run dozens of various reports. For each report you can set a view and configure filters to narrow your results. Reports can be downloaded in HTML, PDF, CSV, XLS, XLSX and RAW formats. Reports can be very detailed, as well as large, so it is highly recommended to use filters before running a report. Especially if you have a lot of users.

Audit reports are even more interesting. For example, you can pull a report about all performed SendAs activities in your organization. You can also get a report on each mailbox activity performed on a single mailbox or multiple mailboxes. For AzureAD, you can track login activities, password change/reset activities, admin role management, audit policy management and many more. AdminDroid can even connect to your Intune and pull reports from there. However, if you explore SecureScore reports you can find a lot more than Intune reports – in general, complete Secure Score of your company is available there.

Tracking file and folder-based activities on SharePoint and OneDrive can be very useful for troubleshooting purposes. You can audit and pull in report, every single file/folder activity performed on your tenant, with a bunch of additional details.

Capture4

Security based reports also provides data that might be very useful. I’ve found few reports very useful there. For example, you can quickly get a list of users that failed to pass MFA challenge. Or users that are trying to sign in with expired passwords. There is also a special report on Admin Login failures as well as report on history of admin role assignments activities.

All reports can be pulled on demand or scheduled to perform. You can choose between 796 preconfigured reports to schedule, which is really an impressive number.

So, if you are looking for a good, GUI based, reporting solution for your Microsoft 365 / Office 365 tenant, AdminDroid is definitely worth to try. Pricing is pretty decent, and you can even get a free version – if you are satisfied with Azure AD Reports and Dashboards only. MVPs (Office Apps & Services) can get a free license, while edu and non-profits are having quite a big discounts. Take a look here.

Author: ddamir

Damir Dizdarevic is a b.sc.math and IT professional. He works as a manager of MS CPLS Learning Center in Logosoft Sarajevo, and as a lecturer and author of MOC courses. Occasionally, he also works as a system designer for complex enterprise environments. He is a founding member and president of Bosnian Microsoft Community. He has been working with Microsoft platforms for the last 17 years and he is particularly specialized in Windows Server, Exchange Server, mobility and virtualization. Microsoft awarded him with the Most Valuable Professional – MVP status for his outstanding contribution in sharing knowledge about Microsoft Server products, large number of lectures he delivered, and for his high technical competence. Damir owns several technical certificates (MCSE, MCTS, MCITP, and MCT) for Windows Server 2012, 2008 R2, Exchange Server 2010, Security and Hyper-V. He is regular presenter on conferences in ex-Yu region. On Microsoft Sinergija conference, for previous 7 years, each time he was graded as one of top three speakers. On a Bosnian MS conference, he is the best speaker for last two years. He is also a regular and highly graded presenter on other Microsoft conferences in region such as NT Conference (Slovenia), Microsoft Vizija (Macedonia), Microsoft Windays (Croatia), MS Technet, Mobility Day, KulenDayz etc. Damir is one of very few trainers in Europe who works as an author and reviewer of official MOC courses. In previous year, he was authoring courses 20417 (Upgrading Skills to Windows Server 2012), 20414 (Implementing an Advanced Server Infrastructure), 20412( Configuring Advanced Windows Server 2012 Services) and 20410 (Installing and Configuring Windows Server 2012). Also, he was authoring System Center 2012 courses and currently he is working on Exchange Server 2013 and Windows Server 2012 R2 courses. In addition, he has been working for 16 years now as one of the editors of BiH IT magazine INFO, where he published more than 300 technical articles, and he is also writing for the famous Windows ITPro Magazine (some of his work can be found at: http://windowsitpro.com/author/damir-dizdarevic).

Leave a Reply

Your email address will not be published.