{"id":4370,"date":"2020-10-07T08:47:45","date_gmt":"2020-10-07T06:47:45","guid":{"rendered":"https:\/\/www.msb365.blog\/?p=4370"},"modified":"2023-06-23T13:02:01","modified_gmt":"2023-06-23T11:02:01","slug":"easy-office-365-management-admindroid","status":"publish","type":"post","link":"https:\/\/www.msb365.blog\/?p=4370","title":{"rendered":"Easy Office 365 Management -AdminDroid"},"content":{"rendered":"<p>Cloud services from Microsoft, Amazon, Google and other service providers have been booming not only since the Corona crisis. Of course, the Corona crisis has given these technologies an exponential boost.<br \/>\nHowever, using these technologies is the one thing, one of the new challenges is to have our data, meta data, statistics and reports easily and visually accessible.<\/p>\n<p>I personally have been using the AdminDroid solution as my personal Microsoft Cloud Reporting Tool for over a year now.<\/p>\n<p>In the past weeks I have received many requests to create scripts for reporting and distribute them or publish them.<\/p>\n<p>I have now decided to do a short product review about AdminDroid. This is not because I get financial support, but because I really like to use this tool myself.<br \/>\nPlease note, the following lines are my own and not given by AdminDroid. But I have informed the people from AdminDroid that I want to write an article about it and got the green light.<\/p>\n<p>I hope I can help some of the visitors of this article to find the right solution for their needs.<\/p>\n<p>&nbsp;<\/p>\n<h3>What is Admin Droid?<\/h3>\n<p>AdminDroid is a product of the AdminDroid solutions startup company<br \/>\nAdminDroid offers a very simple and handy tool for reporting in the Microsoft world.<br \/>\nDepending on the license there are different versions. With the largest license, the Premium license, a lot can be done.<br \/>\nOn the one hand it is relatively easy to create reports in the following areas:<\/p>\n<ul>\n<li>Azure AD<\/li>\n<li>Security<\/li>\n<li>Exchange online<\/li>\n<li>OneDrive for Business<\/li>\n<li>SharePoint online<\/li>\n<li>Microsoft Teams<\/li>\n<li>Yammer<\/li>\n<li>Skype for Business<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>On the other hand, in-depth audit reports on the same areas as listed above and in addition to Power BI, Stream, etc.<\/p>\n<p>&nbsp;<\/p>\n<h3>How is Admin Droid used?<\/h3>\n<p>In this respect, I think it makes most sense to show the functionality with an example:<\/p>\n<p>In my example, let&#8217;s take a closer look at the Office 365 Security&#8230;<\/p>\n<p>&nbsp;<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/1.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-4373\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/1.png\" alt=\"\" width=\"1426\" height=\"907\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/1.png 1426w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/1-300x191.png 300w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/1-1024x651.png 1024w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/1-768x488.png 768w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/1-600x382.png 600w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/1-905x576.png 905w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/1-1320x840.png 1320w\" sizes=\"(max-width: 1426px) 100vw, 1426px\" \/><\/a><\/td>\n<td width=\"301\">After AdminDroid is installed and we have assigned the appropriate permissions, we can log in to the AdminDroid Portal via the desktop icon.<\/p>\n<p>In my Demo Tenant we see the dashboard shown here.<\/p>\n<p>Here we already have a first overview of our Tenant.<\/p>\n<p>In the next step, we click under <strong>Dashboards<\/strong> on <strong>Security<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/2.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4374\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/2.png\" alt=\"\" width=\"1361\" height=\"1131\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/2.png 1361w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/2-300x249.png 300w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/2-1024x851.png 1024w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/2-768x638.png 768w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/2-600x499.png 600w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/2-905x752.png 905w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/2-1320x1097.png 1320w\" sizes=\"(max-width: 1361px) 100vw, 1361px\" \/><\/a><\/td>\n<td width=\"301\">On this mask we see two main categories. One is the category MFA and the other is the category Password.<\/p>\n<p>In this Test Tenant we see immediately that there is one user where MFA is enabled and 5 other admin accounts where MFA is not active.<\/p>\n<p>Also we see immediately which M365 roles are assigned to these 5 &#8220;badly protected&#8221; administrators without MFA.<\/p>\n<p>In the same mask we can see that there are 90 users and how many of them use MFA.<\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/3.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4375\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/3.png\" alt=\"\" width=\"602\" height=\"798\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/3.png 602w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/3-226x300.png 226w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/3-600x795.png 600w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><\/td>\n<td width=\"301\">If we then move our mouse over one of the fields, we can see immediately which authorization it is and how many users have this authorization without the MFA being activated.<\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4376\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4.png\" alt=\"\" width=\"2518\" height=\"300\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4.png 2518w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4-300x36.png 300w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4-1024x122.png 1024w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4-768x92.png 768w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4-600x71.png 600w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4-1536x183.png 1536w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4-2048x244.png 2048w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4-1600x191.png 1600w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4-905x108.png 905w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/4-1320x157.png 1320w\" sizes=\"(max-width: 2518px) 100vw, 2518px\" \/><\/a><\/td>\n<td width=\"301\">If we need more information, we simply click on the appropriate field and immediately get the report which users are involved. This includes the Display Name, UPN, MFA Status, Admin Roles, Department, Mail, License Status, Password Status, Signin Status and User added time.<\/p>\n<p>In addition, we also have search fields where we can extend or limit our request.<\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4377\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/5.png\" alt=\"\" width=\"736\" height=\"956\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/5.png 736w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/5-231x300.png 231w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/5-600x779.png 600w\" sizes=\"(max-width: 736px) 100vw, 736px\" \/><\/a><\/td>\n<td width=\"301\">By clicking on a user, we can access all available information about that user.<\/p>\n<p>This way we can easily find out how many and which users are MFA enabled and which are not.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Of course there are countless other possible applications.<\/p>\n<p>However, let&#8217;s now look at another example, this time on the subject of audit reporting. To be a little more precise, let&#8217;s look at the Exchange online section to see which user, which mailbox, and when accessed.<br \/>\nHere is an example:<\/p>\n<p>&nbsp;<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/000.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4383\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/000.png\" alt=\"\" width=\"802\" height=\"868\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/000.png 802w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/000-277x300.png 277w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/000-768x831.png 768w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/000-600x649.png 600w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/a><\/td>\n<td width=\"301\">We start again on our Main <strong>Dashboard<\/strong>. But this time we go to the category <strong>Exchange<\/strong> in <strong>Audit Reports<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4380\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/6.png\" alt=\"\" width=\"321\" height=\"741\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/6.png 321w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/6-130x300.png 130w\" sizes=\"(max-width: 321px) 100vw, 321px\" \/><\/a><\/td>\n<td width=\"301\">Now we get another selection of options which we can audit.<\/p>\n<p>For our example we choose the option <strong>Mailbox Non-Owner Access<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4381\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7.png\" alt=\"\" width=\"2073\" height=\"914\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7.png 2073w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7-300x132.png 300w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7-1024x451.png 1024w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7-768x339.png 768w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7-600x265.png 600w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7-1536x677.png 1536w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7-2048x903.png 2048w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7-1600x705.png 1600w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7-905x399.png 905w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/7-1320x582.png 1320w\" sizes=\"(max-width: 2073px) 100vw, 2073px\" \/><\/a><\/td>\n<td width=\"301\">Here we can see at a glance which user had access to which mailbox and when. In addition, the client IP address and what exactly this user has done in the mailbox is also displayed.<\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4382\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/8.png\" alt=\"\" width=\"681\" height=\"861\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/8.png 681w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/8-237x300.png 237w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/8-600x759.png 600w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><\/a><\/td>\n<td width=\"301\">Similar to our last example, we can simply click on an event to see more details.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>AdminDroid offers such and many more reports for the different product groups of Microsoft.<br \/>\nI can&#8217;t and don&#8217;t want to list them all here because it would go beyond the scope of this article.<\/p>\n<p>But I can basically recommend it to everyone to test AdminDroid on their own. Admin Droid is available in a trail version with all features for 2 weeks.<\/p>\n<p>Here is also a <a href=\"https:\/\/admindroid.com\/features\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>link<\/strong> <\/a>to the feature list.<\/p>\n<p>&nbsp;<\/p>\n<h3>Administration AdminDroid<\/h3>\n<p>AdminDroid is since the version 4.0.0.0 multi-client capable as well, it also has its own admin management. To add another admin from your own organization, go to <strong>Settings<\/strong> &gt; <strong>Admins<\/strong> and click on <strong>Add Administrator<\/strong>.<\/p>\n<p><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4384\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9.png\" alt=\"\" width=\"2535\" height=\"788\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9.png 2535w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9-300x93.png 300w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9-1024x318.png 1024w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9-768x239.png 768w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9-600x187.png 600w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9-1536x477.png 1536w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9-2048x637.png 2048w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9-1600x497.png 1600w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9-905x281.png 905w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/10\/9-1320x410.png 1320w\" sizes=\"(max-width: 2535px) 100vw, 2535px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Here we select a user and promote him to the admin.<\/p>\n<p>&nbsp;<\/p>\n<h3>What else must be considered?<\/h3>\n<p>From my point of view there are the following points to consider:<\/p>\n<ul>\n<li>The client capable to multiple Tenants is supported since the version 4.0.0.0<\/li>\n<li>Unfortunately there is no interface to known monitoring tools like PRTG or similar available for reporting. I have already been in contact with the guys from AdminDroid in this regard and I hope that this will come in the near future.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3>Summary &#8211; Why should you Choose Admin Droid?<\/h3>\n<p>As I said at the beginning, I use Admin Droid where I can, it helps with almost all topics in the Microsoft Cloud.<\/p>\n<p>In addition I would like to emphasize the following key points:<\/p>\n<ul>\n<li>Rich Reporting Features\n<ul>\n<li>Advanced reporting capabilities such as scheduling, export, customizable reports, advanced filters, etc.<\/li>\n<\/ul>\n<\/li>\n<li>One Tool to Rule\n<ul>\n<li>A single tool to manage your entire Office 365 infrastructure.<\/li>\n<\/ul>\n<\/li>\n<li>User-friendly\n<ul>\n<li>Do complex tasks with few mouse clicks using a simple to use web-based interface.<\/li>\n<\/ul>\n<\/li>\n<li>Non-admin Delegation\n<ul>\n<li>Allow non-admins to view reports and statistics.<\/li>\n<\/ul>\n<\/li>\n<li>Easy setup\n<ul>\n<li>Easy to set up. No prerequisites to install. No maintenance as the product will automatically update to latest version.<\/li>\n<\/ul>\n<\/li>\n<li>No Maintenance\n<ul>\n<li>The inbuilt auto-updating mechanism ensures always the product is up-to-date with security standards and latest features.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Photo by <a href=\"https:\/\/unsplash.com\/@maximilianweisbecker?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText\">Maximilian Weisbecker<\/a> on <a href=\"https:\/\/unsplash.com\/s\/photos\/nautical?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText\">Unsplash<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cloud services from Microsoft, Amazon, Google and other service providers have been booming not only since the Corona crisis. Of course, the Corona crisis has given these technologies an exponential boost. However, using these technologies is the one thing, one of the new challenges is to have our data, meta data, statistics and reports easily [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4371,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[685,1923,2,15,51,1989],"tags":[],"class_list":["post-4370","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-active-directory","category-microsoft-365","category-exchange","category-ms-teams","category-productreview","category-sponsored"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts\/4370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4370"}],"version-history":[{"count":7,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts\/4370\/revisions"}],"predecessor-version":[{"id":4840,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts\/4370\/revisions\/4840"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/media\/4371"}],"wp:attachment":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}