Axonius to External Field Mapping
  • 15 May 2023
  • 4 Minutes to read
  • Dark
    Light
  • PDF

Axonius to External Field Mapping

  • Dark
    Light
  • PDF

Article Summary

Use the field mapping Wizard to map Axonius fields to fields in external systems. In this way you can transfer data found in Axonius into the external system as part of the configuration of relevant enforcement actions; for example Axonius to ServiceNow field mapping. The wizard shows you which fields exist on the Axonius system, allowing you to map them easily.
The following Enforcement Actions are supported:

Mapping Fields from External Systems to Axonius Fields

Use the Wizard to enter fields from External Systems and map them to Axonius fields.
To map Axonius fields to fields from External Systems:

Note: Screen captures in the example are from ServiceNow.

  1. From the Action Library, click Manage CMDB Assets, and then click the name of the Enforcement Action set you want to configure.
  2. Locate the section Map Axonius fields to <External System name> fields.

MapCMDB1.png

  1. Enter the name of an External field and click on the Axonius fields drop-down to add the Axonius field.

    You can either choose the name of an aggregated field available on the system, or choose fields from one or more specific adapters.

  2. Click the drop down box to see a list of adapters and choose an adapter.
    MapCMDB2.png

  3. Click the drop down box to see fields available.
    MappingListofFields.png

  4. Select a field.

FiledMapping.png

  1. Click Add Field to add another field to map.

FieldMapping2.png

  • Click DeleteIcon.png to delete a row.
  • Note: each custom field is sent as is, and not converted to a different format (that is integers remain integers, and their format is not changed).

Setting Priority for Adapters

When you choose specific adapters, the system can check whether the field is available on a number of adapters according to priority that you can set. Add adapters so that the system checks and if the specific field is not available on the first adapter that you choose, additional adapters are checked according to priority that you set.

  1. Choose a field on an adapter, 1st appears in the drop down box

    MappingFirst.png

  2. Click 1st and choose Add 2nd mapping priority.

    Add2ndMapping.png

  3. A Search box opens, click and select an adapter.

    MappingSearch.png

    This time you do not choose a field, as the system will look for a field with the same name on this adapter.

  4. Click on 2nd to add a third adapter in which to look for the field

Add3rdMapping.png

You can add more adapters as required.

Loading a Table of Mapped Files from a CSV File

You can also load a CSV file with a list of mapped fields. The CSV file should contain three columns with the titles, 'Adapter', 'Axonius field', 'External field'.

  • Adapter - the Axonius field adapter, if this is empty use Aggregated.
  • Axonius field - the name of the Axonius field
  • External field - the name of the field from the external system.

Axonius provides a template to create these CSV files

  1. Click Template to download the template.

MappingTEmpalte.png

  1. Click Import CSV to load a CSV file; a browser opens for you to upload a file.

    • If you have already mapped values, the imported file adds to the existing values.
    • If a field is mapped and also appears in the CSV file, the value in the CSV file overrides the value in the wizard.

JSON View

You can use files in JSON. Click JSON view to see the mapping in JSON view, or set the mapping using JSON

MappingJSON.png

* Click Wizard view to go back to the wizard.

Mapping format in JSON

You can set the mapping of Axonius fields to fields from external systems using JSON. The input format is key/value pairs in JSON format.
For example: {"axonius_field1":"servicenow_field1", "axonius_field2":"servicenow_field2"}

Axonius Field Format

  • Axonius field names can be supplied in a short name or in a full name format. The following table provides examples for each format for each field type:
Note:

If you open the JSON file in the Wizard, the Wizard converts the Axonius field names to short name format. Full name is still supported.

Field LevelField TypeField Label in GUIFormat - Short NameFormat - Full NameComment
AggregatedSimpleimage.pnghostnamespecific_data.data.hostname
AdapterSimpleimage.pngaws_adapter:hostnameadapters_data.aws_adapter.hostname
AggregatedCompleximage.pnginstalled_software:namespecific_data.data.
installed_software.name
Mapping is supported only for the 1st level fields in a complex field hierarchy
AdapterCompleximage.pngtanium_asset_adapter:
installed_software.name
adapters_data.tanium_asset_adapter.
installed_software.name
Mapping is supported only for the 1st level fields in a complex field hierarchy
  • A field that contains multiple values will be mapped to a single string consists of the various values separated by comma.
  • The supplied field mapping can override any of the default mappings done when the external entity is created/updated.
  • If the supplied Axonius field is not found, the specific key/value pair will be ignored.

External System Field format

  • The External System field names are the External system technical name as defined in the relevant API.

Setting Priority in the JSON View

You can set priority in the JSON file, refer to Setting Priority for Adapters
To set priority use the following syntax:

"adapter1name, adapter2name, adapter3name: asset name”:”servicenow_assetname"
For example:

"alibaba_adapter,aws_adapter,cisco_adapter :plugin_and_severities.nessus_instance.thorough_tests": "test"

Mapping the Same Axonius Field to More than one External System Field

Use commas in the JSON file to map the same Axonius field to more than one External System field.
For example: "hostname": "test,dd"


For more details about other Enforcement Actions available, see Action Library.


Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.