Geeks With Blogs
General's March 2010 Entries
Query a Log4Net-database
So if you use Log4Net to log into a database (i.e. using the AdoNetAppender), how can you conveniently get an overview of what has happend ? Well, you could try the following Query ( T-SQL ): SELECT convert(varchar(10),LogDB.D... as Datum, LogDB.Level, LogDB.Logger,COUNT(LogDB.Lo... as Counter From Log4Net.dbo.Log as LogDB where Level <> 'DEBUG' AND convert(varchar(10),LogDB.D... like '2010-03-25' GROUP BY convert(varchar(10),LogDB.D... ORDER BY counter ......

Posted On Friday, March 26, 2010 2:21 PM

Hello World!

This is my first Post - more 2 come! :-)

Posted On Friday, March 26, 2010 2:01 PM

Copyright © pinhack | Powered by: