Duplicate or copy "SNMP - Interface Statistics" data query

[ellerbrockr]

I am using v0.8.7i and have been trying to find a way to duplicate the entire "SNMP - Interface Statistics" data query. The reason for this is that I have an environment with equipment from lots of different vendors. Some vendors place interface descriptions in ifAlias, some use ifDescr. I know that I can go and add ifDescr to each data template item, but I will need to change the data template each time I create a new device to graph depending on what vendor the device is for.

Or is there another way without having to manually recreate the entire data query, or having the abillity to be more flexible with what description is used for the graph title?

[gandalf]

Handling different title rules is explained at 1st link of my sig in the SNMP Data Query walkthrough. This might help already
R.

[ellerbrockr]

Sorry to dig up an old post, but I am still struggling with this issue. All the solutions that I know of just don't work for me.

I created a large number of devices using the "Host Template->Generic SNMP-enabled host" method. This template uses the SNMP ifName mib value for graph titles. Obviously changing this template does nothing for existing graphs. Changing the "Use per graph value" of the graph title is also not an option as this then promptly messes up 1000's of graph titles, some that may have been set manually. I also don't want to change the host template as I have a combination of devices that use ifName and some ifAlias.

So I went and manually duplicated the entire "SNMP - Interface Statistics" data query template and called it "SNMP - Interface Statistics (ifAlias)". Within this template I use ifAlias for the title (|host_description| - Traffic - |query_ifAlias|). Creating a new device has the desired effect and the titles are correctly using ifAlias. I then went to an existing device and tried to change the associated Host Template. Now I have two data queries associated with the host. Not quite what I had in mind, so I delete the wrong data query and "Re-apply suggested names". Now I get interface descriptions as follows - "host - Errors - |query_ifName|". query_ifName does not get filled in and appears in the graph title unresolved!!!

I then poked around in the databases to try and figure out how the linkage works between the various tables to see if I can update the database manually, but no joy.

So my question is:

How do I change/update a devices Host Template to force a title change to existing graphs. I don't want to fiddle with turning on/off "Use per graph" for 100's of devices. Changing the host template on an existing device does not work. Changing 1000's of individual graphs by hand is not an option (they anyway get changed again if "re-apply suggested names" is used. Using the cli tools also did not work.

I am using 0.8.7i and have not bothered upgrading as the release notes for 8.8.8 do not indicate any changes in the way title descriptions work.

Any help will be appreciated. Thanks.