NDutils : service to host binding

[Sébastien Barbereau]

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.


On 1/19/07, Ethan Galstad <nagios at nagios.org> wrote:
>
> 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: nagios at nagios.org
> Website: http://www.nagios.org
>
> -------------------------------------------------------------------------
> 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
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Nagios-devel mailing list
> Nagios-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20070119/ec79d480/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
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
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
-------------- next part --------------
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel