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: On the pattern form, select the relevant identification section for Discovery.Alternatively, select the relevant identification or connection section for Service Mapping. Select the relevant pattern step or click to add a step. Basic knowledge of programming is desirable. Role required: pd_admin Procedure Select Filter Table from the Operation list. 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. Define the condition for this operation: In the first condition field, enter the required value. For example, the table name and the column from which to retrieve the values. You can also use variables including values from tabular variables as described in Enter values and variables in patterns. Select an operator from the list. Enter the string that Pattern Designer uses to filter values. To add more conditions, click the plus icon and define the criteria. If you create multiple conditions, define if this pattern must meet all or any of them: From the Meet list, select All or Any. 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: What to do next Continue editing the pattern by adding a new step and defining its operation or Finalize the pattern.