Custom report showing weekly Average/Max values for CPU/RAM/SWAP/Availability

[Ayotunde Itayemi]

Hi All,

I am currently monitoring several parameters on my clients (CPU, RAM,
Disk, availability, SWAP, etc)

I am also collecting performance data from the plug-ins which is being
used by PNP4nagios to create graphs.

 

I have a request from "management" for a single report (weekly on Monday
mornings at 9am) which shows the average and maximum values of each of
these parameters (at least CPU, RAM, SWAP) and Availability using a
single row per server. The duration for the report is the previous one
week (Monday 00:00 to Sunday 11:59PM)

 

I think it should be possible if one knows the right tables to query and
possibly how to string the right query together, but with very little
idea of the tables, their relationships (not to mention that I am not a
DBA) it's a very tall order for me.

 

Does anyone have a query that does a similar thing or even some script
or application?

 

Thanks.

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090526/612437f9/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT 
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & 
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian 
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com 
-------------- next part --------------
_______________________________________________
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