UPDATED: APC Graphs plus Amperage used Calculation

[rhettardo]

Hello.
I have attached some screen shots of the APC templates I have made. I am willing to share but not sure of if people will be interested since what I have to offer is already mostly available. Please review and let me know what you think. The only thing I can think of that I have left out is humidity on the temperature graph (I am using an AP9619 w/ Temp probe and not Temp+Humidity).

UPDATE 2009-07-28:

I've made a graph/cdef to estimate your AMP usage for people who need to know relatively how much power they are using in their rack. How I get this value is take the load value divide by the VA rating then divide by the input voltage.

The only problem with this is that in the CDEF I could not think of a way to dynamically get the VA rating of the UPS since its not listed in the Powetnet MIB. Therefore I manually added it into the CDEF.

CDEF: cdef=a,3,*,10,*,e,/

The 3 in the CDEF represents the VA rating on the UPS in thousands (i.e. 3 means this is an 3000VA ups).

[streaker69]

Here's the way the temp conversion CDEF's should be. Don't know why your graphs 'wouldn't respond' to them.

[rhettardo]

streaker69,
Thanks for the info. I am quite new to all of this and trying to learn everything through osmosis.

Below is the cdef I made and currently use though I will try you example.

[Dacob9906]

I would be very interested in the templates. The ones that I currently use, lack some of the info yours have, such as the remaining runtime... which I have wanted for a long time, and haven't been able to find ones that could run on a windows box... I'm hoping these will If you could link them up, that would be great! Thank you.

[Dacob9906]

I would be very interested in the templates. The ones that I currently use, lack some of the info yours have, such as the remaining runtime... which I have wanted for a long time, and haven't been able to find ones that could run on a windows box... I'm hoping these will If you could link them up, that would be great! Thank you.

[variable]

this would be useful here as well.

[rafiso]

HI!

Yes please I want your files to try them on my APC 1400 !!!

Thanks you to share

[rhettardo]

All,
Here is the host template. The only thing missing is a field for humidity since I personally dont have the humidity sensor. I can easily add this though.

[rafiso]

Ok great thanks !!!

I imported the xml file then I added a device with the Host Template "APC UPS". I can add the 3 graphs but there's no Associated Data Queries : "No associated data queries", so of course the graph will be empty :-/

Do you have any idea of the problem ? Thanks you again!! Nice work !

[rafiso]

Ok I have 2 graphs that seems to work. Can I change the temp in Celcius ? :=)

The graph APC Statistics is not working actually. In debug mode I have :

Code: Select all

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="ups - APC Statistics" \
--base=1000 \
--height=150 \
--width=600 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
--slope-mode \
--font TITLE:10: \
--font AXIS:6: \
--font LEGEND:8: \
--font UNIT:6: \
DEF:a="/var/www/html/website/protected/cacti/rra/ups_apc_charge_53.rrd":apc_charge:AVERAGE \
DEF:b="/var/www/html/website/protected/cacti/rra/ups_apc_charge_53.rrd":apc_charge:MAX \
DEF:c="/var/www/html/website/protected/cacti/rra/ups_apc_runtime_56.rrd":apc_runtime:AVERAGE \
DEF:d="/var/www/html/website/protected/cacti/rra/ups_apc_runtime_56.rrd":apc_runtime:MAX \
DEF:e="/var/www/html/website/protected/cacti/rra/ups_apc_load_55.rrd":apc_load:AVERAGE \
DEF:f="/var/www/html/website/protected/cacti/rra/ups_apc_load_55.rrd":apc_load:MAX \
DEF:g="/var/www/html/website/protected/cacti/rra/ups_apc_batt_status_54.rrd":apc_batt_status:LAST \
DEF:h="/var/www/html/website/protected/cacti/rra/ups_apc_batt_status_54.rrd":apc_batt_status:MAX \
CDEF:cdefg=c,6000,/ \
LINE1:a#2175D9FF:""  \
AREA:a#00A0C1FF:"Charge Percent"  \
GPRINT:a:LAST:"Current%8.2lf %s"  \
GPRINT:a:MIN:"Min%8.2lf %s"  \
GPRINT:a:AVERAGE:"Average%8.2lf %s"  \
GPRINT:b:MAX:"Max%8.2lf %s\n"  \
LINE1:cdefg#FF5700FF:""  \
AREA:cdefg#EA8F00FF:"Runtime"  \
GPRINT:cdefg:LAST:"       Current%8.2lf %s"  \
GPRINT:cdefg:MIN:"Min%8.2lf %s"  \
GPRINT:cdefg:AVERAGE:"Average%8.2lf %s"  \
GPRINT:d:MAX:"Max%8.2lf %s\n"  \
LINE1:e#FF3932FF:""  \
AREA:e#FF410599:"Load"  \
GPRINT:e:LAST:"          Current%8.2lf %s"  \
GPRINT:e:MIN:"Min%8.2lf %s"  \
GPRINT:e:AVERAGE:"Average%8.2lf %s"  \
GPRINT:f:MAX:"Max%8.2lf %s\n"  \
LINE1:g#FAFD9EFF:"Battery Status"  \
GPRINT:g:LAST:"Current%8.2lf %s"  \
GPRINT:h:MIN:"Min%8.2lf %s"  \
GPRINT:h:MAX:"Max%8.2lf %s\n"  \
COMMENT:"-\n"  \
COMMENT:"Battery Status 1 = Good, 2 = Change" 

RRDTool Says:

ERROR: the RRD does not contain an RRA matching the chosen CF

[rhettardo]

Here are the C versions. The only difference between these and the previous posted are the lack of a CDEF for converting C to F in the temp graph.

[rhettardo]

here is a screenshot of the cdef I currently have in place thanks to streaker69.

[rafiso]

Okay it's working. I imported the xml and I changed the option at the bottom to import "Use custom RRA settings from the template". I'll let them run for a few hour now.

Thanks again amazing job!!

[jug]

Hello,

maybe I'm doing something wrong but I tried to import your templates into cacti version 0.8.6[jk] and 0.8.7a and it always gives me a HASH error. With what version of Cacti did you export the Templates?

[rhettardo]

Jug,
I exported from .8.7b.