Hi and many thanks for this.
Just trying to fit this to my needs, I actually just want a text report, no graphs so I've changed it to:
for I in ls -1 TAB*/tcp.conn.rrd; do
echo dirname $I
rrdtool fetch $I MAX -r 900 -s "12am Mar 1" -e "12am Mar 27" | egrep
-v "nan|^ *sec$|^$"
done
Now, I know from looking at the graphs in Xymon that most of the TAB* devices have a "MAX" value, however "rrdtool fetch" says that at every interval, the value is "not a number".
Any ideas what I'm doing wrong?
Thanks
CC
On Fri, Mar 27, 2015 at 5:27 AM, J.C. Cleaver <cleaver at terabithia.org> wrote:
On Wed, March 25, 2015 6:35 pm, Colin Coe wrote:
Hi all
I've been asked to report on the usage of some devices (Windows 7 tablet computers). I have not installed any agents but I've had them in the hosts.cfg file for a couple of months.
All I need is to report on which devices have a 'conn' max of 0ms over 7, 14 and 28 days.
Any ideas how I can get this info in text format?
Well, it's definitely not *pretty*, but this (taken mostly from: http://stackoverflow.com/questions/15964917/get-a-max-number-in-a-certain-pe...) seemed to get the output needed from the raw RRD files:
[rhel6-x86-64 rrd]# for i in
ls */tcp.conn.rrd; do echo -n "${i} " ; rrdtool graph x -sdate +%s --date="1 week ago"DEF:v=${i}:sec:MAX VDEF:vm=v,MAXIMUM PRINT:vm:%lf ; done | perl -pe 's/0x0\s/= /sg' | sort -nr -k 3 centos3-i386.build/tcp.conn.rrd = 0.264434 b.resolvers.Level3.net/tcp.conn.rrd = 0.135559 centos4-i386.build/tcp.conn.rrd = 0.126232 rhel5-i386.build/tcp.conn.rrd = 0.118713 google-public-dns-a.google.com/tcp.conn.rrd = 0.063940 ns1.google.com/tcp.conn.rrd = 0.063380 a.resolvers.Level3.net/tcp.conn.rrd = 0.049894 google-public-dns-b.google.com/tcp.conn.rrd = 0.035567 rhel5-x86-64.build/tcp.conn.rrd = 0.016195etc...
That's a list of everything, then just filter out numerically as needed. (Uses GNU date, but can be substituted with any epoch start/end points.)
This is definitely an area where Xymon could use some improvement. The hostgraphs.cgi(1) script is a start, but there's a lot at the display layer that could be done to gather interesting data from RRD for searching, filtering, and report presentation.
HTH,
-jc