Hello,

I search a log analyser to analyse baan logs. Is some here using a product to do that? I search something than can work under windows.

You can use the session,

ttstperrlog

I don't want only to take a look to logs.. i know how to do that.

I search a program that analyse logs based on keywords and rules. If a keyword is present or a rule is valided, i want to receive an alert.

Pierre,

HP has developed an Ovenview based product called Baan SPI (Smart PlugIn) which places a hook into the Baan error logging facility. This would enable any error of type err no to be send to an ITO server in the form of an alert. However the error validation is very unselective, hard to configure and the product is not supported anymore.

Thank you board master, i will investigate on that!

BMC also has a Baan agent that does Log file alert escalation. It does not work as well as the ITO agent.

Quest software (www.quest.com) has a program called Foglight for end to end performance monitoring and they are working on their first implementation of the event log trap.

-- Jim

You could also use the option of the bshell, TT_SQL_TRACE and DBSLOG should be set to trace a session.


Try
-- -set TT_SQL_TRACE=240 -set DBSLOG=20 -keeplog -logfile trace_file

Tape this line on your gui, in the command line.

Generate 2 files named dbslog and trace_file (be carefull about the size !!)

Each SQL request have an ID and you could cross the reference between the trace_file file and the dbslog

jmillet, you talk like baan support (logic your are from baan support!). Baan generate hundreds of log lines that are difficult to handle and the solution you propose is too generate more logs!

I don't want more log, i want a tool that can generate alert if there is particular error in log files.

Well, but instead of Baan Support, I've develloped some tools using sed and awk to analyse this sort of log, so have, for example, all queries expected 10 sec, or more.

Hey jmillet,

If you like to share some of your tools, please feel free to post them in the Code & Utilities (http://www.baanboard.com/baanboard/forumdisplay.php?s=&forumid=33) forum! :)