Handling ETL lookup name

When an ETL creates a system, the Capacity Optimization loader uses the values of the following properties:

  • ds_sysnm for the lookup name.
  • sysnm for the name displayed in the console.

By default, if an ETL extractor with a single lookup table populates sysnm and ds_sysnm fields with FQDNs, before the data is loaded into the database, the ETL loader removes the domain suffix from sysnm and leaves ds_sysnm as it is.

To change these default settings, see the following sections: 

To remove the domain suffix from ds_sysnm

  1. Access the ETL configuration screen by navigating to Administration> ETL & SYSTEM TASKS > Add > Add ETL section of the BMC TrueSight Capacity Optimization Console.
  2. Click the Advanced button to toggle the advanced configuration options.
  3. Set Remove domain suffix from data source name to true, as shown in the figure:

    Removing the domain suffix from the lookup name
    loader config.png

To include the domain suffix in sysnm

  1. Access the ETL configuration screen by navigating to Administration> ETL & SYSTEM TASKS > Add > Add ETL section of the BMC TrueSight Capacity Optimization Console.
  2. Click the Advanced button to toggle the advanced configuration options.
  3. Set Leave domain suffix to system name to true, as shown in the figure:

    Leaving the domain suffix in the name displayed in the Console
    loader config 2.png

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*