Recreate user sessions from IIS logs

Last Post 08 Jun 2007 02:46 AM by bmcwilliams. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bmcwilliams
New Member
New Member

--
06 Jun 2007 03:51 AM
I am trying to recreate user sessions from our IIS logs. I have everything processed down to the users, datetime, and what pages they visited.

What I'm trying to do is.....

for a given user I want all pages hit within a given time, say 45 min. or an hour. I guess an hour would be easier for this discussion.

so right now, my data looks like this...

name, timestamp, page1, page2, page2, page 4
bob 1:01 0 1 0 0
bob 1:04 1 0 0 0
bob 1:05 0 0 1 0

if bob visited all these pages within the hour then I want the table to look like.....

name, page1, page2, page2, page 4
bob 1 1 1 0

I don't really see how to combine this together. Any help would be appreciated.
Thanks,
bmcwilliams
New Member
New Member

--
08 Jun 2007 02:46 AM
yes there is a bit flag for each page if it was hit. The logs are brought into sql sever using DTS. It just creates a IIS Log Data table.
You are not authorized to post a reply.

Acceptable Use Policy