Update CA Performance Management interface name alias

Document ID : KB000015274
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Old CAPC Interface Alias name information remains though the Network Interface name and Description field updated when device configuration changed. 

 

Question:

The client manages huge network interface and cannot examine which had mismatching.

So they request the method of updating the renewing all old Interface Alias. 

 

Environment:
This problem generated before CA Performance Center 3.1 version.
Answer:

1, Backup CAPC MySQL 

 

2, Extract the unmatched information between Network Interface name and Interface Alias name. 

  # /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:

About "update_alias_name.sh" :

https://docops.ca.com/ca-performance-management/2-7/en/building/manage-devices/set-alias-names-for-multiple-monitored-devices/