I have a MySQL question that I hope does not sound to 'newbie-ish'..:-) I have just set up a new server for logging all the network devices. Syslog-ng is working fine and now I am ready to move onto setting up the MySQL side. I was wondering if any had created a MySQL database specifically for network devices and if it was significantly different than what is on the following URL: http://vermeer.org/display_doc.php?doc_id=1 CREATE TABLE logs ( host varchar(32) default NULL, facility varchar(10) default NULL, priority varchar(10) default NULL, level varchar(10) default NULL, tag varchar(10) default NULL, date date default NULL, time time default NULL, program varchar(15) default NULL, msg text, seq int(10) unsigned NOT NULL auto_increment, PRIMARY KEY (seq), KEY host (host), KEY seq (seq), KEY program (program), KEY time (time), KEY date (date), KEY priority (priority), KEY facility (facility) ) TYPE=MyISAM; The question that I have relates to following tables in the DB: priority : where would this come into play for network devices? level: not sure what this is tag: where would this come into play for network devices? program: where would this come into play for network devices? If there is anyone who could help me with this network specific DB I would appreciate it. Thanks in advance. -Patrick