- 15 May 2023
- 4 Minutes to read
- Print
- DarkLight
- PDF
Axonius to External Field Mapping
- Updated on 15 May 2023
- 4 Minutes to read
- Print
- DarkLight
- PDF
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:
- Create ServiceNow Asset
- Update ServiceNow Asset
- Create Cherwell Asset
- Update Cherwell Asset
- Create Ivanti Service Manager Asset
- Update Ivanti Service Manager Asset
- Send to Google BigQuery Table
- Microsoft Azure - Send Assets to Microsoft Power BI
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.
- From the Action Library, click Manage CMDB Assets, and then click the name of the Enforcement Action set you want to configure.
- Locate the section Map Axonius fields to <External System name> fields.
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.
Click the drop down box to see a list of adapters and choose an adapter.
Click the drop down box to see fields available.
Select a field.
- Click Add Field to add another field to map.
- Click
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.
Choose a field on an adapter, 1st appears in the drop down box
Click 1st and choose Add 2nd mapping priority.
A Search box opens, click and select an adapter.
This time you do not choose a field, as the system will look for a field with the same name on this adapter.
Click on 2nd to add a third adapter in which to look for the field
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
- Click Template to download the template.
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
* 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:
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 Level | Field Type | Field Label in GUI | Format - Short Name | Format - Full Name | Comment |
---|---|---|---|---|---|
Aggregated | Simple | ![]() | hostname | specific_data.data.hostname | |
Adapter | Simple | ![]() | aws_adapter:hostname | adapters_data.aws_adapter.hostname | |
Aggregated | Complex | ![]() | installed_software:name | specific_data.data. installed_software.name | Mapping is supported only for the 1st level fields in a complex field hierarchy |
Adapter | Complex | ![]() | tanium_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.