Create the CSV Import File

In Microsoft Excel or other .csv editor, create a file that lists all of the devices that you want to import. For the purposes of this document, it is assumed that you are creating a spreadsheet using Excel.

Your spreadsheet can include devices that already exist in Security Manager. You can use the spreadsheet to update settings for those devices, or you can simply choose to not re-import those devices later.

To create the CSV file, complete the following steps.

  1. On the Administration toolbar, click Device > Management Stations.
  2. Click Import.
  3. Click the Sample-UI-ManagementStation-Import.csv link to download the file.
  4. Open the Sample-UI-ManagementStation-Import.csv file.

The file will open in Microsoft Excel.

Remove the sample text before saving the file.

  1. Add each management station that you want to import or update in a new row. Provide data for as many fields as you can using the following guidelines:

    CSV Field Values
    Column Header Device Value Required?
    Vendor The name of the device manufacturer. Yes
    Product The name the vendor uses for the device. Yes
    Name The name of the device as you want to see it in SIP. Yes
    Description A short description of the device that will appear in the device properties. Yes
    DomainID 1 for standard installs. For MSSP installs it's the unique identifier for each domain. Yes
    DataCollectorGroupID System-generated No, optional
    ManagementIP The IP address of the device.

    For VDOMs and Palo Alto VSYS, this is IP address of an interface configured to allow SSH administrative access to the FortiGate device and its VDOMs.

    For Juniper VSYS, this the IP address of the root device.

    		 Yes
    username* The username of an account that the Data Collector will use to retrieve data from the device. No, optional
    password* The password of an account that the Data Collector will use to retrieve data from the device. No, optional
    enableUsername Enter "enable" or leave blank No, optional
    enable Password The password to log into "enable" mode, which restricts administrative access to the device. This password is blank by default.

    Not required for all devices

    Required for Cisco devices
    cpmiUsername Used for CPMI change monitoring. No, optional
    cpmiPassword Used for CPMI change monitoring. No, optional
    vsysName The name of a single VSYS or VDOM device exactly as it appears on the device. Required for VDOM, VSYS, and Palo Alto VSYS
    authKey Used for API. No, optional

    If Vendor, Product, Name, Description, DomainID, and ManagementIP field values are not provided for every management station, the import will fail.

    * The user name and password are for an account on the device that permits the Security Manager Data Collector to retrieve data from it. The minimum permissions required to communicate with a device vary by device type. And, in most cases, the device must be configured to allow communication with Security Manager.

  1. Save the spreadsheet as a .csv file.

Remove the sample text before saving the file.