Importing Rule Owners Using CSV

Overview

Use this procedure to upload multiple owners and assets to RLM using a CSV file. After you define the owners and their assets, Rule Owners can make certification decisions about the rules for which they are responsible.

Here is an example as a text file:

Use a comma (,) as a delimiter. Use quote marks (" ") to group multiple values that are separated by commas.

Here is an example as an Excel worksheet:

Click here to download a sample Excel file template.

The CSV includes the following columns:

RLM uses the column names to match values during import. The order of the columns is irrelevant.

Column

Description
application

Word or phrase to associate with the asset.
asset_name List of assets.

asset_values

Values for the assets.
description

Description for the owner-asset pairing.

match_on

Field with which you want to match assets to owners: Source, Destination, or Both.
objects List of objects in SecureTrack. If an object name is not exact, the whole row is excluded.
owner SecureChange owner name or name of a group of owners. The username value must match a SecureChange user or group of users exactly.

services

Services in the format protocol:port (single) or protocol:min_port-max_port (range). During the next automated sync between RLM and SecureTrack, RLM will include relevant service information based on the object name.

service_object_names

Name of the object on the device. You can only add this field using CSV or API.

For more information about mapping Rule Owners to rules, see Mapping Assets to Rule Owners.

Prerequisites

  • Create users in SecureChange for all Rule Owners in RLM.

    • Each user must have User name and Email attributes.

    • The field, Owner, in the RLM mapping template must be an identical match to the field User name.

    For SecureChange login credentials, contact your TOS Administrator.

  • Use either Google Chrome or Mozilla Firefox internet browser for RLM.

  • Configure all relevant users and workflows in SecureChange.

  • Provide SMTP server information if notifications need to be sent.

  • Ensure a list of owners and their associated assets, if available.

Add Owners Using a CSV

  1. Click Settings () > Owners and Assets.

    The Owners and Assets page appears in the lower section of the page:

  2. From the Actions () list, select Import Owners.

  3. Select the TXT or Excel file with the owner-asset information.

    Depending on the volume of data, the upload may take some time.

  4. Run a scan to update the rules based on the new uploaded data (see Run a Manual Scan).