As part of creating or modifying a discovery pattern, you can use the Union table operation to append two tables of the same format.

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

Appending two tables adds the second table at the end of the first table and places the results in the additional, target table. If necessary, you can specify one of the source tables as the target table.

Procedure

  1. Select Union Tables from the Operation list.
  2. Fill in the fields, as appropriate.
    Field Description
    First table Specify the name of the first source table.
    Second table Specify the name of the second source table.
    Target table Specify the name of the table into which the results are placed.
  3. 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 inThis item
Hierarchy Applications > Application Servers
CI Type WebSphere EAR
Pattern J2EE EAR on Linux
Section Oracle JDBC connectivity
Step number and Name 5. Union JDBCProviders with JDBCProviders2

A WebSphere EAR on Linux has two tables containing data on JDBC Providers. To add data from the second table at the bottom of the first table, use the Union Tables operation as follows:


Defining Union Tables 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.