How to configure the Generic - Tag CSV file parser ETL to load data into existing TrueSight Capacity Optimization(TSCO) entities.

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 11.5.01


    APPLIES TO:

    TrueSight Capacity Optimization 11.x,20.02



    QUESTION:

    The ETL runs and finishes successfully, the problem is that it creates a new entity with the tag in an environment with multiple lookup values, however, none of the existing entities gets tagged accordingly.


    ANSWER:

    When creating a Tag parser ETL, you have to take into consideration whether the environment has multiple lookup values for the entities you wan to tag, so if there are multiple ETLs importing data (like Vmware ETL and VIS Parser ETL), make sure the input file contains STRONGLOOKUPFIELDS AND WEAKLOOKUPFIELDS properly defined on the file. See KA 000025065: Single lookup vs. Multiple lookup in BMC TrueSight Capacity Optimization ETLs

    If intention to create tags on existing entities, the ETL automatically created entities that do not match chosen lookup values. If you don't want that, you can edit the ETL run configuration, switch to Advanced mode and set "Loader Configuration -> Skip entity creation" to true.

    Note: 
    Ensure ETLs are all sharing the same entity catalog.

    This would be an example of a tag that creates a tag name, description and tag environment on the entity:

     

    ENTCATNM,DS_ENTNM,ENTNM,TAG,TAGDESCR,TAGTYPE,TAGTYPEDESCR,ENTTYPENM,STRONGLOOKUPFIELDS,WEAKLOOKUPFIELDS,OPERATION SYS,VN_NAME#sysname,sysname,TestTag1,TestTag1 Description,ENV,ENV description,gm:wvn,VN_NAME,
      
    **Make sure the values on field "TAG" don't contain spaces as this is not supported in tag names.

    -When adding multiple tags to a server,need to add new line as per below example:

       
    ENTCATNM,DS_ENTNM,ENTNM,TAG,TAGTYPE,ENTTYPENM,STRONGLOOKUPFIELDS,WEAKLOOKUPFIELDS,OPERATION SYS, HOSTNAME#xyz.bmc.com##NAME#xyz,xyz,Production,ENV,gm:vmw,HOSTNAME,NAME  SYS, HOSTNAME#xyz.bmc.com##NAME#xyz,xyz,Ownername,ENV1,gm:vmw,HOSTNAME,NAME
      
    - When adding tag for Physical Server which has system type as Generic,which has no strong lookup available in view lookup,use 'gen' as ENTTYPENM in csv tag file.

     


    Article Number:

    000330316


    Article Type:

    FAQ/Procedural



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