Configuring sources

By default, the source data in Asset comes from Tanium, populated from saved questions that are scheduled on a configurable basis. You can also configure a database as an asset source.

Configure Tanium source

The Tanium source is configured by default, and you cannot delete the Tanium source.

  1. From the Asset menu, go to Inventory Management > Sources.
  2. For the Tanium source, click Edit .
  3. Configure the log level settings for the Asset import process.
  4. Add the user name and password for the service account. The selected user must be a Tanium Administrator. This configuration is shared with the user name and password for the service account that is configured in the Settings on the Service Account tab.
  5. Configure the schedule. The schedule determines how often asset data is imported from the Tanium live data into the asset database. This database provides data for offline assets. You can create a standard interval or a Cron schedule. For example, you might create one of the following intervals based on your environment size:
    • Less than 50,000 devices: every 1-2 hours
    • Less than 250,000 devices: every 4 hours
    • Greater than 500,000 devices: consult your TAM to configure the import schedule

    For more information about the Cron syntax, see Reference: Cron syntax.

  6. Click Update to save your changes.

What to do next

Add attributes from Tanium sensors into Asset. See Configuring attributes.

Configure database source

Enrich Asset inventory data with information from an external database. For example, you might have a database that has department or location information that you want to associate with the computers you are already tracking in Asset. To import this data, map columns from your SQL database to the Asset database.

When the data import runs, each row of your import table is evaluated against the data that is already in Asset. For example, if you create a mapping for your computer ID in the import table, that ID gets matched to the Computer ID column in Asset. If a match is found, the attributes that you configure to get imported from your source table are inserted into Asset. If you map an import column that has duplicate values in the table, only the last value is stored in Asset after the load has completed.

If you use column types (like nchar) that pad values with spaces, your identity mappings on the database source might not work correctly. For example, a computer name like win1 might come through as win1       (with six spaces after it). These values do not match a value win1 in Asset.

  1. From the Asset menu, go to Inventory Management > Sources > Create Database Source.
  2. Configure source settings. Enter a name for the data source, and the server name and credentials. Click Get Schemas. Asset connects to the database and gets the database and schema information. Choose the database and schema.
  3. Configure source mappings. Source mappings uniquely identify the assets in your source data, and define how the columns in your source table relate to the Asset database. For an attribute to be available as a reference for mapping, it must only return a single row of value. You can add multiple source mappings from your database source. All the mappings must match for the data to be imported into the Asset database.
    1. Click Add Mapping. Choose a source table.
    2. Create identification rules. The columns associated with the selected source table are loaded into the Source Columns field.
    3. Choose a destination attribute. Choose a column in the Asset database. You can create multiple identification rules as necessary.
  4. Configure the import schedule. The schedule determines how often asset data is imported from the external database into the asset database. You can create a standard interval or a Cron schedule.

    For more information about the Cron syntax, see Reference: Cron syntax.

  5. Click Create.

If you want to modify the source, go to Inventory Management > Sources. Click Edit . You must enter the credentials for your SQL server again before you can modify the source mappings.

What to do next

Add the attributes from your import table into Asset. See Configuring attributes.

Disable sources

Data imports for a source run on a configured schedule by default. You can disable this schedule to resolve issues, or run the import manually.

  1. From the Asset menu, go to Inventory Management > Schedules.
  2. Hover over the import schedule for the source that you want to disable and click Edit .
  3. Clear the Run this connection on a defined schedule setting. Click Update.
  4. If you want to manually run an import, go to the Inventory Management > Schedules page. Hover over the import schedule and click Run Now.

Last updated: 9/3/2019 1:42 PM | Feedback