# Users

### Overview

The Users page provides high level information on all the user identities in your environment, along with several filters and sortable columns, so that you can better understand, analyze and share user population data based on a variety of useful parameters. By default, the table on the Users page is sorted by User Name, and excludes user accounts that have been deleted, deprovisioned, or disabled.&#x20;

<div align="center"><figure><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2FFCI2E0tv0OGwhkPKrkZp%2Fimage.png?alt=media&#x26;token=a369002a-9aa2-4021-a3cb-49ccbdab4d6e" alt=""><figcaption></figcaption></figure></div>

This section covers:

* [Definitions of the elements in the table](#user-list-elements)
* [Users page actions](#users-tab-general-actions) such as searching, exporting results, etc
* [Basic Filters](#apply-basic-filters) and [Advanced Query Mode](https://docs.oort.io/understanding-your-users/users/advanced-query-mode)
* [Pivoting on IP address](#pivot-on-ip-address)

### Users table elements&#x20;

The section below details the fields that appear in the table by default, as well as the definition of each field:

<table><thead><tr><th width="168">Element</th><th>Description</th></tr></thead><tbody><tr><td>User</td><td>The user's display name and their corresponding email or username</td></tr><tr><td>Trust Level</td><td>The user's current <a href="../user-trust-level">Trust Level </a></td></tr><tr><td>Checks</td><td>The total number of <a href="../understanding-check-failures/oort-insights">checks</a> a user is failing. <br><br>A  🚫  icon in this column indicates that the corresponding user is not part of the protected population and checks are not being evaluated against this user</td></tr><tr><td># IPs</td><td>The total number of IP addresses associated with a user's activity across all providers</td></tr><tr><td># Logins</td><td>The total number of attempted logins across all providers, regardless of result (success, failure, challenge, other) </td></tr><tr><td>Last Seen (UTC) </td><td>The date and time of the last login attempt, regardless of outcome, for a user across all providers</td></tr><tr><td>Last IP Address</td><td>The IP address associated with the last successful <strong>or</strong> failed login attempt for a user across all providers <br><br><a href="#pivot-on-ip-address">Read more below</a> about how to pivot on the last IP address</td></tr><tr><td>Last Location</td><td>The location associated with the last successful <strong>or</strong> failed login attempt for a user across all providers</td></tr><tr><td>MFA</td><td><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2F9oqUvRc8ybDyn474Pqm5%2Fimage.png?alt=media&#x26;token=824c6f75-7d6f-404a-98d8-a1a62be460cb" alt="">= MFA configured<br><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2FSE5Eb3CTv8xSvwaR66nK%2Fimage.png?alt=media&#x26;token=2194ab96-f48b-4bf8-9994-b6ca7521db7c" alt="">= MFA not configured</td></tr><tr><td>Providers</td><td><p>The logo icon(s) for the corresponding identity data sources where a user's account has been associated <br><br>Hovering over a source will show you the integration name and user's status as gathered from the identity data source</p><p><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2Fg6zFAc2a6Uc0s6WPxB9f%2Fimage.png?alt=media&#x26;token=8827a702-85e7-4803-b8ca-ac809616ffdb" alt="" data-size="original"></p></td></tr><tr><td>Status</td><td>The user's <a href="user-statuses">Identity Intelligence Status</a> and Lifecycle Event tag, if applicable. Lifecycle events highlight recent, notable events that have occurred on a user's account that can be beneficial to know about during an investigation. Lifecycle event badges are displayed for 7 days after the event is noted<br><br><strong>Status</strong><br>- <strong>Active</strong> (green badge): This account is enabled in an identity data source and has successfully logged in over the last X days. The number of days is consistent with the value set on the Inactive Users and Inactive Guest Users checks (default setting is 30 days)<br>- <strong>Inactive</strong> (Grey badge): This account is enabled in an identity data source, but has not successfully logged in over the last X days. The number of days is consistent with the value set on the Inactive Users and Inactive Guest Users checks. (default setting is 30 days)<br>- <strong>Deprovisioned</strong> (Grey badge): This account is no longer enabled in an identity data source and cannot be signed into<br>- <strong>Inconsistent</strong> (red badge): This account has been flagged because there are account status discrepancies that may pose a significant security threat. See <mark style="color:red;">Inconsistent Users</mark> to learn about what factors contribute to a user being marked as inconsistent <br><br><strong>Lifecycle Events (yellow badge)</strong><br><strong>- New Account:</strong> indicates that this account was recently created. Includes the date the account was created <br><strong>Significant Change:</strong> indicates that an uncommon, but important, activity has recently happened on this account (for ex: MFA factor added, admin privileges granted, sensitive app assigned, etc). You can query for specific Significant change events using <a href="users/advanced-query-mode">Advanced Query </a>mode </td></tr><tr><td>Compiled Status</td><td>Compiled status combines provider user types (ie: internal, external, service accounts, etc) and the user's <a href="user-statuses">Identity Intelligence Status</a></td></tr></tbody></table>

&#x20;Additional columns can be added to the table view using the **Columns** button:

<table><thead><tr><th width="161">Element</th><th>Description</th></tr></thead><tbody><tr><td>Created Date (UTC)</td><td>The date a user's account was created. Uses the first creation date available across all configured providers</td></tr><tr><td>Employee ID</td><td>The employee ID, gathered from the provider if available</td></tr><tr><td>Manager Login</td><td>The user's manager's email address, gathered from the provider if  available</td></tr><tr><td>Title</td><td>The user's job title, gathered from the provider(s) if available</td></tr><tr><td>Department</td><td>The department a user belongs to, gathered from the provider(s) if available</td></tr><tr><td>Registered Location</td><td>The location a user is supposed to be working from based on hiring agreements, if available from the HRIS or the IdP. If the user has multiple registered locations that differ, the HRIS data always takes precedence. If HR information is not available for a user, then the data comes from the IdP </td></tr><tr><td>Inconsistency Severity</td><td>The severity of the inconsistency noted for a user with <a href="../user-statuses#inconsistent-users">Inconsistent</a> status</td></tr><tr><td>User Type</td><td>The Identity Intelligence user type assigned based on compiled identity data source user types </td></tr></tbody></table>

### Users page general actions&#x20;

There are several general actions that can be performed on the Users page:

* Search
* Sort, add or remove columns
* Download results
* Share results&#x20;
* Refresh

Navigate through the tabs below to read more about how to utilize each action.&#x20;

{% tabs %}
{% tab title="Search" %}

#### **Search**

Use the search bar to search based on users, names, group, applications and IPs. When searching, you do not need to provide an exact value. Typing a piece of the word will return results.&#x20;

If you have searched on a particular parameter, the search criteria is retained as you navigate between different tabs within the platform. &#x20;

To clear the search bar, select the **X** on the right most side of the search bar, next to the **Advanced** button.&#x20;
{% endtab %}

{% tab title="Sort Columns" %}
**Sort Columns**

Sort columns within the table by selecting the column header you'd like to sort by. Select once to sort in ascending order, select again to sort in descending order.&#x20;

Multi-column sorting is **not** currently supported.&#x20;
{% endtab %}

{% tab title="Add/remove columns" %}

#### **Add or remove columns**

Columns can be added or removed from the table using the **Columns** button in the top right of the table, above the column headers. Select this button to choose the columns you'd like to display in the UI. \
To return to the default settings, select **Restore Default** at the bottom of the list when you open the **Columns** button.&#x20;

<figure><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2FSvNps4ZgMwycQ4GS7f8E%2Fimage.png?alt=media&#x26;token=95dc2dcc-ad64-4e71-b30f-d624ec9cb168" alt=""><figcaption></figcaption></figure>

The Download feature (next tab) respects the visible columns.&#x20;
{% endtab %}

{% tab title="Download results" %}
**Download results**

You can download tabular data from the table to a CSV using the **Download** icon button on the right after the search bar. All columns displayed and filters applied are included in the CSV output.&#x20;

If there are no results in the table, the CSV export will contain only headers and no user data\
\
Note: The CSV download has a limit of 2,000 rows. If you need to download more than 2,000 rows, select the download button and follow the prompts to get the export sent via a download link.&#x20;

<figure><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2FjJdE9xB0EQNrRe80B0oC%2Fimage.png?alt=media&#x26;token=91ffc96c-2656-4cae-9ecc-9b81bc0e2772" alt="" width="77"><figcaption></figcaption></figure>
{% endtab %}

{% tab title="Share URL" %}
**Share URL**

The **Share** button (on the right side of the Search bar) copies a link to this page, with the applied filters and selected columns, that can be easily pasted, bookmarked or shared with anyone who has the appropriate access to your Identity Intelligence tenant

<figure><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2Fz7hHsVCBzsn5hRwwCwlN%2Fimage.png?alt=media&#x26;token=16340c7b-4595-4a3b-922e-6316d7dc0f28" alt="" width="68"><figcaption></figcaption></figure>
{% endtab %}

{% tab title="Refresh" %}
**Refresh**

Use the **Refresh** button on the right side of the search bar to refresh user data and filter counts in the table after making changes (ex: linking users, excluding a user from a check).&#x20;

&#x20;<img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2FFhEpPcaLr98dh711g450%2Fimage.png?alt=media&#x26;token=3d067e67-44d1-4457-a18c-6c392d9e04d4" alt="" data-size="original">
{% endtab %}
{% endtabs %}

### Filters&#x20;

The Users table is filterable by a number of attributes, enabling you to slice and dice your user population based on the parameters that are important to you.&#x20;

There are two types of filters that can be used on the Users table - [basic filters](#applying-basic-filters), which can be found to the left of the Users table and [Advanced Query mode](https://docs.oort.io/understanding-your-users/users/advanced-query-mode), which can be enabled via the search bar above the users table. Check out our documentation on to [how to use Advanced Query Mode](https://docs.oort.io/understanding-your-users/advanced-query-mode#entering-advanced-mode-and-adding-filters) to learn more.

Filtered results derived from both basic filters, as well as advanced queries, can be saved to access later or share with teammates. To learn more about how to save filters, see [Saved Filters](https://docs.oort.io/understanding-your-users/users/saved-filters) to learn more.&#x20;

#### Applying basic filters

You can see all the available basic filters on the left hand side of the Users page.&#x20;

To enable a filter, select the check box for the attribute you would like to filter by. The applied filters will be added to the search bar, as seen in the screenshot below. The number of users that you are currently viewing, based on the filters and searches used, will appear in the top left corner of the Users table above the column headers.

To remove a filter, you can either deselect the attribute from the filters list on left hand side of the Users table, or select the **X** on the right hand side of the filter box that is in the search bar. To remove all filters besides the default filter, select the **X** located next to the **Advanced** Filter button in the search bar.&#x20;

After you have selected your filters, the filters are retained as you navigate between different areas within the platform. &#x20;

<figure><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2FLWiZi0uwwhc8Vxw2pcQn%2Fimage.png?alt=media&#x26;token=272f6b2d-84a4-40bb-88a3-b53059da8b4b" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
By default, the Users Table excludes user accounts that have been deleted, deprovisioned, or disabled. To include these accounts in the results, select the **X** on the right side of the 'NOT Status' filter box in the search bar.&#x20;
{% endhint %}

Distinct filters are separated by an **AND** operator. For example, if you select the `Duo` value from the `Sources` filter and the `No` value for `MFA Configured` filter, the table will display all users in `Duo` who have `No MFA Configured`.

For most filters, you can select more than one value to filter by. Within a given filter, selecting more than one value will separate the values with an **OR** operator by default. For example, if you select the values `Okta` and `Duo` for the `Sources` filter, users with accounts in **either** `Okta` **OR** `Duo` will be displayed.&#x20;

However, within a given filter, if you would like to filter for users with accounts in both `Okta` **AND** `Duo`, you can select the **OR** operator found in the filter box in the search bar or in the left hand filter menu (screenshots below), to switch it to **AND**. Doing this will allow you to see users that are in both `Okta` **AND** `Duo`.

Filters that use radio buttons cannot have more than one value selected at once (for ex: `Is Admin`)

<figure><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2FcnViOGqd1PlHF0oRGJPq%2FScreenshot%202025-06-06%20at%204.57.45%E2%80%AFPM.png?alt=media&#x26;token=b28881c3-2a1a-447a-8929-f46591975e18" alt=""><figcaption></figcaption></figure>

Specific values can also be excluded from the results for most filters, except for those that cannot have more than one value selected at once. To exclude a value from filtered results (ie: `NOT`), you can select the 🚫 icon in either the filter box in the search bar or the left hand filter menu.

<figure><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2Fjmo8Tm9XwDKmtLBt7aym%2Fimage.png?alt=media&#x26;token=f947d7da-07b0-4d5b-beb4-1fb6c02ef2ec" alt=""><figcaption></figcaption></figure>

Similarly, you can 'include all' filter values in the results, except for filters that cannot have more than one value selected at once. To select all values within a given filter, select `All` next to the filter value title.

<figure><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2FgAaHh2FU5kpK6ySYkmLX%2FScreenshot%202024-08-29%20at%205.22.39%E2%80%AFPM.png?alt=media&#x26;token=e64c2543-d1f0-476d-add5-122fd0636040" alt=""><figcaption></figcaption></figure>

### **Pivot on IP address**

The IP address in the table has a few actions associated with it that can be useful to learn more about an IP address and the associated activity.&#x20;

The actions menu will pop up when left-clicking on a specific IP address in a user row.  The actions are:

* **Find user activity -** Takes you to the [Activity](https://docs.oort.io/understanding-your-users/user-360/activity-tab) tab of the User 360 for the respective user, with the selected IP address added as a filter, so you can see all the user's activity associated with this particular IP address&#x20;
* **Find users who attempted to sign in from X.X.X.X -** Adds the selected IP address as a search parameter on the [Users](https://docs.oort.io/understanding-your-users/users) page so you can see any other users who have activity associated with this particular IP address
* **See IP info -** Takes you to the [Networks](https://docs.oort.io/how-to-guides/networks-tab-and-user-investigations) tab of the User 360 for the respective user, with the selected IP address added as a filter, and opens the slide panel so you can see more detailed information about that IP address for this user
* **Copy to clipboard -** Copies the IP address to your clipboard so that you can paste it within Identity Intelligence or another tool&#x20;

<figure><img src="https://582105988-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqPSBzsjxd7KYg9DNVZ4l%2Fuploads%2FdfZGWpHAXJxG1R9JDGte%2Fimage.png?alt=media&#x26;token=ad3a980d-7e44-4e41-97bd-a2fc2d67723a" alt=""><figcaption></figcaption></figure>
