Re: [Nagios-users] Custom report showing weekly Average/Max valuesfor CPU/RAM/SWAP/Availability
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:m...@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@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@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
Re: [Nagios-users] Custom report showing weekly Average/Max valuesfor CPU/RAM/SWAP/Availability
What exactly are you looking for? On Wed, May 27, 2009 at 10:01 AM, Ayotunde Itayemi ayotunde.itay...@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:m...@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@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@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 - alexdeha...@gmail.com -- 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
Re: [Nagios-users] Custom report showing weekly Average/Max valuesfor CPU/RAM/SWAP/Availability
On May 27, 2009, at 5:01 AM, Ayotunde Itayemi wrote: By the way, are there comprehensive entity-relationship type diagrams for the tables making up the NDOUTILS tables anywhere? This is the most comprehensive documentation I am aware of -- http://nagios.sourceforge.net/docs/ndoutils/NDOUtils_DB_Model.pdf -- 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@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