Update CA Performance Management interface name alias

book

Article ID: 15274

calendar_today

Updated On:

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/