Book Image

Microsoft Office 365 Administration Cookbook

By : Nate Chamberlain
Book Image

Microsoft Office 365 Administration Cookbook

By: Nate Chamberlain

Overview of this book

Organizations across the world have switched to Office 365 to boost workplace productivity. However, to maximize investment in Office 365, you need to know how to efficiently administer Office 365 solutions. Microsoft Office 365 Administration Cookbook is packed with recipes to guide you through common and not-so-common administrative tasks throughout Office 365. Whether you’re administering a single app such as SharePoint or organization-wide Security & Compliance across Office 365, this cookbook offers a variety of recipes that you’ll want to have to hand. The book begins by covering essential setup and administration tasks. You’ll learn how to manage permissions for users and user groups along with automating routine admin tasks using PowerShell. You’ll then progress through to managing core Office 365 services such as Exchange Online, OneDrive, SharePoint Online, and Azure Active Directory (AD). This book also features recipes that’ll help you to manage newer services such as Microsoft Search, Power Platform, and Microsoft Teams. In the final chapters, you’ll delve into monitoring, reporting, and securing your Office 365 services. By the end of this book, you’ll have learned about managing individual Office 365 services along with monitoring, securing, and optimizing your entire Office 365 deployment efficiently.
Table of Contents (16 chapters)
Chapter 14: Appendix – Office 365 Subscriptions and Licenses

Exporting users

As a tenant admin, you will be asked for reports and information about the users in your tenant. One of the basic requests is around the number of users. A basic user export provides all this information and much more. In this recipe, we'll obtain that from the Microsoft 365 Admin Center.

Getting ready

The user creating the account must be an admin with the appropriate role (such as Global Admin, User Admin, and so on).

How to do it…

  1. Go to the Microsoft 365 Admin Center at
  2. Select Users > Active users.
  3. Click Export Users:
    Figure 2.13 – The Export Users button in the Active users top menu

    Figure 2.13 – The Export Users button in the Active users top menu

  4. A dialog box will appear—click Continue or No.
  5. A CSV file that provides several columns of information on each user will download to your PC.

How it works…

You used the Export Users button to pull down a CSV report of active users that can be sorted, filtered, or shared.