Unfortunately, there isn't really any good way to do visit tracking in LP. It is only barely possible in a normal SQL engine using complicated self joins. I'd suggest looking into an actual web log analysis program such as AWStats for the visit tracking part..

Hi there, browsing through this forum I have found the answer to my questions ALMOST. But it's the almost part that I have been struggling with for a day and a half now. What I would like to measure is basically three things: 1. pageviews : I used query below to do that (please correct me if I'm wrong...

hi daniel, thank you for your reply. my question was more that i am new to logparser and thought that there might be a better way or that i might be querying on the wrong iis log entries once into excel i can manipulate and sort for better presentation. thanks again lee

It doesn't seem that bad to me.. Moving into Excel will probably be your best bet if you are wanting something like a pivot table/chart for display. What is wrong with this solution?

hello all, i need to create a list of accesses to our owa site for a daily/weekly/monthly basis here is what i have come up with so far; LogParser "SELECT date, time, c-ip, cs-method, cs-uri-stem, cs-username FROM C:\logs\ex*.log TO Output.csv where c-ip like 'external ip address with last octet wildcard...

Hello Gabriele, I have read your reply on time and date format for IIS. I have experience similar issues. But it works on some of my machine, but not the others. So I would like to know whether MS Logparser is affected by the time and date format of the machine where Log Parser was executed? Please advise...

Hello all thank you very much for this forum..If anyone can shed some light on my problem it would be greatly appreciated. Below I have included the error, the query that I am using, and log entries from my logs. I keep receiving this Parse error Too many parse errors - aborting Parse errors: Log format...

THis is what i came up with so far by cobbling some other posts together ... SELECT COUNT(*) AS Entries , EntryPage USING HASHSEQ(STRCAT(c-ip, [cs(User-Agent)])) AS visitorID , cs-uri-stem AS EntryPage INTO temp3.csv FROM ex060904.log WHERE IN_ROW_NUMBER() in ( select MIN(IN_ROW_NUMBER()) USING HASHSEQ...

Sorry, I see this should have been posted in IISW3C area... and I've also noticed another post indicating that a combination of IP address and User Agent can be used when cookies are not being set.

Hi, just getting my wits around log parser and could use a little help with a bit of SQL. Trying to clean up a website and would like a list of all entry points to the site during the last 3 months. Was already successful getting a list of pages hit using this: ------------------------------------- SELECT...