Asset Fields Imported in File-Based Adapters
The following sections detail which fields are imported as common data fields for each asset file (Devices, Users, etc.). Any other data in the CSV/JSON/XML is exclusively adapter-specific data.
General guidelines
-
These fields apply to the general CSV adapter and the JSON and Custom Files adapters, according to the asset types fetched by each adapter. Any other asset-specific requirements are listed under the specific file type.
Note
In addition for the general CSV adapter, Axonius has several CSV Asset-Specific Adapters. Generally, these are no longer supported (see note in each page), but you can still use them for reference.
-
For all values under Accepted CSV Field Name(s), spaces, hyphens and underscores are ignored, and the field name is always lowercase. For example,
First_Name--> `firstname'. -
Fields marked as Yes under Required Field? indicate that you need to include at least one of these fields as part of the imported CSV file. More of these fields available in the CSV file help provide stronger correlation.
Note about Security Findings fieldsSecurity Findings are generated from the Security Findings complex field (table) within your assets. To import them, you must first import the corresponding assets (Devices, Users, etc.); then, map the Security Findings fields using the Adapter Custom Parsing capability, where you can define how to parse specific fields from the raw data fetched.
Fields Imported with a Devices File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| Architecture | architecture | No | |
| Asset Name | name, vmname, displayname, assetname, machinename, instancename, samaccountname, endpointname, machine | No | If no hostname is configured, the Asset Name value is used for the Host Name. |
| Asset Tag | assettag, tags, tag, labels, label | No | Accepts multiple formats (see below) |
| Cloud ID | cloudid, linodeid | No | |
| Cloud Provider | cloudprovider, cloudprovidor | No | |
| Device Manufacturer | manufacturer, devicemanufacturer | No | |
| Device Manufacturer Serial | serial, serialnumber, sn, hostserialnumber, deviceserialnumber, serial, endpointserialnumber, allserialnumbers | Yes | |
| Device Model | model, modelid, endpointmodel | No | |
| Domain | domain, domainname, endpointdomain | No | If not specified and device is in DOMAIN\Name format, Axonius replaces the Domain with the parsed value. |
| Host Name | hostname, host, fqdn, fullyqualifieddomainname, compname, computername, servername, dnsname, hosthostname, endpointfqdn | Yes | Parses DOMAIN out if in DOMAIN\Name format. If set to "unknown", field is set to blank. |
| ID | id, identifier, serialnumber, assetid, resourceid | Yes | Combination of the "CSV File Name" and the specified field names. |
| IPs | ipaddresstext, ip, ipaddress, ipaddresses, ips, primaryip, endpointipaddress, registerip, sourceip, managementip, privateip, allips, lastip, address, ipaddresslist, ipaddri, ipaddrs, ipaddr, localip, privateipaddresses, ipfirst | No | Accepts a comma-separated set of IP addresses. |
| Last Seen | lastmessagetime, lastdiscoveredtime, lastseen, lastcheckin | No | If not specified, uses the time the file was last imported. |
| Last Used Users | username | No | Appends to existing list if the device already exists. |
| MAC | mac, macaddress, macaddresses, macs | Yes | Accepts a comma-separated set of MAC addresses. |
| Machine | name | No | |
| Network Interfaces | networkinterfaces | No | Axonius attempts to parse IP, MAC, and NICs from this field. |
| OS | os, osname, osversion, operatingsystem, osmode, uname, endpointos | No | Parsed into multiple properties. Reach out to Axonius if an OS is not parsing as expected. |
| OS: Kernel Version | kernel, kernelversion | No | |
| Software Name | packages | No | Delimited by spaces. |
| Tag Name | tagname, tagkey, labelname, labelkey | No | |
| Tag Value | tagvalue, labelvalue | No |
Acceptable Formats for the Asset Tag Field
| Format | Example |
|---|---|
| Comma-separated string | "Production,Critical,Web" → 3 tags |
| List of string | ["Production", "Critical"] → 2 tags |
| List of key-value dictionaries | [{"key": "env", "value": "prod"}] → 1 tag with key |
| Single dictionary | {"key": "env", "value": "prod"} → 1 tag with key |
Fields Imported with a Users File
| UI Field Name | Accepted CSV Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| Domain | domain, domainname, endpointdomain | No | |
| First Name | firstname, givenname | No | |
| ID | id, identifier, serialnumber, assetid, resourceid, userid | Yes | The ID field is a combination of the "CSV File Name" value and the specified field names. |
| Last Name | lastname, surname, sn | No | |
| mail, email, usermail, mailaddress, email address, emailprimarywork, companyemail | Yes | ||
| Name | name, vmname, displayname, assetname, machinename, instancename, samaccountname, endpointname | Yes | |
| User Name | username | Yes |
Fields Imported with a Software Applications File
The minimum requirements to parse Vulnerabilities from the CSV adapter are as follows:
- The File contains installed software parameter is checked.
- The file has at least the following headers:
- Hostname (or any of the headers supported as hostname)
- Software Name (header must be present, though may be empty on a row)
- CVE ID
The other headers (or data in a row for those headers) are optional for the purposes of parsing Vulnerabilities.
| UI Field Name | Accepted CSV Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| Host Name | hostname, host, fqdn, fullyqualifieddomainname, compname, computername, servername, dnsname, hosthostname, endpointfqdn | Yes | This field is required as the software list is imported to each individual device. |
| Software Name | softwarename, swname | Yes | This field is required in order to parse installed software. This field may be left empty on a row with CVE ID. |
| Software Path | softwarepath, swpath | No | |
| Software Vendor | softwarevendor, swvendor | No | |
| Software Version | softwareversion, swversion | No | |
| CVE ID | cve, cveid, cvelist, grypecve | No | If present, a row featuring a CVE ID is parsed as vulnerable software in addition to installed software. |
| CVE Description | cvedescription | No | This field will be ignored if CVE ID is empty or not present. |
| CVE Severity | cveseverity | No | CVE Severity needs to be one of the values listed here. An invalid CVE Severity value is ignored. This field will be ignored if CVE ID is empty or not present. 'NONE', 'LOW', 'MEDIUM', 'MODERATE', 'SEVERE', 'SERIOUS', 'HIGH', 'CRITICAL', 'URGENT', 'INFO', 'UNTRIAGED', 'NEGLIGIBLE' |
| CVE Status | cvestatus | No | CVE Status needs to be one of the values listed here. An invalid CVE Status value is ignored. This field will be ignored if CVE ID is empty or not present. 'open', 'closed', 'reopen', 'expired', 'done', 'valid', 'obsolete', 'pending' |
Fields Imported with a Databases File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, identifier, serialnumber, assetid, recid, deviceid, objectid, hostid, databaseid | Yes | This field is required (database ID). |
| Name | name, displayname, assetname, instancename, databasename, datname, database, schemaname | Yes | This field is required (database name). |
| IP | ip, ipaddress, ipaddresses, ips, sourceip, ipaddresstext, paddresstext, primaryip, endpointipaddress, registerip, managementip, privateip, allips, ipfirst, lastip, address, ipaddresslist, ipaddri, ipaddrs, ipaddr, localip, privateipaddresses, databaseip | No | |
| Port | port | No | |
| Status / Asset Status | status, assetstatus, databasestatus, state | No | |
| Instance / Instance Type | instance, instancetype | No | |
| Creation Date / Time | creationdatetime, datecreation, createddatetime, creationtime | No |
Fields Imported with an Accounts File
| UI Field Name | Accepted CSV Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, identifier, serialnumber, assetid, recid, deviceid, objectid, hostid, accounteid | Yes | This field is required (account ID). |
| Name | name, diaplayname, assetname, instancename, accountename | Yes | This field is required (account name). |
| Creation Time | creationdatetime, datecreation | No |
Fields Imported with a Business Applications File
| UI Field Name | Accepted CSV Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, application number, applicationnumber | Yes | This field is required |
| Name | name, application name, applicationname | Yes | This field is required |
| Application Type | application type, applicationtype | No | |
| Application Description | description, application description, applicationdescription | No | |
| Managed By | managed by, managedby | No | |
| Business Criticality | business critically, businesscritically | No | |
| Operational Status | operational status, operationalstatus | No |
Fields Imported with an Alerts/Incidents File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, incidentid, cloudid, uniqueid | Yes | This field is required |
| Name | name, incidentname, dusplayname | No | |
| Description | created, createdtime, creationtime, creteddatetime, createdat | No | |
| Status | status, incidentstatus, state | No | |
| Created At | starttime, start | No | |
| Start Time | starttime, start | No | |
| End Time | endtime, end | No |
Fields Imported with a Network Services File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, identifier, uniqueid | Yes | |
| Name | name, displayname | Yes | |
| Cloud ID | cloudid, linodeid | Yes | |
| Cloud Provider | cloudprovider, cloudprovidor | No | |
| Vendor | vendor, provider, vendorname | No | |
| Asset Type | instance, instancetype | No | |
| Description | assettype, txtassettype, type | No | |
| Status | status, incidentstatus, state | No | |
| Created | created, creationdate, datecreation | No | |
| Last Seen | lastmessagetime, lastdiscoveredtime, lastseen, lastcheckin | No | |
| IPs | ipaddresstext, ip, ipaddress, ipaddresses, ips, primaryip, endpointipaddress, registerip, sourceip, managementip, privateip, allips, lastip, address, ipaddresslist, ipaddri, ipaddrs, ipaddr, localip, privateipaddresses, ipfirst | No | This field accepts a comma separated set of IP addresses. |
Fields Imported with a Certificates File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, identifier, uniqueid, certificateid, certificateremoteid | Yes | |
| Name | name, displayname, certificatename, commonname | Yes | |
| Cloud ID | cloudid, linodeid | Yes | |
| Asset Type | assettype, certificatetype, type | No | One of: AWS Certificate, GoDaddy Certificate, Keyfactor Certificate, Webscan Certificate, Network Discovery Certificate, Cloudflare Certificate, CertificateFromKeyVault, ADCS Certificate, CSC DomainManager Certificate, Wiz Certificate, F5-IControl SSL Certificate |
| Create Time | createtime, created, createdtime, creationtime, createdatetime | No | |
| Issuer | issuer, issuedby, certificateissuer | No | Must be in DN (Distinguished Name) format |
| Version | version, certificateversion | No | |
| Serial Number | serialnumber, serial, certificateserialnumber | Yes | |
| Subject | subject, issuedto, certificatesubject | No | Must be in DN (Distinguished Name) format |
| Begins On | beginson, validfrom, notbefore, startdate | No | |
| Expires On | expireson, validto, notafter, expirationdate, expiration, expirationtime | No | |
| Bit Size | bitsize, keysize, keylength | No | |
| Issued Distinguished Name | issueddistinguishedname, distinguishedname, dn | No | |
| Status | status, certificatestatus, state | No | |
| Key Algorithm | keyalgorithm, keyalg, publickeyalgorithm | No | |
| Signature Algorithm | signaturealgorithm, signaturealg, sigalgorithm | No | |
| Not Before | notbefore, validfrom, beginson | No | |
| Imported At | importedat, importtime, importedtime | No | |
| Cloud Provider | cloudprovider, cloudprovidor | No | |
| Assigned IP Address | ipaddresstext, ip, ipaddress, ipaddresses, ips, primaryip, endpointipaddress, registerip, sourceip, managementip, privateip, allips, ipfirst, lastip, address, ipaddresslist, ipaddri, ipaddrs, ipaddr, localip, privateipaddresses | No |
Fields Imported with a Firewalls File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, identifier, uniqueid, firewallid | Yes | |
| Name | name, displayname, firewallname | Yes | |
| Original Source | original_source, originalsource, presource, prenatsource | No | Pre-NAT source IP/CIDR/range or 'any'. Supports the following formats: Plain IP ( 10.0.0.5), CIDR (10.0.0.0/24), IP range (10.0.0.1-10.0.0.10), Any (any or 0.0.0.0/0) |
| Translated Source | translated_source, translatedsource, postsource, postnatsource, snatsource | No | Post-NAT source IP/CIDR/range (SNAT). Supports same formats as Original Source |
| Original Destination | original_destination, originaldestination, predestination, prenatdestination | No | Pre-NAT destination IP/CIDR/range or 'any'. Supports same formats as Original Source |
| Translated Destination | translated_destination, translateddestination, postdestination, postnatdestination, dnatdestination | No | Post-NAT destination IP/CIDR/range (DNAT). Supports same formats as Original Source |
| Original Port | original_port, originalport, preport, prenatport | No | Pre-NAT port: single port (e.g., 443) or port range (e.g., 80-443) |
| Translated Port | translated_port, translatedport, postport, postnatport | No | Post-NAT port: single port or port range |
| Protocols | protocols, protocol | No | A list of comma-separated protocols (TCP, UDP, ICMP, ANY) |
| NAT Type | nat_type, nattype, type | No | Optional hint: SNAT / DNAT / NAT (automatically inferred if omitted) |
| Is Static | is_static, isstatic, static | No |
Fields Imported with a Load Balancers File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, identifier, uniqueid, loadbalancerid, lbid | Yes | |
| Name | name, displayname, loadbalancername, lbname | Yes | |
| Host IPs | host_ips, hostips, ipaddress, ip, loadbalancerip, lbip | No | Accepts comma-separated values for multiple IP addresses |
| Balanced IPs | balanced_ips, balancedips, backendips, serverips, targetips | No | Accepts comma-separated values for multiple IP addresses (balanced backend servers) |
| Balanced Hostnames | balanced_hostnames, balancedhostnames, backendhostnames, serverhostnames, targethostnames | No | Accepts comma-separated values for multiple hostnames (balanced backend servers) |
Fields Imported with a URLs/Domains File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, identifier, uniqueid, urlid, domainid | Yes | |
| Base URL | base_url, baseurl, url | Yes | https://example.com |
| Domain | domain, domainname, hostname | Yes | example.com |
| IP Addresses | ip_addresses, ipaddresses, ips, ip | No | Accepts comma-separated IP addresses associated with the URL |
| Destination Hostnames | destination_hostnames, destinationhostnames, targethostnames, resolvedhostnames | No | Accepts comma-separated destination hostnames the URL resolves to |
Fields Imported with a Network Routes File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, identifier, uniqueid, routeid, networkrouteid | Yes | |
| Name | name, displayname, routename, description | Yes | Route name or description |
Note
Additional routing-specific fields can be provided as needed for your network topology.
Fields Imported with a Containers File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, identifier, uniqueid, assetid | Yes | |
| Name | name, displayname, assetname | Yes |
Fields Imported with an Application Settings File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| Setting Name | setting_name | Yes | |
| Vendor Name | vendor_name | Yes | |
| Setting Value | setting_value | Yes | |
| Is Valid | is_valid | Yes |
Fields Imported with a Compute Services File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| ID | id, identifier, uniqueid, cloudid | Yes | Either the ID, Name, or Cloud ID fields must be populated |
| Name | name, displayname, clustername, servicename | Yes | Either the ID, Name, or Cloud ID fields must be populated |
| Cloud ID | cloud_id, cloudid | Yes | Either the ID, Name, or Cloud ID fields must be populated |
| Cloud Provider | cloud_provider, cloudprovider | No | |
| Asset Type | assettype, type | No | |
| Description | description, details | No | |
| Status | status, state | No | |
| Location | location, region, zone | No |
Fields Imported with a Tickets File
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| Ticket ID | ticket_id, ticketid, id, number, ticketnumber, incidentnumber | Yes | |
| Summary | summary, title, short_description, shortdescription | No | |
| Status | status, state, ticketstatus | No | |
| Priority | priority, ticketpriority, urgency | No | |
| Assignee | assignee, assigned_to, assignedto | No | |
| Reporter | reporter, created_by, createdby, opened_by | No | |
| Created | created, createdat, creationtime, createddatetime | No | |
| Updated | updated, updatedat, modifiedat, lastmodified | No |
Fields Imported with a Software File
Note
The field names must be exactly as listed under Accepted CSV/JSON Field Name(s).
| UI Field Name | Accepted CSV/JSON Field Name(s) | Required Field? | Notes |
|---|---|---|---|
| Name | Axonius_Software_Name | Yes | |
| Vendor | Axonius_Publisher_Name | Yes | |
| Version | Axonius_Software_Version | No | |
| Approval Status | Axonius_Approval_Status | No |
Additional Asset Types
Note
This section lists different asset-specific CSV adapters, which are generally no longer supported by Axonius; however, you can still refer to these pages to see the required table fields for each asset type.
For SaaS Applications see the structure in CSV - Applications.
For DNS Records see the structure in CSV - DNS Records.
For Expenses see the structure in CSV - Expenses.
For Licenses see the structure in CSV - Licenses
For Networks see the structure in in CSV - Networks.
For Network Services see the structure in CSV - Network Services.
For URLs see the structures in CSV - URLs.
Updated 6 days ago
Did this page help you?