[HOWTO] How can I make SUM of graphs

Big_Tummy · Joined: 01 Sep 2003 Posts: 1

Hello All,

I'm newbie on CACTI.

Is it possible to make SUM on CACTI?

If yes, how can I do it?

Regards,

raX · Posted: Mon Sep 01, 2003 11:49 am Post subject:

Yes, this is possible with the latest version of Cacti. It is described in a bit more detail in the following page of the manual under "Bandwidth Summation".

If you are a new user of Cacti, the easiest way to create graphs with a sum already on them is to:

1) Go to "Polling Hosts" in Cacti.
2) Either add a new host or edit a host that contains traffic you want to sum up.
3) Make sure you have the "SNMP - Interface Statistics" data query selected by selecting "SNMP - Interface Statistics" under "Associated Data Query" and clicking "Add".
4) Place a checkbox next to the interfaces you want to create summation graphs for.
5) Click on the dropdown that says "In/Out Bits" and select "In/Out Bytes with Total Bandwidth".
6) Once you click save, you should have some graphs that contain summation data on them

.

The following set of instructions assumes that you want to sum up traffic, which is most often the case. You are not limited to this however. The instructions provided in the manual should work for any type of data.

-ian

Guest · Posted: Wed Sep 03, 2003 10:16 am Post subject:

raX · Posted: Wed Sep 03, 2003 11:28 pm Post subject:

More than likely your installation is just fine. You will only see this option for new installations of version 0.8.3a, not for upgrades from previous versions. This is intentional as I try to refrain from messing with a user's database too much during an upgrade. One of the features coming up in the next version will allow you to export/import this kind of thing to/from an XML file to share with others.

If you want bandwidth summation on your graphs, you will have to modify your traffic template manually. Here is a good working variable:

Fred · Cacti User Joined: 03 Jan 2003 Posts: 78

atrocity · Joined: 26 Aug 2003 Posts: 18

Hello,

I followed Rax's HowTo for the summation, but it's not working for me ....
I deleted everything (my rra files also ;( ) and re-install Cacti from scratch. Then i followed the HowTo, without success...
Can some one help me ?
Thanks
Best regards
Jean

raX · Posted: Mon Sep 08, 2003 11:40 pm Post subject:

TFC · Posted: Tue Sep 09, 2003 1:47 am Post subject:

TFC · Posted: Tue Sep 09, 2003 2:03 am Post subject:

raX · Posted: Wed Sep 10, 2003 6:36 pm Post subject:

You don't want to include the parenthesis in the variable. Instead, you should use:

smartinez · Joined: 13 Mar 2003 Posts: 21 Location: Austin, Texas

While on the topic of summation...

We have a Cisco 6513 that hosts multiple groupings of servers. For example, ports 1 - 5 terminate 5 servers that belong to one group (group1), ports 6 - 10 terminate 5 servers that belong to another group (group2), etc.

I want to take the total throughput of group1 and the total throughput of group2 and graph them together on one graph.

As a test, I used the "Total All Data Sources" found in the "Graph Items" section to create a total of ports 1 - 5 and it worked great. I got a graph that shows all 5 interfaces plus a 6th line that is the total of all 5.

So, I want to take that 6th line and the 6th line of the second graph and combine only those 2 on one graph.

Am I trying accomplish something out of the scope of Cacti?

I tried to use the "Bandwidth Summation" process listed below but what I got was individual interface graphs with the sum of all graphs listed at the bottom of each graph.

Thanks for all your assistance!

-Samson

raX · Posted: Sun Sep 14, 2003 4:59 pm Post subject:

Trying to combine the "Total All Data Sources" which is CDEF based and the bandwidth summation which is variable based will not work. The main difference is that RRDTool handles the CDEFs, while Cacti handles any graph variables such as 95th percentile and bandwidth summation. The only way to do this would be to add a graph variable called "total all data sources", which would be much slower than the RRDTool way.

-Ian

atrocity · Joined: 26 Aug 2003 Posts: 18

raX · Posted: Sun Sep 14, 2003 6:02 pm Post subject:

atrocity · Joined: 26 Aug 2003 Posts: 18

ehm, excuse my stupid question, but this summation, is it IN the graphs ?
If yes, then it's ok ... it's working.
But what i really want, is the possibility to put tables, with the summary of the trafic in numbers...
I have a nice PHP script, that can summarize the trafic. You can choose to see the results for a period of days, or for a whole mounth, also a year if you collected the data... Really, i will appreciate if something like that can be done in Cacti, because actually i continue to use MRTG, only for that feature ....
I will be more then happy to share this script, if someone think that it can be used / converted to and for Cacti

Jean