[Nagios-users] SQL to read service configuration from mysql DB
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. regards, Jim Mohr -- 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 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] SQL to read service configuration from mysql DB
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.sqlservicegroup_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.sqlhost_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.sqlservice_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 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] SQL to read service configuration from mysql DB
-Ursprüngliche Nachricht- Von: Marc Powell [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 10. Dezember 2008 19:57 An: Nagios Mailinglist Betreff: Re: [Nagios-users] SQL to read service configuration from mysql DB 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 snip THANKS!!! Although I can't find a query that lists all of the service configration information, these definately give me an insight into how the tables are connected in order to build the query I need. Regards, Jim Mohr -- 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 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
