Map tables to tables with Security Operations field mapping

Security Operations provides you with finer field mapping granularity so you can map a Security Operations table to any other table.

Before you begin

Role required: sec_cmn.write
Note: Field mapping requires advanced technical knowledge of scripting and creating triggers for the scripts (business rules, UI action, workflows, and so on). Contact ServiceNow Professional Services for more information.

Procedure

  1. Navigate to Security Operations > Utilities > Field Mapping.
  2. Click New.
  3. Fill in the fields on the form, as appropriate.
    Table 1. Field mapping
    Field Description
    Name The name of the field map.
    Description Description for the field map.
    Source table The table that provides the data to use to create a record in the Target table.
    Target table The table where new records are created.
    Active Select this check box to activate the mapping.
    Note: Only one mapping between tables can be active at a time. If two maps contain the same tables, then the older version is automatically deactivated.
  4. Click Submit.
    Field Mapping Fields tab appears.
  5. Click New.
  6. Fill in the fields on the form, as appropriate.
    Table 2. Field mapping field
    Field Description
    Transform type

    The type of transform used between source field data and target field data.

    Choose the transform type:
    Populate target field with source field value
    For example, map State to Severity field.
    Note: Source and target field types must correspond to each other. For example, State is an integer. It can only be mapped to other integers.
    Add as a new line on the target field.
    For example, map assignment_group to work notes.
    Static value
    For example, 215 to order.
    Static value plus display field value.
    For example, map "Your domain is: Domain to Domain.
    Source table The table the mapping came from.
    Source Field Choose the field to read from.
    Application Identified scope.
    Field Mapping Name of the field mapping file.
    Target table The table where new records are created.
    Target field Choose the field to write to.
  7. Click Submit.