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.
------------------------------------------------------------------------------ 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
_______________________________________________ Nagios-users mailing list Nagios-users@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