On Dec 10, 2008, at 11:35 AM, Mohr James wrote: > Hi All! > > I am trying to put together an SQL query to read the MySQL NDO DB in > order to get the same kind of information that the web GUI provides > under the "Configuration" link. I was hoping that someone already had > written the query so I would not have to re-invent the wheel. Any > input > is appreciated.
Looks like these are a good starting point -- queries]# pwd ; ls /usr/local/src/ndoutils-1.4b7/db/queries comment_history.sql contacts.sql host_comments.sql host_notifications.sql scheduled_downtime.sql servicegroup_membership.sql state_history.sql comments.sql contact_status.sql host_downtime_history.sql hosts.sql service_comments.sql service_notifications.sql timed_event_queue.sql contactgroup_membership.sql downtime_history.sql host_event_handlers.sql host_state_history.sql service_downtime_history.sql services.sql timed_events.sql contact_notification_methods.sql event_handlers.sql host_flapping_history.sql host_status.sql service_event_handlers.sql service_state_history.sql contact_notifications.sql flapping_history.sql hostgroup_membership.sql notifications.sql service_flapping_history.sql service_status.sql -- Marc ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ Nagios-users mailing list [email protected] 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
