Automatic Report

[peter19x]

Dears,

I appreciate the new feature where we can export the graphs as CSV format which is very useful to me.

I am wondering, if it is possible to generate this report automatically every xDays without going to the graph and doing it manually each time?

Many Thanks!
Peter

[kyang]

You should be able to schedule it as a report using a button.

There are Daily, Weekly, and Monthly options.

https://assets.nagios.com/downloads/nag ... eports.pdf

Does this help?

[peter19x]

Hi Kyang,

Thank you for your reply.

I can see from the Report page when filtering my services that it only shows the availability history of these hosts/services, what I was looking for is the data these services were sending, ie. call traffic history. Is there a way to do that?

At the moment the attached image is what i am getting

[kyang]

Are these switches/routers? The availability report doesn't show any traffic history.

You could use the bandwidth usage report? Or the capacity planning report?

Otherwise, I'm not sure what hosts these are?

[peter19x]

They are Session border controllers that are sending passive checks via NRDP to Nagios, each services is a trunk that carries traffic.

Basically these services show how many calls are on each trunk every 15min.

I would like to get a report of the calls stats weekly.

Example:

Host: SBC1 , Service: trunk01, Status information: Calls:150
.
.
.

[kyang]

Currently, something like this isn't available in reports.

You could, however, schedule that service page as a weekly report?

I received this page in a PDF format with a title of "weekly httpd". (You can name it anything you like, and it can run any day at any time of the week.)

Capture.PNG

Here is the documentation for scheduling a page.

https://assets.nagios.com/downloads/nag ... 1512139503

Let us know if this helped!

[peter19x]

Hi Kyang,

Thank you for the reply, unfortunately this won't help our capacity team to monitor the calls we are looking at.

I have created a dashboard with all the graphs on the servers carrying the calls, I'm wondering if there is a file somewhere on Nagios that has the raw data of the graphs in a readable format? I could manipulate that file instead and send it via mail.

I checked the files in the directories below but the mrtg directory did not include my passive checks/hosts, and the other files are not human readable.

/var/lib/mrtg/
service_perfdata_file=/var/nagiosramdisk/service-perfdata
host_perfdata_file=/var/nagiosramdisk/host-perfdata

Kind Regards,
Peter

[kyang]

Have you tried looking in /usr/local/nagios/share/perfdata?

You could probably grep for some info in the xml files.

Code: Select all

cat /usr/local/nagios/share/perfdata/kyang-PC/Memory_Usage.xml | grep NAGIOS_SERVICEOUTPUT

  <NAGIOS_SERVICEOUTPUT>OK: committed: Total: 15.866GB - Used: 7.556GB (47%) - Free: 8.31GB (52%), physical: Total: 15.868GB - Used: 7.477GB (47%) - Free: 8.391GB (52%)</NAGIOS_SERVICEOUTPUT>

After the 5 min passive check is received I update it again with the command.

Code: Select all

cat /usr/local/nagios/share/perfdata/kyang-PC/Memory_Usage.xml | grep NAGIOS_SERVICEOUTPUT

  <NAGIOS_SERVICEOUTPUT>OK: committed: Total: 15.866GB - Used: 7.793GB (49%) - Free: 8.073GB (50%), physical: Total: 15.868GB - Used: 7.681GB (48%) - Free: 8.186GB (51%)</NAGIOS_SERVICEOUTPUT>

Take a look in there, and let us know if this helps!