ifAlias Problem

[HCT]

I have problem related to the interface alias.
I had added at the "Data Queries" to dispaly the interface Alias as Graph Title
but the problem is what if i changed the interface alias is there any way to automaticaly update the Graph title with the new Alias . Thanks

[gandalf]

AFAIK, there is no automatism. You may click on the green circle next to the Data Query to update. Perhaps the Reindex Method could help? Not sure on this. AFAIK, there is no chance to get Reindex Method changed via gui for already generated Data Queries (but changing MySQL tables directly would be an option, but be careful...)
Reinhard

[patrickdaj]

Any ideas on how this can be accomplished in the database.

[patrickdaj]

Find the host_id in the hosts table maybe by doing 'select host_id from host where description like '%(part of host desc)%''. The % signs are necessary but the parenthesis are not. I did 'select host_id from host where description like '%tempe%''.

Using some mysql client that has the rights to modify the cacti database run 'delete from host_snmp_cache where host_id=28'. 28 was the host_id for the switch I wanted to update.

Go into Devices -> Create Graphs. The Data Queries should be blank now. So run the query for the interfaces with the debug link.

After that your graph titles and names should be fixed automatically.