Update CA Performance Management interface name alias

Products

• CA Infrastructure Management
• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• CA Performance Management - Data Polling

Issue/Introduction

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

 

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.

Resolution

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/