yes I realised afterwards that using the nagios_object table I could retrieve this binding. I've also been missing the contact_name in the nagios_contacts table which would be handy (also available through the nagios_object table) ... Small question on the table contents : what is the use of the config_type field in contacts/hosts/services tables? Having the sql sample will be of help I think, thanks for this. Seb. <div> On 1/19/07, Ethan Galstad <<a href="mailto:nagios@nagios.org">nagios@nagios.org</a>> wrote:<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Sébastien Barbereau wrote: > Hello, > I've been looking through the db structure and can't find how to link a > service object to a host object. > Does some one know how to do this from DB? > > Thanks, > Seb Hmm, this seems to be a huge oversight on my part. I'm releasing 1.4b2 with a few patches. One of them fixes this problem by adding a 'host_object_id' field to the services table. Technically, a join could be done previously, but the join would have had to be done on varchar fields. Also, I've included a bunch of sample SQL queries in the db/sql subdirectory to show how to grab info. Thanks for the report! Ethan Galstad, Nagios Developer --- Email: <a href="mailto:nagios@nagios.org">nagios@nagios.org</a> Website: <a href="http://www.nagios.org">http://www.nagios.org</a> ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash <a href="http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV">http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV</a> _______________________________________________ Nagios-devel mailing list <a href="mailto:Nagios-devel@lists.sourceforge.net">Nagios-devel@lists.sourceforge.net</a> <a href="https://lists.sourceforge.net/lists/listinfo/nagios-devel">https://lists.sourceforge.net/lists/listinfo/nagios-devel </a> </blockquote></div>