<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> The ndo_hosts has the address as far as I know, in version 1.3, it does't have the hostname. The hostname is in ndo_objects table and its referenced by the field <a href="https://192.168.10.30/phpMyAdmin/sql.php?lang=en-utf-8&server=1&collation_connection=utf8_general_ci&db=nagios&table=ndo_hosts&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60ndo_hosts%60++ORDER+BY+%60host_object_id%60+ASC" title="Sort"> host_object_id</a>. in the field name1. The field <a href="https://192.168.10.30/phpMyAdmin/sql.php?lang=en-utf-8&server=1&collation_connection=utf8_general_ci&db=nagios&table=ndo_objects&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60ndo_objects%60++ORDER+BY+%60objecttype_id%60+ASC" title="Sort"> objecttype_id</a> in ndo_objects sets what type of object it is according to table bellow: I hope that I could help. NDO2DB_OBJECTTYPE_HOST=1; NDO2DB_OBJECTTYPE_SERVICE=2; NDO2DB_OBJECTTYPE_HOSTGROUP=3; NDO2DB_OBJECTTYPE_SERVICEGROUP=4; NDO2DB_OBJECTTYPE_HOSTESCALATION=5; NDO2DB_OBJECTTYPE_SERVICEESCALATION=6; NDO2DB_OBJECTTYPE_HOSTDEPENDENCY=7; NDO2DB_OBJECTTYPE_SERVICEDEPENDENCY=8; NDO2DB_OBJECTTYPE_TIMEPERIOD=9; NDO2DB_OBJECTTYPE_CONTACT=10; NDO2DB_OBJECTTYPE_CONTACTGROUP=11; NDO2DB_OBJECTTYPE_COMMAND=12; NDO2DB_OBJECTTYPE_HOSTEXTINFO=13; NDO2DB_OBJECTTYPE_SERVICEEXTINFO=14; <a href="https://192.168.10.30/phpMyAdmin/sql.php?lang=en-utf-8&server=1&collation_connection=utf8_general_ci&db=nagios&table=ndo_objects&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60ndo_objects%60++ORDER+BY+%60objecttype_id%60+ASC" title="Sort"></a> Mike Koponick wrote: <blockquote cite="mid8C18BAD1F46B2245B0A08BCF1A823DD4109C31@raptor.redhawk.info" type="cite"> <pre wrap="">Hello, I'm in the process of (trying?) to map out the NDO to MySQL data. I have noted that the IP address is missing from the ndo_hosts table, which was pointed out on the list. From what I can tell at this point in my research, this is one of the few columns that are missing. What should this column be named? If added, will Nagios also add the IP address information directly; much like it has with all other data. The problem I'm seeing is that if I create a separate table, very few data items connect because the way the object_id's are defined, etc. This, btw is a good thing from my perspective, but is making development hard for a web interface. A mapping of the NDO/Nagios/MySQL database would be nice, even if it were incomplete. I would look in the code myself, but my coding skills are not in "C" and would confuse anyone to drink heavily. Thoughts? Thanks in advance, Mike ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! <a class="moz-txt-link-freetext" href="http://sel.as-us.falkag.net/sel?cmd=k&kid3432&bid#0486&dat1642">http://sel.as-us.falkag.net/sel?cmd=k&kid3432&bid#0486&dat1642</a> _______________________________________________ Nagios-devel mailing list <a class="moz-txt-link-abbreviated" href="mailto:Nagios-devel@lists.sourceforge.net">Nagios-devel@lists.sourceforge.net</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/nagios-devel">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a> </pre> </blockquote> <div class="moz-signature">-- <title>OpSign</title> __________________________________________________ <table border="0" cellpadding="0" cellspacing="0" width="350"> <tbody> <tr> <td valign="top" width="130"> Alessandro Ren </td> <td valign="top" width="220"> OpServices Luciana de Abreu, 471 - Sala 403 Porto Alegre, RS - CEP 90570-060 </td> </tr> </tbody> </table> <table border="0" cellpadding="0" cellspacing="0" width="350"> <tbody> <tr> <td valign="middle" width="180"> ( phone 55(51)3061-3588 4 fax 55(51)3061-3588 </td> <td valign="middle" width="200"> Q mobile 55(51)8151-8212 : email <a href="mailto:%22alessandro.ren@opservices.com.br%22">alessandro.ren@opservices.com.br</a> </td> </tr> </tbody> </table> __________________________________________________ </div> </body> </html>