Try this: LogParser "SELECT TO_TIMESTAMP(date, time) AS utc-timestamp, TO_LOCALTIME(utc-timestamp) AS local-timestamp, c-ip, cs-username, EXTRACT_TOKEN(cs-uri-stem,-1,'/') AS filename INTO DATAGRID FROM \\WEBSERVER\admin$\system32\logfiles\w3svc1\ex07 *.log " It worked for me.
Never mind, I found it of course in the thourough help file. It is " TO_TIMESTAMP " Works flawlessly.
How can I combine two IIS fields (date, time) to create a field in a SQL table that is a TimeStamp?
The big problem with Log Parser and User level statistics is that Log Parser is designed to focus on a row of data and does not cross the row boundary. When faced with a problem that goes cross rows, you really need to write a little code. Just keep track of the first and last time for a "user" and clear...
nice querys tho.. very interesting for a newbie like me.. WebLogExpert (Pro trial priod) gives me output like this The one called total visitors is users that has been away from the site more than 30 minutes (this is something that u set analyzer options panel) Unfortuneatle i could not disable it..to...
Hi, I am parsing IIS log and sometimes with the switch -e:1000 I get some errors displayed as follows ************************************************ Cannot find end-of-line - extra characters detected at the end of log entry LogFile " \\WEBserver\LogFiles\W3SVC2\ex061211.log ", Row number 411810 *...
And you have to have dynamic pages, because IIS f.e. does not log the session cookie in case of an .HTM(L) file. If the same user visits an ASP page too then it is no problem, but if your website is mainly static pages..... Cees
I will go back on my prior comments and say that if you have a session cookie stored in the logs that you can group by that in LP and get fair sessionization from that. Of course, it will still have holes for people who leave their browser open all day and people who have cookies turned off, but those...
I did think about looking at AWStats, but the first glimpse learned that it is not as flexible as Logparser is. That's why I love it, I just output a number, add it to an HTML table, throw in the company logo and export it to PDF. My manager loves me for it!!! Thanks for the reply Daniel. Cees
Mowser
