Update CA Performance Management interface name alias

Article Id: 15274

Status: Published

Updated On: 14-02-2018 07:49

Legacy Id: TEC1118263

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/