Add a column to a table - Product Documentation: Vancouver

Add a column to a table

IT Operations Management > <a class="link" href="../../../product/it-operations-management/reference/itom-visibility-landing-page.html" title="The ServiceNow ITOM Visibility product consists of ServiceNow Discovery, ServiceNow Service Mapping, Certificate Inventory and Management, Service Graph Connectors, CMDB 360, and Firewall Audits and Reporting. Discovery and Service Mapping give you a unified, connected view of your entire IT network and the services that it supports.">ITOM Visibility > Discovery patterns used by ITOM Visibility >

Add a column to a table

As part of creating or modifying a discovery pattern, you can use the Transform table operation to add one or more computed columns to an existing table and place the results in a target table. The target table can be the source table.

Role required: pd_admin

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.

Select Transform table from the Operation . Fill in the fields, as appropriate. Field Description Source table Specify the name of the source table. Target table Specify the name of the target table. The target table can be the same as the source table.

Click the plus icon to add each target field and fill in the fields, as appropriate. Field Description Target Field Name Specify a name for the column. It can be an existing column or a new one. Value Specify the operation expression that determines the values added to the column. You can use variables including values from tabular variables as described in Enter values and variables in patterns .

If in Debug mode, test the step by clicking Test and checking that the operation brings the result you expected.

The Transform Table operation is used to identify the Integration Feature Pack.

This operation is used in This item Hierarchy Applications > Web Servers CI Type Load Balancer Service [cmdb_ci_lb_service] Pattern F5 BigIP LTM Section Identification for all entry point types Step number and Name 9. Fix ip

For F5 load balancer, you want to translate IP addresses in the default hexadecimal format into decimal format. You use the Javascript that performs this translation in the value field. You add the "clean_ip" column containing IP addresses in decimal format to the existing (source) table.

Figure 1. Transform Table operation values

Continue editing the pattern by adding a new step and defining its operation or Finalize the pattern . 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.

Parent Topic: Create or customize patterns

Related tasks Append two tables