Custom report showing weekly Average/Max valuesfor CPU/RAM/SWAP/Availability

[Alex Dehaini]

What exactly are you looking for?

On Wed, May 27, 2009 at 10:01 AM, Ayotunde Itayemi <
Ayotunde.Itayemi at zain.com> wrote:

> Hi,
> Thanks for the response. I will look into the RRDTool command line
> option.
> Yes, I am using NDOUTILS. I have actually examined a few of the tables
> and it looks like the base values that can be manipulated are in there
> (somewhere :-).
> I have looked at the NAGIOS email reporter and it's not what I want. In
> fact, I have implemented the same thing it does myself - i.e., query the
> standard NAGIOS cgis. The issue with this output is that what you get
> from the CGIs are not the performance data values, but the percentage of
> the time a particular measurement is over the warning/critical
> threshold.
> By the way, are there comprehensive entity-relationship type diagrams
> for the tables making up the NDOUTILS tables anywhere?
>
> Thanks.
> "This mail is from a Gimper"
>
> -----Original Message-----
> From: Marc Powell [mailto:marc at ena.com]
> Sent: Tuesday, May 26, 2009 10:04 PM
> To: Nagios Users Mailinglist
> Subject: Re: [Nagios-users] Custom report showing weekly Average/Max
> valuesfor CPU/RAM/SWAP/Availability
>
> On May 26, 2009, at 3:25 PM, Ayotunde Itayemi wrote:
>
> > 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)
>
> I don't use PNP but I expect this will be work for you unless it has
> built-in reporting for this (I don't believe it does). I would
> encourage you to learn more about how RRDTool works by reading the
> Documentation and Tutorials at
> http://oss.oetiker.ch/rrdtool/index.en.html
> . That will give you a good basis for the concepts you will need to do
> do this. To obtain the textual values for these parameters, you'll
> need to use the command-line rrdtool program to fetch the values from
> the rrd files directly. rrdtool can fetch the AVERAGE value at each
> stored point during the week and you'll need to add those up and
> divide by the number of values to determine the single average value
> (man rrdfetch). You could also pick the MAX value from that output or
> maybe PNP also includes a MAX rra you can fetch.
>
> > 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)
>
> Nagios Email Reporter might be the ticket here.
>
> >
> > 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.
>
> There are no databases or tables to query unless you're using NDOUtils
> and even then, getting this information wouldn't be trivial, IMHO.
>
> --
> Marc
>
>
> ------------------------------------------------------------------------
> ------
> 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 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
>
>
> ------------------------------------------------------------------------------
> 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 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
>



-- 
Alex Dehaini
Developer
Site - www.alexdehaini.com
Email - alexdehaini at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090527/bf32dab4/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