Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Filter a table

Filter a table

As part of creating or modifying a discovery pattern, you can use the Filter table operation to search a source table for a specified value. If found, values are logged in a specified target table.

Before you begin

Navigate to the relevant pattern step:

  1. On the pattern form, select the relevant identification section for Discovery.

    Alternatively, select the relevant identification or connection section for Service Mapping.

  2. Select the relevant pattern step or click to add a step.

Basic knowledge of programming is desirable.

Role required: pd_admin

Procedure

  1. Select Filter Table from the Operation list.
  2. Fill in the fields, as appropriate:
    Field Description
    Source table Name of source table to be searched.

    Use drag-and-drop or auto-complete to copy table names, fields, and values from the Temporary Variables and CI Attributes tables.

    Target table Name of target table to contain the values that were found.
    Note: If the specified target table is already populated, the new fields and values from the source table overwrite the existing fields and values of the target table.
  3. Define the condition for this operation:
    1. In the first condition field, enter the required value.
      For example, the table name and the column from which to retrieve the values.

      Defining conditions
      You can also use variables including values from tabular variables as described in Enter values and variables in patterns.
    2. Select an operator from the list.
    3. Enter the string that Pattern Designer uses to filter values.
    4. To add more conditions, click the plus icon and define the criteria.
    5. If you create multiple conditions, define if this pattern must meet all or any of them: From the Meet list, select All or Any.
  4. If in Debug mode, test the step by clicking Test and checking that the operation brings the result you expected.

Example

This operation is used in This item
Hierarchy Applications > Application Servers
CI Type WebSphere Portal [cmdb_ci_appl_websphere_portal]
Pattern Websphere Portal On Linux
Section DB2 JDBC connectivity
Step number and Name 8. Prepare different lists of connections per db type

To identify IBM WebSphere connections to Oracle applications, use the Filter Table operation as follows:


Example of using Filter Table operation

What to do next