RamblingRoss

The blog of Ross Fruen, a .NET consultant

PowerShell provides the ability to easily import log4net files into a SQL database for analysis.

Step one

Create an appropriate table to store the log entries, e.g.

CREATE TABLE [dbo].[Entries](
 [LogEntry] [int] IDENTITY(1,1) NOT NULL,
 [LogFile] [varchar](max) NULL,
 [LogTime] [datetime] NUL...

Sometimes it is useful to combine multiple log files into one to get a better picture of what is going on. To do this the following power shell scripts may be useful. These scripts are not particularly elegant, but they do perform the job required.

First step, combine the log files into one. To k...