Syslog messages can be logged for any network device to an MS SQL Server v7 repository. You can use NT-based syslog tool called SL4NT, and there's another called Kiwi Syslog, that will act as a syslog server. These also then direct the syslog output to an ODBC database connection, the SQL Server table.
From the database table, you can perform whatever sql queries needed. One feature that SQL v7 offers is a Web Assistant that permits stored procedures to output html files on a regularly scheduled basis. Our output directory for these stored procedures is the actual web directory. You can also use the same sql query in an ASP web page to perform adhoc reports as needed.
Or else you can try JFFNMS an OpenSource Network Management System, which includes a syslog message server (msyslog) and stored the data on a Database. JFFNMS shows the syslog messages in an events screen, with full filter capabilities.It refreshes automatically on new events.You can try thefollowing URL for more information:
http://jffnms.sourceforge.net
