Skip to main content

Context ManagementContext Management Administration Guide

Working with Filtered Context Tables

A filtered context table allows you to create a single table that incorporates data from one or more source context tables. You can filter the data in the new table by defining conditions for the connected source tables. In this way, you can create smaller tables which can be leveraged in downstream processes to focus on specific subsets of your data. If data in the source context tables is updated, data in the filtered context table is also updated.

Note

Example: You have two Active Directory context tables processing user data and you want to find all of the events that were performed by VPN users. You can create a filtered context table with both Active Directory context tables as its source. The new context table aggregates the users from both Active Directories into a single table. You can then configure a condition on the new table to filter for VPN users only. The new filtered context table can then be used in downstream products like Search, Correlation Rules, and Dashboards.

When creating a filtered context table, the data from the connected sources is merged together using intersectional logic. The new context table can have only one key attribute, so if there is a difference in keys between the connected sources, the key is assigned based on the first source context table added.

To create a filtered context table, follow the procedure to Create a Custom Context Table Using the Add Custom Option. When you reach Step 11 in the procedure, follow the steps below to define the filter conditions you want to use to extract data from the connected source tables. You can add conditions in one group or in multiple groups, depending on the complexity required.

To define filter conditions:

  1. Click Attribute and select a field attribute you want to use as a filter.

  2. Click Operator and select whether you want to filter on data that Equals or Contains a specific value, or equals but is not case sensitive.

  3. Click Value and enter the value a field should equal or contain in order to be displayed in the new table.

    Example:

    attribute-first.png
  4. If you want to define another condition, click AND or OR, depending on how you want the next condition to be related to the first condition. Select an Attribute, Operator, and Value for the new condition.

  5. You can continue adding conditions to the group. But if you started adding conditions with an OR relationship, each condition within the group must be an OR condition.

    Example:

    attribute-group.png
  6. If you need a filter condition with a different logical relationship, you will need to start a new group. Click the AND or OR option below the first group of conditions. A new group is added to the filter conditions.

    Example:

    attribute-group-next.png
  7. Select an Attribute, Operator, and Value for a new condition in the new group.

    Example:

    attribute-group-all.png
  8. Continue adding conditions to the new group or add additional groups as needed. When you have defined all the necessary conditions, return to Create a Custom Context Table Using the Add Custom Option and continue with Step 12 .