Label and Tag Synchronization for Department in GCP

GCP

All

Setting

Type

Additional Notes

For Label Synchronization

Enable Label Synchronizatiion

Slider

If enabled, CI Sync will use the subsequent Connection Settings (in the rows below) to read the relevant Label from GCP and persist the value into ServiceNow as follows:

1. The value will be persisted to a discrete attribute on each CI.

2. The value (and it’s associated Label Name) will be persisted into the cmdb_key_value table (i.e. an entry will be created in cmdb_key_value for each Label and it’s raw value).

Customers need to enable and configure one or more of the subsequent Connections (described in the rows below) after enabling this setting,

For Tag Synchronization

Enable Tag Synchronizatiion

Slider

If enabled, CI Sync will use the subsequent Connection Settings (in the rows below) to read the relevant Tag from GCP and persist the value into ServiceNow as follows:

1. The value will be persisted to a discrete attribute on each CI.

2. The value (and it’s associated Tag Name) will be persisted into the cmdb_key_value table (i.e. an entry will be created in cmdb_key_value for each Tag and it’s raw value).

Customers need to enable and configure one or more of the subsequent Connections (described in the rows below) after enabling this setting,

The following settings can then be used for either/both Label and Tag Synchronization

Prioritize Tags vs Labels

Choicelist

Select one of the available choicelist items to control the behaviour when both Tags and Labels are being used for the same destination attribute in ServiceNow (e.g. an “Department” Tag and an “Department” Label both exists and CI Sync will be persisting both into the cmdb_ci.department attribute).

See below for the available choices.

1. Prefer Label over Tag

   1. CI Sync will use values from Labels in preference to values from Tags.

2. Prefer Tag over Label

   1. CI Sync will use values from Tags in preference to values from Lables.

Enable for Department

Slider

If enabled, the defined Labels or Tags will be synchronized to the discrete department field against each CI in the CMDB.

When enabled, the Department Label RegEx field will be exposed (see below).

Department [Label | Tag] RegEx

RegEx

Enter a Regular Expression that matches one or more Label or Tag names in GCP (i.e. one or more Labels or Tags that represent the Department associated with the GCP resource).

Example RegEx

/^Department$|^Department Unit$|^DepartmentLabel$/

RegEx Explained

This RegEx will identify Labels and Tags named “Department”, “Department Unit” or “DepartmentLabel” (i.e. three variations) and sync’d the associated values into ServiceNow.

Sync Behaviour and ServiceNow Data Explained

1. If there are multiple Labels or Tags that match the defined regEx for a field, the value within each Label or Tag will be searched against the ServiceNow cmn_department table with the first matching value returned.

2. If there are multiple values within a given Label or Tag (including multiple Labels or Tags), either comma or semi-colon separated, the individual values will be extracted and searched individually against the ServiceNow cmn_department table with the first matching value returned.

3. Once a match is returned, CI Sync will store the sys_id of the cmn_department record against the department field on the CI. If no match is found, the department attribute on the CI will be blank.

4. Regardless of whether a match is found (or not), CI Sync will also populate the ServiceNow cmdb_key_value table with the raw Label or Tag data (i.e. an entry will be created in cmdb_key_value for each Label or Tag and it’s raw value).

Department Value Replacements

RegEx

This setting allows customers to define a search and replace RegEx express that acts on the values read from a given Label or Tag.

Enter a Regular Expression that defines the search string and the replacement value string.

The RegEx format consists of a two element array. The first element is the search RegEx and the second element is the replacement text.

Example RegEx

[['/_/', ' ']]

RegEx Explained

This RegEx will replace “_” characters with space characters. For example: “123_456” will be transformed to “123 456” (without the quotes.. they are just for reference in this documentation)