Reporting bits and pieces.

[Stanley.Hopcroft at Dest.gov.au]

Dear Folks,

<Mainly off topic - related to Reporting>

Firstly some observations and corrections to my recent letters about
Reporting.

1 Use of DBD::RAM to at one fell swoop download the Nagios all
hosts/services report and stash it
  in an in-core table (prior to filtering with SELECT and saving in an
RDBMS).

DBD::RAM no longer builds. It has been replaced by DBD::AnyData.

>From the README of DBD::AnyDATA:

HISTORICAL NOTE: this module was formerly called DBD::RAM. Its name
was changed because many people were unaware that the module supports
file operations in addition to in-memory operations. See the Changes
file for a description of changes since the last release of DBD::RAM.

2 Another way of accounting for outages (apart from daily log file
parsing
or using avail.cgi directly) may be with an event handler that inserts
rows into a table with these columns 

HOST_NAME
HOST_DOWN
HOST_UP
OUTAGE

Since there are lot of good DB interfaces in various programming
languages
(Perl, Python, Ruby), this is pretty straight forward.

I only recently became aware of the $HOSTDOWNTIME$ macro that allows one
to
filter outages that are in scheduled downtime.

(At this low capability site, the event handler simply appends a row to 
a CSV file so that Excel can view/edit the data. While this is not great
it allows manual update with COMMENT and CAUSE [via Excel] so it allows
one in principal to combine problem analysis/resolution data with the
outage).

3 Would anyone like to post their Reporting schemas ?

</Mainly off topic - related to Reporting>

and now back to our usual 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