[HOWTO] Color coded percent utilization

[nduda78]

I get this,

ERROR: STACK must follow AREA, LINE or STACK

[hcharde]

Helle everybody,

is this template working by one of you correctly? Could she or he upload the correct files which were needed?

Thanks in advance

regards,
christian

[jay]

Hi

I'm having some issues with the percent value on the y axis of my graph. I used instructions from both SRy and jas0420. I imported the graph template from jas0420 and made some changes to allow me to plot the outbound traffic on the negative axis. I used the CDEF from SRY to allow me to plot inbound on the positive and outbound on the negative. The problem i see is that the y axis shows me the value in M and is showing me the amount of traffic not the % of traffic. I have looked around the forums and also checked RRD website but can't seem to solve this. Can anyone help me at all??

I'm wondering if its anything to do with using a negative axis to plot the graphs as i noticed that SRY graphs were the same as mine. I imported jas0420 graph template and renamed. I created a graph using this and the y axis showed me the value as a percent. This is plotting both in and outbound on the positive axis.



Here is the view of the graph so you can see what i mean. I have also attached my graph template view.




Regards

Jay

[dogfart]

Hi I am not an expert in this I try to setup this to work
I have done all like in manual but get an silly error

Something with rrdtools

RRDTool Says:

sh: line 1: ,/,100,*,8,*,90,GT,NEGINF,UNKN,IF,UNKN,IF: No such file or directory

I thing the problem is with rrd.php so I go on post that is in the begining of the manual and take modified rrd.php After this

RRDTool Says: OK

But there is no any graphs. Also old graphs with bits/in/out is gone.

What colud be a problem?

[gandalf]

Please click on the rwnech next to the failing graph and post the complete rrdtool graph statement
Reinhard

[dogfart]

/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Circuit Utilization - Summary - |query_ifDescr|" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="Percent" \
--slope-mode \
CDEF:cdefa=a,|query_ifSpeed|,/,100,*,8,* \
CDEF:cdefb=a,|query_ifSpeed|,/,100,*,8,* \
CDEF:cdefc=a,b,+,|query_ifSpeed|,/,100,*,8,*,10,LE,a,b,+,|query_ifSpeed|,/,100,*,8,*,0,GT,NEGINF,UNKN,IF,UNKN,IF \
CDEF:cdefd=a,b,+,|query_ifSpeed|,/,100,*,8,*,30,LE,a,b,+,|query_ifSpeed|,/,100,*,8,*,20,GT,NEGINF,UNKN,IF,UNKN,IF \
CDEF:cdefe=a,b,+,|query_ifSpeed|,/,100,*,8,*,50,LE,a,b,+,|query_ifSpeed|,/,100,*,8,*,40,GT,NEGINF,UNKN,IF,UNKN,IF \
CDEF:cdeff=a,b,+,|query_ifSpeed|,/,100,*,8,*,70,LE,a,b,+,|query_ifSpeed|,/,100,*,8,*,60,GT,NEGINF,UNKN,IF,UNKN,IF \
CDEF:cdefg=a,b,+,|query_ifSpeed|,/,100,*,8,*,90,LE,a,b,+,|query_ifSpeed|,/,100,*,8,*,80,GT,NEGINF,UNKN,IF,UNKN,IF \
CDEF:cdefh=a,b,+,|query_ifSpeed|,/,100,*,8,*,20,LE,a,b,+,|query_ifSpeed|,/,100,*,8,*,10,GT,NEGINF,UNKN,IF,UNKN,IF \
CDEF:cdefi=a,b,+,|query_ifSpeed|,/,100,*,8,*,40,LE,a,b,+,|query_ifSpeed|,/,100,*,8,*,30,GT,NEGINF,UNKN,IF,UNKN,IF \
CDEF:cdefj=a,b,+,|query_ifSpeed|,/,100,*,8,*,60,LE,a,b,+,|query_ifSpeed|,/,100,*,8,*,50,GT,NEGINF,UNKN,IF,UNKN,IF \
CDEF:cdefba=a,b,+,|query_ifSpeed|,/,100,*,8,*,80,LE,a,b,+,|query_ifSpeed|,/,100,*,8,*,70,GT,NEGINF,UNKN,IF,UNKN,IF \
CDEF:cdefbb=a,b,+,|query_ifSpeed|,/,100,*,8,*,5000,LE,a,b,+,|query_ifSpeed|,/,100,*,8,*,90,GT,NEGINF,UNKN,IF,UNKN,IF \
CDEF:cdefbe=a,8,* \
CDEF:cdefce=a,8,* \
AREA:cdefa:"" \
AREA:cdefb:"":STACK \
AREA:cdefc#3ACE0C:" 0 - 10%":STACK \
AREA:cdefd#99FF99:"20 - 30%":STACK \
AREA:cdefe#FFFF00:"40 - 50%":STACK \
AREA:cdeff#FF8C1A:"60 - 70%":STACK \
AREA:cdefg#FF3333:"80 - 90%\n":STACK \
AREA:cdefh#00FF00:"10 - 20%":STACK \
AREA:cdefi#FFFF80:"30 - 40%":STACK \
AREA:cdefj#FFA54C:"50 - 60%":STACK \
AREA:cdefba#FF5F00:"70 - 80%":STACK \
AREA:cdefbb#FF0000:"90 - 100%\n":STACK \
COMMENT:"CIRCUIT SPEED\: |query_ifSpeed| bits per second\n" \
COMMENT:"INBOUND TRAFFIC RATE" \
GPRINT:cdefbe:AVERAGE:" Avg\:%8.2lf%s" \
GPRINT:cdefbe:MIN:"Min\:%8.2lf%s" \
GPRINT:cdefbe:MAX:"Max\:%8.2lf%s" \
GPRINT:cdefbe:LAST:"Current\:%8.2lf%s\n" \
COMMENT:"INBOUND TRAFFIC %" \
GPRINT:cdefa:AVERAGE:" Avg\:(%5.2lf %%)" \
GPRINT:cdefa:MIN:"Min\:(%5.2lf %%)" \
GPRINT:cdefa:MAX:"Max\:(%5.2lf %%)" \
GPRINT:cdefa:LAST:"Current\:(%5.2lf %%)\n" \
COMMENT:"OUTBOUND TRAFFIC RATE" \
GPRINT:cdefce:AVERAGE:"Avg\:%8.2lf%s" \
GPRINT:cdefce:MIN:"Min\:%8.2lf%s" \
GPRINT:cdefce:MAX:"Max\:%8.2lf%s" \
GPRINT:cdefce:LAST:"Current\:%8.2lf%s\n" \
COMMENT:"OUTBOUND TRAFFIC %" \
GPRINT:cdefb:AVERAGE:" Avg\:(%5.2lf %%)" \
GPRINT:cdefb:MIN:"Min\:(%5.2lf %%)" \
GPRINT:cdefb:MAX:"Max\:(%5.2lf %%)" \
GPRINT:cdefb:LAST:"Current\:(%5.2lf %%)\n" \
COMMENT:"TOTAL DATA MOVED" \
COMMENT:" Inbound\: 0 bytes" \
COMMENT:"Outbound\: 0 bytes"
RRDTool Says:

sh: line 1: ,/,100,*,8,*,90,GT,NEGINF,UNKN,IF,UNKN,IF: No such file or directory

[gandalf]

There aren't any DEFs (=data sources) in there. Please check your graph items to refer to the proper data sources
Reinhard

[lorcs]

Hi,

The initial post on the colored percentage graph the sum of inbound+outbound traffic . Is it possible to graph inbound and outbound on both positive and negative axis in the percentage scale instead of true traffic rate ? How to do this ?

Best Regards

Ray

[jay]

Hi

I would also like to know how to plot the graph as a percentage. I posted to this forum (see above) but have had no response as of yet.

Jay

[SRY]

Hi Jay,

I have not been in the forum for a while, pressure of work and all that.

The CDEFs that I posted repored the real value but colour coded them by utilisation if you want to plot utilisation and colour code it you need to modify the CDEFs to generate a plot value that is a percentage. Can you post your CDEFs and I can take a look or are they the same as my original post?

Cheers

[jay]

Hi Sry

No worries. I know how you feel. I'm only able to spend some more time on Cacti and the forums as we are moving service providors for our global WAN.

I used the CDEFS that you posted. I wasn't able to import the template if i remember so i had to create the templates myself. Luckily you posted screen shots so i could see how you set it up. I noticed that you screen shot also showed the real values on the y axis rather than a percentage.

Here is the output showing the cdefs and other graph template info.


c:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-60 \
--title="CSIDUB1 - Circuit Utilization - Se0/0" \
--base=1000 \
--height=120 \
--width=550 \
--upper-limit=1000 \
--lower-limit=0 \
--vertical-label="Percent" \
--slope-mode \
DEF:a="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:b="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:c="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:d="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:e="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:f="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:g="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:h="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:i="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:j="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:ba="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_in:LAST \
DEF:bb="C\:/Apache2/htdocs/cacti/rra/csidub1_traffic_in_807.rrd":traffic_out:LAST \
CDEF:cdefa=ba,1984000,/,100,*,8,* \
CDEF:cdefc=a,1984000,/,100,*,8,*,10,LE,a,1984000,/,100,*,8,*,0,GT,a,8,*,UNKN,IF,UNKN,IF \
CDEF:cdefd=a,1984000,/,100,*,8,*,20,LE,a,1984000,/,100,*,8,*,10,GT,a,8,*,UNKN,IF,UNKN,IF \
CDEF:cdefe=a,1984000,/,100,*,8,*,30,LE,a,1984000,/,100,*,8,*,20,GT,a,8,*,UNKN,IF,UNKN,IF \
CDEF:cdeff=a,1984000,/,100,*,8,*,40,LE,a,1984000,/,100,*,8,*,30,GT,a,8,*,UNKN,IF,UNKN,IF \
CDEF:cdefg=a,1984000,/,100,*,8,*,50,LE,a,1984000,/,100,*,8,*,40,GT,a,8,*,UNKN,IF,UNKN,IF \
CDEF:cdefh=a,1984000,/,100,*,8,*,60,LE,a,1984000,/,100,*,8,*,50,GT,a,8,*,UNKN,IF,UNKN,IF \
CDEF:cdefi=a,1984000,/,100,*,8,*,70,LE,a,1984000,/,100,*,8,*,60,GT,a,8,*,UNKN,IF,UNKN,IF \
CDEF:cdefj=a,1984000,/,100,*,8,*,80,LE,a,1984000,/,100,*,8,*,70,GT,a,8,*,UNKN,IF,UNKN,IF \
CDEF:cdefba=a,1984000,/,100,*,8,*,90,LE,a,1984000,/,100,*,8,*,80,GT,a,8,*,UNKN,IF,UNKN,IF \
CDEF:cdefbb=a,1984000,/,100,*,8,*,5000,LE,a,1984000,/,100,*,8,*,90,GT,a,8,*,UNKN,IF,UNKN,IF \
CDEF:cdefbc=bb,1984000,/,100,*,8,* \
CDEF:cdefbe=b,1984000,/,100,*,8,*,10,LE,b,1984000,/,100,*,8,*,0,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF \
CDEF:cdefbf=b,1984000,/,100,*,8,*,20,LE,b,1984000,/,100,*,8,*,10,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF \
CDEF:cdefbg=b,1984000,/,100,*,8,*,30,LE,b,1984000,/,100,*,8,*,20,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF \
CDEF:cdefbh=b,1984000,/,100,*,8,*,40,LE,b,1984000,/,100,*,8,*,30,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF \
CDEF:cdefbi=b,1984000,/,100,*,8,*,50,LE,b,1984000,/,100,*,8,*,40,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF \
CDEF:cdefbj=b,1984000,/,100,*,8,*,60,LE,b,1984000,/,100,*,8,*,50,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF \
CDEF:cdefca=b,1984000,/,100,*,8,*,70,LE,b,1984000,/,100,*,8,*,60,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF \
CDEF:cdefcb=b,1984000,/,100,*,8,*,80,LE,b,1984000,/,100,*,8,*,70,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF \
CDEF:cdefcc=b,1984000,/,100,*,8,*,90,LE,b,1984000,/,100,*,8,*,80,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF \
CDEF:cdefcd=b,1984000,/,100,*,8,*,5000,LE,b,1984000,/,100,*,8,*,90,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF \
CDEF:cdefcg=ba,8,* \
CDEF:cdefdb=ba,1984000,/,100,*,8,* \
CDEF:cdefdg=bb,8,* \
CDEF:cdefeb=bb,1984000,/,100,*,8,* \
LINE1:cdefa#C0C0C0:"" \
COMMENT:"InBound" \
AREA:cdefc#009000:" 0 - 10%" \
AREA:cdefd#00C000:"10 - 20%" \
AREA:cdefe#00F800:"20 - 30%" \
AREA:cdeff#FFFF58:"30 - 40%" \
AREA:cdefg#FFF000:"40 - 50%" \
AREA:cdefh#FFB800:"50 - 60%" \
AREA:cdefi#FFA000:"60 - 70%" \
AREA:cdefj#FF6000:"70 - 80%" \
AREA:cdefba#D80000:"80 - 90%" \
AREA:cdefbb#B80000:"90 - 100%\n" \
LINE2:cdefbc#C0C0C0:"" \
COMMENT:"OutBound" \
AREA:cdefbe#009000:"0 - 10%" \
AREA:cdefbf#00C000:"10 - 20%" \
AREA:cdefbg#00F800:"20 - 30%" \
AREA:cdefbh#FFFF58:"30 - 40%" \
AREA:cdefbi#FFFF00:"40 - 50%" \
AREA:cdefbj#FFB800:"50 - 60%" \
AREA:cdefca#FFA000:"60 - 70%" \
AREA:cdefcb#FF6000:"70 - 80%" \
AREA:cdefcc#D80000:"80 - 90%" \
AREA:cdefcd#B80000:"90 - 100%\n" \
COMMENT:"CIRCUIT SPEED\: 1984000 bits per second\n" \
COMMENT:"INBOUND TRAFFIC RATE" \
GPRINT:cdefcg:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefcg:AVERAGE:"Avg\:%8.2lf %s" \
GPRINT:cdefcg:MIN:"Min\:%8.2lf %s" \
GPRINT:cdefcg:MAX:"Max\:%8.2lf %s\n" \
COMMENT:"INBOUND TRAFFIC %" \
GPRINT:cdefdb:LAST:" Current\:(%5.2lf %%)" \
GPRINT:cdefdb:AVERAGE:" Avg\:(%5.2lf %%)" \
GPRINT:cdefdb:MIN:" Min\:(%5.2lf %%)" \
GPRINT:cdefdb:MAX:"Max\:(%5.2lf %%)\n" \
COMMENT:"OUTBOUND TRAFFIC RATE" \
GPRINT:cdefdg:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefdg:AVERAGE:"Avg\:%8.2lf %s" \
GPRINT:cdefdg:MIN:"Min\:%8.2lf %s" \
GPRINT:cdefdg:MAX:"Max\:%8.2lf %s\n" \
COMMENT:"OUTBOUND TRAFFIC %" \
GPRINT:cdefeb:LAST:" Current\:(%5.2lf %%)" \
GPRINT:cdefeb:AVERAGE:"Avg\:(%5.2lf %%)" \
GPRINT:cdefeb:MIN:"Min\:(%5.2lf %%)" \
GPRINT:cdefeb:MAX:"Max\:(%5.2lf %%)\n" \
COMMENT:"TOTAL DATA MOVED" \
COMMENT:" Inbound\: 2.32 GB" \
COMMENT:"Outbound\: 2.11 GB\n" \
COMMENT:"|host_description| - Serial0/0 - |query_ifAlias|\n" \
COMMENT:"Last Poll\: Wed 29 Mar 10\:10\:35 BST 2006\n"


Jay

[jay]

Sry

Have you ever tried to add existing data sources (the traffic in and out Data sources) to this template. I'm currently trying to add a existing DS (traffic in and out ds) to this template. The G Print information seems to be correct but the graph itself shows the same data in and outbound. It looks to be picking up the inbound traffic and plotting it on the outbound plot as well.

I can attach a screenshot of the graph and also the graph properties if you want me too. I haven't attached it in case you have an easy answer for me.

Regards

Jay

[jay]

Sry
I have also noticed that when you look at the graph under the graph management it only uses on data source. It shows 2 DS fields but only the traffic_in uses a DS. The traffic_out uses none as its DS. This is for all new graphs i created. Is this correct???

Jay

[SRY]

Jay

The CDEFs that you defined:

b,1984000,/,100,*,8,*,10,LE,b,1984000,/,100,*,8,*,0,GT,b,8,*,-1,*,UNKN,IF,UNKN,IF

As you look at the line the value "b" is used three times, the last "b" is for the value that is plotted which is then multiplied by 8 and then it this case by -1 which turns it into a negative value so you need to change this to "b,1984000,/,100,*,8,*,-1,*" instead of "b,8,*,-1,*". The value of "b" in my graphs was displayed in bits and not bytes hence the 8,* you may not need this calculation for the utilisation but try it out and see.

I hasten to add that I have not tested this yet but the logic should work.

As for the data sources I had the same issue but just modified it for each of the graphs I deployed, under graph management I selected the graph and modified the inbound and outbound entries. For the number of graphs that I needed, less than 50, i just did it manually.

Cheers

[jay]

Sry

So i would need to add the following |query_ifSpeed|,/,100,*,

E.G

a,|query_ifSpeed|,/,100,*,8,*,10,LE,a,|query_ifSpeed|,/,100,*,8,*,0,GT,a,|query_ifSpeed|,/,100,*,8,*,UNKN,IF,UNKN,IF

Then add the same line for each CDEEF?


I have just tried to add the DS to the output field under graph management. It now shows symetrical data in and outbound. This is not right. There are a total of 5 DS within the DS tab for this device. When i pull the drop down menu i see 10 one for in and one for out for each interface. The input field originall showed the input DS. I then added the output DS to the output field, this caused symetrical data on the graph. i went back to Graph management and its using the same DS for in and out.

Any ideas???

I have attached the 2 screen shots. YOu can see the original graph plotted the data correctly.

Jay