CSV Serials
  • 6 minutes to read
  • Print
  • Share
  • Dark
    Light

CSV Serials

  • Print
  • Share
  • Dark
    Light

The CSV Serials Adapter is able to import .csv files with inventory information including the serial number of a device and supplemental device data.

Adapter Parameters

  1. Is Users CSV File (required, default: False)
    • Selecting this option will import the CSV file as a list of Users instead of devices.
    • See the below section for fields required in a Users CSV File.
  2. Is Installed Software File (required, default: False)
    • Selecting this option will import an installed software list instead of devices.
    • See the below section for fields required in a Software Applications CSV File.
  3. CSV File Name (required) - A unique name for a CSV adapter connection. The value supplied here will be populated in the CSV File Name field for the data supplied by a specfic CSV adapter connection.
  4. CSV File (optional) - Select a local CSV file to import.
NOTE
When using this option, the data imported from the CSV will never be fetched again, as the file is static.
  1. CSV URL Path (optional, default: empty) - The URL for the URL where a CSV file can be fetched.
  2. CSV Share Path (optional, default: empty) - The network share where a CSV file can be fetched.
  3. CSV Share Username / Password (optional, default: empty) - Optional user name and password for the SMB share. These settings may be required if the "ubuntu" user on the Axonius system does not have access to the SMB share.
  4. Amazon S3 Bucket Name (optional, default: empty) - The name of the S3 bucket to fetch the CSV file.
  5. Amazon S3 Object Location (optional, default: empty) - The location within the S3 bucket where the CSV file can be fetched.
  6. Amazon S3 Access Key Id and Amazon S3 Secret Access Key (optional, default: empty) - The credentials used to access the S3 object.
NOTE
If Axonius is running on an EC2 instance, this can be left empty to use the IAM Role of the instance.
  1. Choose Instance - (required, default: 'Master') - The Axonius node to utilize when connecting to the adapter. For more details, see Connecting Additional Axonius Nodes.

image.png

If multiple CSV options are added to a CSV adapter, what CSV will be imported?

If multiple import CSV import types are provided in the CSV adapter, the following order will be taken for importing:

  1. CSV URL Path
  2. CSV Share Path
  3. Amazon S3 Bucket - CSV File

The CSV File content is determined based on the following order:

  1. User assets - If Users CSV Files is selected
  2. Installed software list - If Installed Software File field is enabled.
  3. Device assets - If none of the options above is selected, the CSV is assumed to be a device CSV.

Which fields can be populated for each CSV import type?


CSV Import Type Required fields Optional fields
CSV from File CSV File Name, CSV File Is Users CSV File, Is Installed Software File
CSV from URL CSV File Name, CSV URL Path, Choose Instance Is Users CSV File, Is Installed Software File
CSV from File Share CSV File Name, CSV Share Path, Choose Instance Is Users CSV File, Is Installed Software File, CSV Share Username, CSV Share Password
CSV from S3 Bucket CSV File Name, Amazon S3 Bucket Name, Amazon S3 Object Location Is Users CSV File, Is Installed Software File, Amazon S3 Access Key ID


NOTE
Based on the order of operations, any fields that are specified and not applicable to the import type will be ignored. For example, filling in the "Amazon S3 Bucket Name" field while the "CSV URL Path" is populated will cause the "Amazon S3 Bucket Name" property to be ignored but not removed.

Which fields will be imported with a Devices CSV?

The following data will be imported as common data fields while any other data in the CSV will exclusively be Adapter Specific data.

NOTE
Fields marked as REQUIRED indicate that at least one of those values is required to import. The more fields available will help provide stronger correlation.
UI Field Name Accepted CSV Field Name(s) Notes
Architecture architecture
Asset Name name, vmname, displayname, assetname, machinename, instancename, samaccountname, endpointname REQUIRED If no hostname is configured, the Asset Name value will be used for the Host Name.
Device Manufacturer Serial serial, serialnumber, sn, hostserialnumber, deviceserialnumber, serial#, endpointserialnumber REQUIRED
Device Manufacturer manufacturer, devicemanufacturer
Device Model model, modelid, endpointmodel
Domain domain, domainname, endpointdomain If this value is not specified AND the device is specified in DOMAIN\Name format, Axonius will replace the Domain value with the parsed out DOMAIN.
Host Name hostname, host, fqdn, fullyqualifieddomainname, compname, computername, servername, dnsname, hosthostname, endpointfqdn REQUIRED If the device is specified in DOMAIN\Name, Axonius will parse the DOMAIN value out. If the CSV field is set to "unknown", Axonius will set the Host Name to blank.
ID id, identifier, serialnumber, assetid, resourceid REQUIRED The ID field is a combination of the "CSV File Name" value and the specified field names.
IPs ipaddresstext, ip, ipaddress, ipaddresses, ips, primaryip, endpointipaddress This field will accept a comma separated set of IP addresses.
Last Seen lastmessagetime, lastdiscoveredtime, lastseen If this value is not specified, we will enter the time that the CSV was last imported.
Last Used Users username This will append to the existing Last Used Users list if the device already exists.
MAC mac, macaddress, macaddresses, macs REQUIRED This field will accept a comma separated set of MAC addresses.
Network Interfaces networkinterfaces Axonius will attempt to parse IP address(es), MAC address(es), and network interface cards from this field.
OS (see Notes) os, osname, osversion, operatingsystem, osmode, uname, endpointos This field will be parsed out into multiple properties within the OS field. Not all OSes will be parsed properly. Please reach out to Axonius if an OS is not parsing as expected.
OS: Kernel Version kernel, kernelversion
Software Name packages This is delimited by spaces.

Which fields will be imported with a Users CSV?

The following data will be imported as common data fields while any other data in the CSV will exclusively be Adapter Specific data.

NOTE
Fields marked as REQUIRED indicate that at least one of those values is required to import. The more fields available will help provide stronger correlation.
UI Field Name Accepted CSV Field Name(s) Notes
Domain domain, domainname, endpointdomain
First Name firstname, givenname
ID id, identifier, serialnumber, assetid, resourceid REQUIRED The ID field is a combination of the "CSV File Name" value and the specified field names.
Last Name lastname, surname, sn
Mail mail, email, usermail, mailaddress, email address, emailprimarywork REQUIRED
Name name, vmname, displayname, assetname, machinename, instancename, samaccountname, endpointname REQUIRED
User Name username REQUIRED

Which fields will be imported with a Software Applications CSV?

The following data will be imported as common data fields while any other data in the CSV will exclusively be Adapter Specific data.

NOTE
Fields marked as REQUIRED indicate that at least one of those values is required to import. The more fields available will help provide stronger correlation.
UI Field Name Accepted CSV Field Name(s) Notes
Host Name hostname, host, fqdn, fullyqualifieddomainname, compname, computername, servername, dnsname, hosthostname, endpointfqdn REQUIRED This field is required since we are importing the software list to each individual device.
Software Name softwarename, swname REQUIRED
Software Vendor softwarevendor, swvendor
Software Version softwareversion, swversion
Was this article helpful?