Import data sources from a .csv file

Prev Next

Import a list of data sources, which eliminates the need to add, edit, or remove them manually. You use this option:

  • To import raw data source data copied from a Receiver in a secured location to a Receiver in an unsecured location.

  • To edit the data sources on a Receiver by adding data sources to the existing list, editing existing data sources, or removing existing data sources.

  1. Export a list of data sources currently on the Receiver.

  2. On the system navigation tree, select Receiver Properties, then click Data Sources.

  3. Click Export, then click Yes to confirm the download.

  4. Select the location for the download, change the file name if needed, then click Save.

  5. Access and open this file.

  6. Add, edit, or remove data sources on the list.

  7. In column A, specify whether to add, edit, or remove the data source.

  8. If adding or editing data sources, enter the information in the spreadsheet columns.

    Note

    You can't edit the policy or the name of the data source.

  9. For added data sources, change the rec_id to the ipsid of the Receiver you are importing to

  10. Save the changes made to the spreadsheet.

    Note

    You can't edit a data source to make it a data source from a client data source or the other way around.

  11. Import the list to the Receiver.

  12. On the system navigation tree, select Receiver Properties, then click Data Sources.

  13. Click Import, then select the file and click Upload.

    Note

    You can't change the policy or the name of the data source.

  14. To import the changes, click OK.

  15. If there are errors in the formatting of the changes, a Message Log describes the errors.

  16. Click Download Entire File, then click Yes.

  17. Select the location for the download to be saved, change the name of the file if needed, then click Save.

  18. Open the file that downloaded.

  19. Correct the errors, then save and close the file.

  20. Close Message Log and Import Data Sources, then click Import and select the file that you saved.

  21. Click OK.

File format

If you are working with an exported .csv file, the first row shows the Trellix ESM version that the data was exported from. If you are creating a new .csv file to provision data sources, enter the target Trellix ESM version.

Table 3-1 Data source .csv fields

Column

Field

Description

A

op

The operation to be performed (add, edit, remove, enable, disable).

B

rec_id

The IPSID of the ERC this DS gets added to.

C

dsname

The name of the data source.

D

ip

IP address configured for this data source.

E

model

Model of the data source ( Windows WMI vs Windows DHCP).

F

vendor

The company that produces the model.

G

parent_id

If the data source is a child, this indicates the data source’s parent.

H

child_type

0 = not a child; 1 = child/agent; 2 = client

I

matching_type

Defines a type of matching for data coming into this data source.

J

aruba_version

If the new data source is Aruba, this indicates it’s version. Otherwise, it's empty.

K

autolearn

Defines whether the parser should autolearn events. T=true, F=false. Default is false.

L

elm_logging

"T" turns ELM logging on. "F" turns it off.

M

exportNitroFile

Default is "F".

N

linked_ipsid

Original IPSID from the export. The new IPSID is likely different after the data source is added to a new receiver.

O

mask

The netmask that applies to syslog data sources.

P

nitro_formated_file

Used for forwarded client data sources. Upon export, this contains the original IPSID.

Q

nitro_formated_file_xsum

Related to nitro_formated_file. Default is "no".

R

parsing

Sets whether the data collected by this data source should be parsed. Default ‘yes’, otherwise ‘no’.

S

policy_name

If policy is included in the export, this will reference that policy by name.

T

require_tls

For syslog data sources, sets TLS enabled (T) or disabled (F).

U

snmp_trap_id

The ID of the SNMP trap if this is an SNMP data source.

V

syslog_port

The port configured to listen to for this syslog data source (otherwise empty).

W

type

The DSID (data source ID) of the data source. Default is 49190.

X

tz_id

ID of the time zone for this data source.

Y

url

The URL for this datasource. Default is empty.