TSCO vCenter Service ETL how to use whitelist and blacklist parameters and the "Blacklist file path option"

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Capacity Optimization


    COMPONENT:

    Capacity Optimization


    APPLIES TO:

    TSCO ALL VERSIONS - vCenter Service ETL how to use whitelist and blacklist parameters



    PROBLEM:

    Trying to use the vCenter Service ETL whitelist and blacklist options but the results in the workspace are not what are expected.


    SOLUTION:

    Details for accessing the vCenter Service ETL whitelist and blacklist options are in the TSCO documentation. Some of the links can be found below:
     

          
     
    To blacklist only certain cluster or hosts and whitelist VMs using a whitelist file, below is an example of the ETL import filter settings:  
     
      Important:  
    Blacklist does not provide support for regular expression, to exclude monitoring of a set of VMs which certain string in the name use a white list file with an inverted regular expression (see details  more below).  
      
      
      User-added image
      
     
    The contents of the whitelist file used in the "Blacklist file path option" are listed below:  
      
      
      #FORMAT=V2;TYPE=VM_WHITELIST  
    ^vw\-pun\-co\-aut19.* 
      
     
    The results of the imported systems in the workspace are:  
      
      
      User-added image 
     
    *** Note the inclusion of BCOQA-DC and New Datacenter is being tracked by defect DRCOZ-16609. These datacenters should not have been imported. When defect DRCOZ-16609 is fixed they will not be loaded into TSCO since there are not part of the whitelist information. 
      
     
    When higher logging is enabled, the service log will show the follow information about the whitelist otpions:  
      
      
    2018-04-11 11:45:17,558 DEBUG [service-104-1]- Adding vm regex to whitelist: ^vw\-pun\-co\-aut19.* 2018-04-11 11:45:17,558 INFO  [service-104-1]- Loaded whitelist regex file - #1 regex will be used for whitelisting vms.  2018-04-11 11:25:01,260 DEBUG [service-104-1]- Whitelisted VMs: [vw-pun-co-aut19.dsl.bmc.com] 2018-04-11 11:25:01,260 DEBUG [service-104-1]- Blacklisted VMs: [vw-pun-co-aut18.dsl.bmc.com, vl-pun-bco-qa52, vw-pun-co-aut32.dsl.bmc.com, vl-pun-aut-qa55, vw-pun-aut-qa02.dsl.bmc.com, vl-pun-aut-qa56, vl-pun-aut-qa57, vw-pun-co-aut17.dsl.bmc.com, vw-pun-co-aut20.dsl.bmc.com, vl-pun-bco-qa54, vl-pun-bco-qa53]
      
     
    The above information is only available after the saver has run for the service.  
     
    The Whitelist file can also be used to get an inverted selection from the vCenter. An example would be, you can use this way to blacklist a set of VMs. In the example below no VMs with the including the string vl-pun are monitored.  
      
      
      #FORMAT=v2;TYPE=VM_WHITELIST  
    ^(?!vl-pun.*$).* 
      
     
    The above will result in the following whitelist and blacklist output as shown in the log. The regex string will whitelist all VMs not matching "vl-pun, the "vl-pun" VMs will be added to the blacklist as shown below:  
      
      
      2018-04-11 19:00:00,615 DEBUG [service-106-1]-    Whitelisted VMs: [vw-pun-co-aut19.dsl.bmc.com, vw-pun-co-aut18.dsl.bmc.com, vw-pun-bcm-qa22, vw-pun-bco-qa055, vw-pun-co-aut29.bmc.com, vw-pun-co-aut25.bmc.com, vl-aus-bcm-gm2, vw-aus-bpa-dv08.adprod.bmc.com, CLM-template466, vw-aus-bpa-dv05, vw-pun-bco-qa02.dsl.bmc.com, vw-pun-co-aut32.dsl.bmc.com, vw-pun-aut-qa02.dsl.bmc.com, vw-pun-aut-qa01.dsl.bmc.com, vw-pun-co-aut31.bmc.com, vw-aus-aut-01, vw-pun-co-aut27.bmc.com, ADDM_VA_64_11.1.90.6_706121_dev_Full, vw-aus-co-aut03, vw-aus-co-aut01, vw-aus-co-aut02, vw-pun-bpa-qa02, vw-pun-bco-qa03-Oracle-12DB, vs-pun-bco-qa26, vs-pun-bco-qa25, vw-pun-bcm-dv18.dsl.bmc.com, vs-pun-bco-qa27, vw-pun-co-aut28.bmc.com, vw-pun-aut-qa17.dsl.bmc.com, ADDM_VA_64_11.1.0.3_677713_ga_Demo, CentOS7-OPENVMTOOLS, vs-pun-bcm-qa02-BCO-solaris10, vw-pun-bco-qa18, vw-pun-bco-qa19, vw-pun-co-aut24.bmc.com, vw-pun-co-aut30.bmc.com, vw-aus-bcm-sp02, vw-aus-bpa-dv02.dsl.bmc.com, Win2012R2-TPL, vw-pun-bpa-qa01.pune-labs.bmc.com, vw-pun-co-aut26.bmc.com, addm10.1-vm, vl-aus-bco-dv06, vw-pun-co-aut20.dsl.bmc.com, vw-pun-bco-qa05 (1), vl-aus-bco-dv04, vl-aus-bco-qa47, vl-aus-bco-dv05, vl-aus-bco-dv03, vl-aus-bco-rhevm, Mahesh_TEST, vw-pun-bco-qa04.dsl.bmc.com, VW-PUN-BCM-QA04.pune-labs.bmc.com, VW-AUS-BCO-DV06.dsl.bmc.com, vw-pun-co-aut23.bmc.com, VW-AUS-BCO-DV05.dsl.bmc.com, VW-PUN-BCO-QA05, isvm-w23-bpa03-OEM11g, vw-pun-co-aut22, vw-aus-bco-qa02, vw-pun-co-aut17.dsl.bmc.com, vl-aus-bpa-pt01, vw-pun-co-db, compactclm, vw-pun-bcm-qa21.dsl.bmc.com, vl-aus-bpa-pt02, vw-pun-bcm-dv66, vw-aus-bco-qa04, vw-pun-co-aut21.bmc.com, vw-aus-bco-qa03]  
     
    2018-04-11 19:00:00,616 DEBUG [service-106-1]-    Blacklisted VMs: [vl-pun-aut-qa29, vl-pun-aut-qa01_old, vl-pun-bco-neuton, vl-pun-bco-qa02-2, vl-pun-bco-ADDM11202, vl-pun-aut-qa15, vl-pun-bco-pt08-BCO-RHEL5.9-64, vl-pun-rds-tl1d, vl-pun-bco-qa52, vl-pun-bcm-ADDM1102, vl-pun-aut-qa55, vl-pun-aut-qa56, vl-pun-aut-qa57, vl-pun-aut-qa14, vl-pun-bld-qa01, vl-pun-bco-qa57, vl-pun-bco-qa13, vl-pun-bco-cmdb01, vl-pun-bco-qa54, vl-pun-bco-qa53, vl-pun-bco-qa02 - SUSE12, vl-pun-bco-qa56, vl-pun-bco-qa12, vl-pun-bco-qa55, vl-pun-bco-qa11, vl-pun-bcm-ADDM112, vl-pun-bco-octa, vl-pun-openn-vc01, vl-pun-bco-rsso1, vl-pun-bco-pt06, vl-pun-bcm-dv28, vl-pun-bcm-dv26, vl-pun-bco-pt03, vl-pun-bco-pt02, vl-pun-aut-qa01, vl-pun-bcm-dv27, vl-pun-bco-pt05, vl-pun-aut-qa02, vl-pun-bco-pt04, vl-pun-bcm-qa09-CentOS-6.5-64, vl-pun-bco-qa05, vl-pun-bco-qa06-CentOS6.5-64, vl-pun-bco-pt03c, vl-pun-bco-pt03b, vl-pun-bco-pt03a, vl-pun-bcm-dv19, vl-pun-bcm-dv15, vl-pun-bcm-dv16, vl-pun-octa2-qa02, vl-pun-bcm-qa10, vl-pun-bco-qa02-1 - SUSE12, vl-pun-bcm-qa13, vl-pun-bco-qa39, vl-pun-bcm-qa12, vl-pun-open-new01, vl-pun-bcm-qa11, vl-pun-bco-pt01, vl-pun-ocata-qa01, vl-pun-bco-mitaka3] 
      
        
      

    Notes

    It is a best practice to be running a recent TSCO Cumulative Hot Fix (CHF) level.  For example, for TSCO 11.0 and earlier Defect DRCOZ-16117 fixed in the CHF could make it difficult to determine the proper case of VMs on the vCenter side even when high logging is enabled in the ETL due to all VMs being reported in lowercase but the filtering being done against the mixed case name.  

     

      

    Additional Information

    The vCenter ETL does not log when a whitelist file has been specified but cannot be found on the ETL Engine Server (because it doesn't exist or the path/filename have been specified incorrectly).  The ETL behaves as if no whitelist file has been specified. 

    Defect DRCOZ-22315: 'The vCenter ETL does not generate a clear WARNING or ERROR message when whitelist file doesn't exist' has been logged to request a clear WARNING message from the vCenter ETL if the specified whitelist/blacklist file doesn't exist. 
      

     


    Article Number:

    000151850


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles