Frustrated with the speed of the SQL output directives, I just ran a little experiment. I used -o:sql to dump a log query on a 10MB IIS file. It took 2:30 (I'm using the COM wrapper). I then used the "interactive mode" in COM, assembled a System.Data.DataTable by hand, and then used System...

I have some time data in logs with a sub-second time resolution. I can get this safely into log parser using the iTsFormat setting. When I put that into SQL Server 2008 I have (so far) gotten the times in seconds (loss of resolution). The target field is datetime2 (not datetime). How do I preserve the...

C:\Program Files\Log Parser 2.2>logparser -i:w3c "SELECT TO_LOCALTIME(TO_Timesta mp(REPLACE_STR(STRCAT(STRCAT(date,' '), time),' GMT',''),'yyyy-M-d h:m:s')) as D ateTime, [Server-hostname], [Recipient-Address],[Event-ID], [total-bytes], [Numb er-Recipients], TO_LOCALTIME...

Hi there, I tried to parse the info in "cs-uri-stem", In "cs-uri-stem" it contain a string like " /Demodir/_233_demo.gif" I just want to parsed the "233" . So I used CharIndex. I tested in CharIndex on SQL and it worked, but once I run it in LogParser it failed...

Hi, I am having trouble connecting to Oracle XE to import IIS logs. Each time that I try a variation on (some names changed to protect the innocent): LogParser.exe -i:IISW3C file:iislogquery.sql?logpath="V:\\Logfiles\\XYZ" -o:SQL -oConnString:"Driver={Oracle in Home_Default10g};DBQ=111...

I'm having problems exporting the log to a SQL database. The errors I seem to get are related to the field name/data type. I ran the following below to get the field names. LogParser "select * INTO C:\log.txt From 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'"...

Hi, I'm a long time LP user and I'm faced with a strange behaviour when outputing to SQL. I'm using LP v2.2, Mysql v5.1 and MySQL ODBC Connector v3.51. I'm uploading parsed results to a MySQL DB. The destination table already contains ~1GB of data. When LP finishes parsing and just before...

Thank you, but this is another problem related to create a new SQL table! Please somebody help me, how can i create a SQL table with an auto-increment (IDENTITY(1,1)) primary key, a datetime field and others text fields? I have some logs (from router/firewall) with this format: SourceAddress ; SendTime...

Hello, I'm trying to create and populate some SQL Tables from log file using LogParser COM API. I use SQL Output format with -createTable option enabled and i need an auto-generated identity column (an auto-increment primary key!) I tried SELECT 1, SendTime, Facility, Severity, MessageText ; INTO...

All, I am trying to import a merged W3C Extended log into a SQLEXPRESS instance. My LogParser 2.2 query is as follows: LogParser -i:W3C -o:SQL "SELECT date, time, s-computername, c-ip, cs-uri-stem, cs-uri-query, sc-status, sc-substatus, sc-win32-status, time-taken, sc-bytes, cs-bytes FROM MERGED_LOG...