Nagios Support Forum

dear expert,

would like to know about an attached nagiois notifcation file data from where its reading data and how it is coming kindly check an attached file for your information

I believe what you're looking for is stored in SQL in the nagios_notifications table.

It is reading it from the multiple DB tables and using and using SQL joins to pull in the other tables, is there something specific that you're trying to accomplish?

dear ssax,

yes it seems reading from multible db as i have seen nagios_notification there are no host / services colum in the table , i would like to know the statistics about

how many alarms being notify time frame from : --- > to : with search criteria ( down / critical ) etc etc ( search contact / search " content " ) and display result
how many repetitive alarms ? for which host which services from specified time period which i select and give me display

my devloper will trying to get it done outside XI but he needs to know how that table comes as present there are no feature in current XI and its very much urgent so need your quick feedback

zaji_nms,

'mguthrie' answered your recent question in this post https://support.nagios.com/forum/viewto ... 99&p=29471

mguthrie wrote:Performance data is not actually stored in mysql, but it's in an rrd file (round robin database) stored in /usr/local/nagios/share/perfdata. Data can be retrieved from the command line by something like the following:

Code: Select all

rrdtool fetch /usr/local/nagios/share/perfdata/myhost/myservice.rrd AVERAGE -s <starttime> -e <endtime>

There's also a graph image API in Nagios XI that can be accessed directly from the web. However it requires an active XI session.

[url]http://<yourserver>/nagiosxi/includes/components/perfdata/graphApi.php?host=192.168.5.11&service=&source=1&view=3&start=&end=[/url]

You could access an image like this externally by using backend credentials from the Backed API URL component.
http://library.nagios.com/library/produ ... ackend-api

Hopefully this helps, but let us know if otherwise.

dear bwallace

my query regarding how to read nagios_notification table as in SQL no host / service coloum. ??

Regards,

Under the nagios_notification table you should see an object_id column - each service has a unique object_id.

From there, look at the nagios_services table, and then the service_object_id - the object_id will correlate to this. You will also see a host_object_id in the nagios_service table which correlates to the nagios_hosts table, host_object_id.

thanks a lot.
u may close this thread.