ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to update interface name alias' in CA Performance Management (CAPM)

book

Article ID: 15274

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration

Issue/Introduction

Old CAPC Interface Alias name information remains even though the Network Interface name and Description field get updated when device configuration has changed. On a large network, it's difficult to examine which interfaces are updated and which have names and alias' that are mismatched.

This KB describes a method of updating all old Interface Alias names.

Environment

DX NetOps CAPM 2.x & 3.x

Resolution

  1. Backup CAPC MySQL 

  2. Extract the unmatched information between Network Interface name and Interface Alias name from the CAPC MySQL DB as follows:

    # /opt/CA/MySql/bin/mysql 

      mysql> use netqosportal; 

      mysql> select OwnerItemID,ItemID,ItemName from t_interface where ItemName != AlternateName INTO OUTFILE '/tmp/interface_alias_import.csv' FIELDS TERMINATED BY ','; 

      mysql> \q 

  3. Run following utility for update all unmatched info. 

    # cd /opt/CA/PerformanceCenter/Tools/bin 

    # ./update_alias_name.sh -h <CAPC_HOSTNAME> -T interface -u admin -p admin -i /tmp/interface_alias_import.csv

Additional Information

Further information on the  "update_alias_name.sh" script can be found in the following section of our TechDocs guides:

TechDocs : DX NetOps 21.2 CAPM : Set Device Alias Names Using the Devices Web Service