SQL to read service configuration from mysql DB

[Marc Powell]

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
Nagios-users at 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