The Teleseer Custom CSV Parser enables uploading a comma-separated value (CSV) formatted file with additional asset information. When a row matches a project asset by IP address or MAC address, that project asset receives either a new tag or an attribute update (when the value corresponds to one of several reserved column names).

The parser supports two CSV formats: Hardware List and Splunk.

Hardware List CSV

• Required Columns (case-insensitive)
  • machine name
  • ip address
  • manufacturer

Note: All three columns must be present in the CSV, but in any given row only ip address is required to have a value; machine name and manufacturer can be left blank.

How It Works:

• Assets are matched by IP address
• The following columns map to specific asset attributes:
  • "machine name" → hostname
  • "ip address" → ip (adds but does not overwrite existing values)
  • "manufacturer" → manufacturer
• Any additional columns are added as tags in column_name: value format.

Splunk CSV

• Required Columns (case-insensitive)
  • os
  • dns
  • function
  • ip
  • mac
  • nt_host

Note: All listed columns must be present in the CSV, but in any given row at least one of ip or mac must have a value; all other columns are optional and can be left blank.

How It Works:

• Assets are matched by IP address or MAC address.
• The following columns map to specific asset attributes:
  • "os" → OS Name
  • "dns" → hostname
  • "function" → roles
  • "ip" → ip (does not overwrite existing values)
  • "mac" → mac (does not overwrite existing values)
  • "nt_host" → hostname
• If both dns and nt_host are present, they are added as multiple hostnames for the asset.
• Any additional columns are added as tags in column_name: value format.

General Notes

• Column headers are case-insensitive.
• Extra columns are never ignored — they are always added as tags in column_name: value format.
• IP and MAC values will not overwrite values that already exist on a matched asset.

Example CSVs and Interpretation

Hardware List Example

Interpretation of Hardware List Rows

1. Row 1:
   • Match: Asset matched by IP address = 192.168.1.10.
   • Mapped Fields:
     • hostname → Server1
     • manufacturer → Dell
   • Tags Added:
     • location: Datacenter A
     • rack: Rack 1
2. Row 2:
   • Match: Asset matched by IP address = 192.168.1.11.
   • Mapped Fields:
     • hostname → Server2
     • manufacturer → HP
   • Tags Added:
     • location: Datacenter B
     • rack: Rack 2
3. Row 3:
   • Match: Asset matched by IP address = 192.168.1.12.
   • Mapped Fields:
     • hostname → Server3
     • manufacturer → Lenovo
   • Tags Added:
     • location: Datacenter A
     • rack: Rack 3
4. Row 4:
   • Match: Asset matched by IP address = 192.168.1.13.
   • Mapped Fields:
     • hostname → Server4
   • Tags Added:
     • location: Datacenter B
     • rack: Rack 4
5. Row 5:
   • Match: Asset matched by IP address = 192.168.1.14.
   • Mapped Fields:
     • manufacturer → Framework
   • Tags Added:
     • location: IT Build Bench

‍

Splunk Example

Interpretation of Splunk Rows

1. Row 1:
   • Match: Asset matched by IP = 192.168.1.11 or MAC = 00:1A:2B:3C:4D:5E.
   • Mapped Fields:
     • OS Name → Linux
     • hostname → server1.com
     • roles → Web Server
     • mac → 00:1A:2B:3C:4D:5E
   • Tags Added:
     • department: IT
     • app: Apache
2. Row 2:
   • Match: Asset matched by IP = 192.168.1.12 or MAC = 00:1A:2B:3C:4D:5F.
   • Mapped Fields:
     • OS Name → Windows
     • hostname → server2.com
     • roles → File Server
     • mac → 00:1A:2B:3C:4D:5F
   • Tags Added:
     • department: Finance
     • app: SMB
3. Row 3:
   • Match: Asset matched by IP = 192.168.1.13 or MAC = 00:1A:2B:3C:4D:60.
   • Mapped Fields:
     • OS Name → macOS
     • hostname → server3.com
     • roles → Dev Server
     • mac → 00:1A:2B:3C:4D:60
   • Tags Added:
     • department: Engineering
     • app: Xcode
4. Row 4:
   • Match: Asset matched by IP = 192.168.1.14
   • Mapped Fields:
     • hostname → server4.com
   • Tags Added: None
5. Row 5:
   • Match: Asset matched by MAC = 00:1A:2B:3C:4D:6Y
   • Mapped Fields:
     • OS Name → Linux
     • hostname → server5.com
     • roles → PBX Server
     • mac → 00:1A:2B:3C:4D:6Y
   • Tags Added: None

‍