Tag Synchronization for Managed By in Azure

Azure

All

Setting

Type

Additional Notes

Enable for Managed By

Slider

If enabled, defined Tags will be synchronized to the managed_by field against CIs in the CMDB.

When enabled, the Managed By Tag RegEx field will be exposed (see below).

Managed By Tag RegEx

RegEx

Enter a Regular Expression that matches one or more Tag names in Azure (i.e. one or more Tags that represent the Owned By associated with the Azure resource).

Example RegEx

/^ManagedBy$|^ManagedByTag$|^ManagedBy 1$|^ManagedBy 2$|^ManagedBy1$|^ManagedBy$/

RegEx Explained

This RegEx will identify Labels (or Tags) named “ManagedBy”, “ManagedByTag”, “ManagedBy 1”, “ManagedBy 2”, “ManagedBy1” or “ManagedBy2” (i.e. six variations) and sync’d the associated values into ServiceNow.

Sync Behaviour and ServiceNow Data Explained

1. If there are multiple Tags that match the defined regEx for a field, the value within each Tag will be searched against the ServiceNow sys_user table. The CI Sync lookup ranks the results to return active users first.

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

3. Once a match is returned, CI Sync will store the matching sys_user value against the managed_by field on the CI. If no match is found, the managed_by 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 (tag) data (i.e. an entry will be created in cmdb_key_value for each Tag and it’s raw value).

Managed by Value Replacements

Choicelist

For context in Azure: Azure is restrictive as to the values allowed in Tags, therefore CI Sync provides support for transforming Azure Tags into valid user names. For user names: as Azure does not allow for the entry of space characters in Tag values, CI Sync provides for the substitution of either “-” or “_” with a space character when searching the sys_user.name field.

This setting allows customers to define a search and replace RegEx express that acts on the values read from a given 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

[['/dot/', '.'],['/at/', '@']]

RegEx Explained

This RegEx will replace the literal text “dot” with a “.” (period) character, and will replace the literal text “at” with the “@” symbol. For example “AndrewdotKentatsyncfishdotcomdotau” will be transformed to “Andrew.Kent@syncfish.com.au” (without the quotes.. they are just for reference in this documentation)

Managed By Lookups

Choicelist

Select one of the available choicelist items which control sys_user attribute/s CI Sync searches using the value/s in the tag.

See below for the available choices.

In this example if you select ‘e-mail [email] & Name [name]' you will see a message as per below explaining that you must select the corresponding options in the ServiceNow destination connection 'User Synchronization’ section. Please refer to the document linked below.

Define a User oriented attribute when using User Synchronization from a Source System in ServiceNow

If the corresponding selection in ServiceNow is not made the sync job will error.