As an application developper you often need to write some logs for your application, and hopefully there is actually many framework to ease your pain: Log4net, Entlib Logging Application Block, etc. But when it come to read those logs, extract statistics or to do some alert or action on them, things become harder. Actually a free command line tool from Microsoft name LogParser and it is quite awesome: you can query any log and data sources (database, event log, iis logs, file system, registry, etc.) with a complexe SQL query (I mean with functions, group by, etc.).
On the down side, using it from the command line become quickly boring as you need to type your sql query in a DOS prompt. As we failed to find any intuitive GUI for logParser, we just start to build our own, by assembling the following pieces: the logparser engine, a “visual studio” like MDI dockable interface, syntax highlighting…
Some other notes…
Do an insert to a db with the log parser utility from IIS resource toolkit:
C:\Program Files\IIS Resources\Log Parser>logparser "SELECT date, time, c-ip, cs -uri-stem, cs-uri-query, cs-username FROM C:\WINDOWS\system32\LogFiles\W3SVC201 2337366\*.log TO test2 WHERE SUBSTR( cs-uri-stem, LAST_INDEX_OF(cs-uri-stem,'.'), STRLEN(cs-uri-stem)) = '.asp'" -i:IISW3C -o:SQL -server:teas-db1 -usern ame:sa -password:"foobar" -driver:"SQL Server" -database:kevin_temp -createtable:ON
Leave a comment:
