How to filter and list Azure AD users

Obtaining a list of all users from a tenant based on filter conditions like “country” or “department” is a common task for an Office 365 administrator. While the M365 admin center or Azure Portal can provide a list of all users, they currently lack the feature to apply filters based on specific requirements.

For example, if you need a list of all users belonging to the HR department, the current process requires exporting all users to an Excel sheet and applying a filter on the “Department” column. This can become quite laborious, especially when dealing with a large number of users.

This article will guide you on how to retrieve users based on specific filter conditions using PowerShell and CoreView.

1. Using PowerShell

Before you can use Azure AD cmdlets below, you first need to install and import Azure AD modules. For more information, please refer to the Connect with Azure AD guide.

Install-Module AzureAD
Import-Module AzureAD
Connect-AzureAD

After you've successfully connected with Azure AD, you can use different cmdlets to find Azure AD users based on specific filter conditions.

Examples:

Get-AzureADUser
# Displays full list of User accounts

Get-AzureADUser -Filter "startswith(JobTitle,'Sales')"
# This command gets all the users whose job title starts with sales e.g Sales Manager and Sales Assistant.

Get-AzureADUser -Filter "Department eq 'HR'"
# This command gets all the users whose Department is HR

Get-AzureADUser -Filter "Country eq 'India'"
# This command gets all the users whose country equals to India

Although this is helpful in most scenarios it has certain restrictions when applying the filter conditions on certain properties. For example we cannot use same script to get all the users of a particular domain or users of particular licensed assigned.

2. Using CoreView

With CoreView, you can filter your user list using many different parameters. Let's see the steps to achieve this.

• Log in to the CoreView portal
• Select “Reports > Users > Active users”. This will display all the users available in the tenant.

• Next, open the “Columns” dropdown and pick all the columns you want to get information from. You'll use this information later when you set up the filter condition.

• Click “Apply”. This action will load the user report, showing all the columns you selected.
• Now, you can set up a filter based on what you need. For example, if you want to see all the users from a specific domain, just use “Domain contains [domain name]”. You can also use “Domain equals [domain name]”. This will show all the users from that domain.

Pivot charts

If you prefer to view your filtered data in an aggregator format instead of a table, just enable the “Pivot mode” toggle located in the top left corner. For further information, please visit this article: Pivot mode in reports.