Import IIS logs into SQL Server database using LogParser

Tag: Database load color log LAN using parser directory Ros

First, install the LogParser

https://www.microsoft.com/en-us/download/details.aspx?id=24659

II. importing logs into SQL Server database

Open cmd switch to logparser installation directory

Assuming the log directory is F:\iislogs\

Import all log files under this directory:

LogParser "SELECT * from f:\iislogs\* to Iislogs"-i:iisw3c-o:sql-server:. -driver: "SQL Server"-database:test-username:sa-password:123456-createtable:on

Or import one of these files:

LogParser "SELECT * from F:\iislogs\u_ex161231.log to Iislogs"-i:iisw3c-o:sql-server:. -driver: "SQL Server"-database:test-username:sa-password:123456-createtable:on

Import IIS logs into SQL Server database using LogParser