As part of creating or modifying a discovery pattern, you can use the Merge Table operation to merge content from two source tables into a target table.

Before you begin

Role required: pd_admin

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 Add a step button to add a step.

Basic knowledge of programming is desirable.

About this task

Use this operation to unify information from different sources.

For example, during discovery of connections of IBM WebSphere Portal to IBM WebSphere MQ, you can merge the table containing queue names with the table containing JNDI reference names.

Procedure

  1. Select Merge Table from the Operation list.
  2. Fill in the fields, as appropriate.
    FieldDescription
    First table Specify the name of the first source table.
    Second table Specify the name of the second source table.
    Target table To create a table to contain merged data, define the name of the new table.

    To add information from one source table into another, specify the name of the source table to contain merged data.
    Unmatched values For tables that meet the merge criteria, select an action from the list for unmatched rows:
    • Keep: If merge criteria is met for any row, it merges all rows from both source tables into the target table.
    • Remove: Merges only matching rows from both source tables into the target table, and excludes non-matching rows.
  3. To merge tables based on one matching field value:
    1. Click Field matching.
    2. In the First Table Field, enter the value from the first source table.
    3. In the Second Table Field, enter the value from the second source table.
  4. To merge tables based on multiple matching field values:
    1. Click Condition.
    2. In the first condition field, enter the required value.
      For example, enter the actual string or a variable name.

      You can use variables including values from tabular variables as described in Enter values and variables in patterns.


      Define precondition criteria.
    3. Select an operator from the list.
    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.
  5. If in Debug mode, test the step by clicking Test and checking that the operation brings the result you expected.

Example

To merge tables containing queue names with JNDI reference names, use the Merge Table operation as follows:
Defining Merge Table operation

What to do next

cmdb-key-value
Discovery also collects cloud tags that are specific to each virtual machine (VM) and saves them to the Key Value [cmdb_key_value] table.