Reporting and misc rave.

[Stanley.Hopcroft at Dest.gov.au]

Dear Folks,

I am writing with mainly a rant about Graphing and Reporting.

<Mainly OT rant>

1 About graphing with Nagios

Why would one bother when 

  1.1 Cacti does such a good job

  1.2 Nagios could check the Cacti RRDs with either check_rrd, or by an 
  outboard (Cron scheduled) RRD poller that submits passive service
check results

  1.3 the graphs can be associated with Nag service checks by either

   - explict URL of the Cacti graph in the service check output

   - for the adventurous, a Wiki front end that displays some of the 
     Nag CGI service status and a link to the Cacti graph. 

  As a footnote, since Cacti supports RRD 1.2 with built-in supported
  Holt Winters forecasting RRAs, the poller could be smart and simply
  check the exception Data store to see if the current rate is in fact
  outside the normal seasonal variation (computed by the Holt Winters
  algorithm inside the RRD).

  Of course this would require the modification of the RRDs that Cacti
produces
  to add the HW RRAs (this doesn't require that the RRD content be
unloaded and
  reloaded IIRC).

2 About reporting

After writing a lot of code in Nagios::Report to extract and report on
Nagios availability data it occurs to me that a better way of doing
Reporting
is to

  2.1 put the availability data in a DB table (prob with an
auto-incremented index)

  2.2 use either

    2.2.1 ad-hoc SQL queries, or

    2.2.2 the reporting package of your choice (eg iReport)

I hope that Nagios::Report will be enhance to take advantage of
DBD::Ram, a Perl
module that very easily gets a CSV file with LWP and sticks it in an in
core
DB that can almost as easily be used as a Data source to insert rows
into the
DB of your choice (MySQL, or whatever).

</Mainly OT rant>

and now back to our normal program.

Yours sincerely.


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null