<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV dir=ltr align=left><SPAN class=310425713-23022006><FONT
face="Lucida Bright" color=#0000ff>Could you please post this as a
PDF? Not everyone has Viso.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT face="Lucida Bright">--</FONT></DIV>
<DIV align=left><FONT face="Lucida Bright">Aaron Kent Moore</FONT></DIV>
<DIV align=left><FONT face="Lucida Bright">Information Technology
Services</FONT></DIV>
<DIV align=left><FONT face="Lucida Bright">DeKalb Memorial Hospital,
Inc.</FONT></DIV>
<DIV align=left><FONT face="Lucida Bright">Auburn, IN</FONT></DIV>
<DIV align=left><FONT face="Lucida Bright">Phone:
260.920.2808</FONT></DIV>
<DIV align=left><FONT face="Lucida Bright">E-mail: </FONT><A
href="mailto:amoore@dekalbmemorial.com"><FONT
face="Lucida Bright">amoore@dekalbmemorial.com</FONT></A></DIV>
<DIV> </DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> nagios-devel-admin@lists.sourceforge.net
[mailto:nagios-devel-admin@lists.sourceforge.net] <B>On Behalf Of </B>Marlo
Bell<BR><B>Sent:</B> Wednesday, February 22, 2006 12:10 PM<BR><B>To:</B>
nagios-devel@lists.sourceforge.net; Mike Koponick<BR><B>Subject:</B> Re:
[Nagios-devel] MySQL Mapping - NDO<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Here is a Visio I did of the ndo 1.2 database. There are certainly typos
and who know if I reverse engineered if properly. The blue objects table is
blue because it appears in multiple places (for readability), the instance_id
column is green because it is a foreign key to the ndo_instances table (again
for readability).</DIV>
<DIV> </DIV>
<DIV>You may have it or throw it away.</DIV>
<DIV> </DIV>
<DIV>Marlo<BR><BR>>>> "Mike Koponick" <mkoponick@redhawk.info>
02/21/06 12:28 pm >>><BR>Hello,<BR><BR>I'm in the process of
(trying?) to map out the NDO to MySQL data. I have<BR>noted that the IP
address is missing from the ndo_hosts table, which was<BR>pointed out on the
list. From what I can tell at this point in my<BR>research, this is one of the
few columns that are missing.<BR><BR>What should this column be named? If
added, will Nagios also add the IP<BR>address information directly; much like
it has with all other data.<BR><BR>The problem I'm seeing is that if I create
a separate table, very few<BR>data items connect because the way the
object_id's are defined, etc.<BR>This, btw is a good thing from my
perspective, but is making development<BR>hard for a web interface.<BR><BR>A
mapping of the NDO/Nagios/MySQL database would be nice, even if it<BR>were
incomplete. I would look in the code myself, but my coding skills<BR>are not
in "C" and would confuse anyone to drink
heavily.<BR><BR>Thoughts?<BR><BR>Thanks in
advance,<BR><BR>Mike<BR><BR><BR>-------------------------------------------------------<BR>This
SF.net email is sponsored by: Splunk Inc. Do you grep through log files<BR>for
problems? Stop! Download the new AJAX search engine that
makes<BR>searching your log files as easy as surfing the web.
DOWNLOAD
SPLUNK!<BR>http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642<BR>_______________________________________________<BR>Nagios-devel
mailing
list<BR>Nagios-devel@lists.sourceforge.net<BR>https://lists.sourceforge.net/lists/listinfo/nagios-devel<BR><BR></DIV>
<P><PRE wrap>------------------------------------------------------------------------------
<P><PRE wrap><WIDTH=80>
NOTICE: This email message is for the sole use of the<BR> intended recipient(s) and may contain confidential and<BR> privileged information. Any unauthorized review, use,<BR> disclosure or distribution is prohibited. If you are not the<BR> intended recipient, please contact the sender by reply email<BR> and destroy all copies of the original message.
</PRE><P></P>
------------------------------------------------------------------------------
</PRE>
<P></P></BLOCKQUOTE></BODY></HTML>