Tree enhancements for group by "Data Query Index"

[moonman]

This is a patch for 0.8.6e that add few enhancements to the tree view group by "Data Query Index"
that are most useful for large installation with a lot of interfaces.

1. you can specify the order of the graphs in tree view when you group by "Data Query Index"
for example in normal tree if you have graphs for traffic error and unicast packets the order will be alphabetic like
error
traffic
unicast packets
with my patch you can add value of 10 to the order in the errors Graph Template
then because the default order of the other templates are 0 the graphs will display in this order
traffic
unicast packets
errors

2. this enhancement display the text you add after the default graph title of traffic graphs "|host_description| - Traffic - |query_ifName|"
for example if the title in the graph management is "|host_description| - Traffic - |query_ifName| To XYZ"
in the graph tree you will see it like "GigabitEthernet3/1 To XYZ"

3. Tree grouping by interfaces name for example if you have host with 200 interfaces you dont want all of them in one branch
but with my patch the interfaces are grouped by interface name for example

Host:Router
-SNMP - Interface Statistics
--From GigabitEthernet1
---GigabitEthernet1/1
---GigabitEthernet1/2
---GigabitEthernet1/3
--From GigabitEthernet3
---GigabitEthernet3/1
---GigabitEthernet3/4
---GigabitEthernet3/5

you can specify the "Max Leafs In Branch" in the setting tab for each user (the default is 10)
and by that if you have host with only 8 interfaces it will not grouped like I mention before

for the patch to work you need to run these commands in the mysql shell

ALTER TABLE `graph_templates_graph` ADD `graph_order` MEDIUMINT( 8 ) NOT NULL ,
ADD `t_graph_order` CHAR( 2 )

I will be happy to see it in cacti 0.9

Nitzan

[moonman]

I dont see that you use it
but here is a new patch that fix some bugs in the tree grouping

Nitzan

[lga]

Hi,


I'm really interested by your idea but can you create a patch for 0.8.6h cacti version ? and the explanation how to apply this one ?

We use Cisco Catalyst 65xx with more than 350 interfaces

Thks in advance,

Lionel.