ODBC logs and log analyzer

spud · Post by **spud** » Tue Oct 21, 2008 2:28 pm

I have recently moved away from text log files to instead use a MySQL database for event logging. Now that all the events are going to the MySQL database, I have a question about how to read that data intolog analyzer. I am using a *.las script file to run reports and am using the "loadtable" command inside my scripts.

My question: is there a way to speed up the loadtable command so that I only need to load today's data if I want to run a report about today's data? or load the data for the past week if running a report for this week?
Right now the loadtable command loads all the records from the table and takes a long time to load. As I see the ODBC data grow, doing the loadtable command will gradually become slower and slower. I am sure I am missing something.

KS-Soft · Post by **KS-Soft** » Tue Oct 21, 2008 4:26 pm

There are 2 options: when you setup ODBC log you may set "When date filter is not specified: analyze current week only" option and/or "Add custom filter" option where you can provide any valid SQL filter you want.
http://www.ks-soft.net/hostmon.eng/la/i ... dbcManager

Regards
Alex

spud · Post by **spud** » Tue Oct 21, 2008 5:02 pm

I gave the current week only option a try, but then was confused about how to do monthly or quarterly reports using the same profile. Then it hit me (duh!), I can have multiple profiles defined against the same database. So I made duplicate profiles in the "setup ODBC logs" screen and changed the custom filter for each profile to grab a different set of records. It is working perfectly now.

Thanks!
Spud