Hi Andrew, Currently there's no documentation on how the tables interact.
But for your specific case is this: SELECT f.description, f.name, f.default_value, v.value, i.id FROM interface_types_field_types as ft INNER JOIN interface_types as it on (ft.id > 1 and ft.id != 20) INNER JOIN interface_types_fields as f on (f.itype = it.id and f.ftype = ft.id) INNER JOIN interfaces as i on (it.id = i.type) LEFT OUTER JOIN interfaces_values as v on (v.interface = i.id and v.field = f.id) WHERE (i.id = 2096) ORDER BY f.pos; With this example, you will see all the assigned parameters for the Interface ID 2096. This was based on the code included in the interface_values function in lib/api.interfaces.inc.php (close to the bottom). Hope that helps. Javier On Monday 12 April 2004 22:01, Baker, Andrew (AU) wrote: > Hello > > Is there such thing as a data model for the JFFNMS database as I am > attempting to link tables via an sql query in order to output the SLA data > for a given month giving the description of a physical interface rather > than the physical name (ie serial1 reads "serial link to destination name". > I have located the description in the table "interface values" and the > physical interface within the event but am having trouble linking them > > Help most appreciated > > _______________________________________________________________________ > > > Andrew Baker Tel: (03) 62101320 > > Technical Consultant Fax: (03) 62101313 > > LogicaCMG Mobile: 0401 715 479 > > Mailto:[EMAIL PROTECTED] > >http://www.logicacmg.com > > This e-mail and any attachment is for authorised use by the intended > recipient(s) only. It may contain proprietary material, confidential > information and/or be subject to legal privilege. It should not be copied, > disclosed to, retained or used by, any other party. If you are not an > intended recipient then please promptly delete this e-mail and any > attachment and all copies and inform the sender. Thank you. > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials > Free Linux tutorial presented by Daniel Robbins, President and CEO of > GenToo technologies. Learn everything from fundamentals to system > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > _______________________________________________ > jffnms-users mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jffnms-users ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ jffnms-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jffnms-users
