Hello Brett, Coincidentally, we've come up with two tables for logging A 'session' table and an 'activity' table. Although we havent fully identified the fields yet.
Security table may have following fields SECURITY_SESSION_ID, APPLICATION_NAME, IP_ADDRESS, FLASH_VERSION, USER_AGENT, SCREEN_SIZE, AVAILABLE_SCREEN_SIZE, BROWSER_ALLOWS_COOKIES, CPU_CLASS Activity/Event table as follows SECURITY_SESSION_ID, (FK) EVENT_NAME, EVENT_VALUE, URL What is a reliable source/method of getting SESSION ID's. Warm Regards, Sameer S. Kekade. http://cfsameer.blogspot.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brett Payne-Rhodes Sent: Monday, 11 July 2005 12:25 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Session tracking / User activity monitoring Sameer, Given you are talking about different applications aren't they using different databases? If they happen to be sharing a database then you have already identified the differentiator - Application Name. And I agree with Steve on this... Logging to the database provides a lot more flexibility than trying to extract session information from a web log. I actually use two tables for logging - a 'session' table and an 'activity' table, where the activity table holds the sessionId as a foreign key. It's an overhead but it makes reporting *so* easy... Brett B) Sameer Kekade wrote: > Barry, > > For a single IP address 10.X.X.X > > multiple applications each with one single session > ---> APPLICATION A - 86301584841121037562417(sessionID) > ---> The user ctrl+N to a new IE browser window > ---> APPLICATION B - 86301584841121037562417(sessionID) <--- Gets the > same session ID although the application is different > > > multiple applications each with multiple sessions > ---> APPLICATION A - 86301584841121037562417(sessionID) > ---> The user ctrl+N to a new IE browser window > ---> APPLICATION B - 86301584841121037562417(sessionID) <--- Gets the > same session ID although the application is different > ---> The user ctrl+N to a new IE browser window > ---> APPLICATION C - 86301584841121037562417(sessionID) <--- Gets the > same session ID although the application is different > > ---> Different browser instance > ---> APPLICATION B - 78D437A3C667F379D08B48EED194FD7B(sessionID) > ---> The user ctrl+N to a new IE browser window > ---> APPLICATION A - 78D437A3C667F379D08B48EED194FD7B(sessionID) <--- > Gets the same session ID although the application is different > > The point here, > its difficult to track what this user is doing unless we could > track/log > > - IP Address > - Session ID > - Application name > > Warm Regards, > Sameer S. Kekade. > http://cfsameer.blogspot.com > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Barry > Beattie > Sent: Monday, 11 July 2005 11:20 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Session tracking / User activity monitoring > > > can you just clarify: > > for each user: > > multiple applications each with one single session > > or > > multiple applications each with multiple sessions (each session is a > diff browser instance) > > thanx > barry.b > > > >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] Behalf Of Sameer >>Kekade >>Sent: Monday, 11 July 2005 11:18 AM >>To: CFAussie Mailing List >>Subject: [cfaussie] Re: Session tracking / User activity monitoring >> >> >>Yes they do log in. >> >>And there may be a situation where our staff members have 3-4 >>different application/session instances on the same machine. >> >>In that case, logging browser and IP address isnt enough. Maybe a >>combination of application name, IP, sessionID would make sense. >> >>Warm Regards, >>Sameer S. Kekade. >>http://cfsameer.blogspot.com >> >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] On Behalf Of Chad >>Renando >>Sent: Monday, 11 July 2005 11:04 AM >>To: CFAussie Mailing List >>Subject: [cfaussie] Re: Session tracking / User activity monitoring >> >> >>Are they logging in? I've never done it for a straight Internet site, > > >>Webtrnds was eno9ugh. But for a log-in situation, I typically grab >>the user's browser and IP and what page they hit and when. I >>then report it >>back to the user as a way for them to ensure their password has not >>gotten away from them, as well as let managers understand the activity >>of their staff within the application. >> >>Chad >>who takes 1 suger in his coffee, thanks you very much >> >>On 7/11/05, Sameer Kekade <[EMAIL PROTECTED]> wrote: >> >>>Hey Guys, >>> >>>I need some pointers on how session tracking/ user activity >> >>monitoring >> >> >>>is done like they have in FarCry. >>> >>>We need to track the user-activities within our website like >>>- The path they take >>>- Sections they visit >>>- Current active users on the website >>> >>>I thought of logging it onto a csv log file but then its >> >>difficult to >> >>>manage them. >>> >>>Another option would be logging these activities onto a database >>>table. Has anybody done something like this before? >>> >>>Thanks in advance >>> >>>Regards, >>>Sameer S. Kekade. >>>http://cfsameer.blogspot.com >>> >>> >>> >>>--- >>>You are currently subscribed to cfaussie as: >> >>[EMAIL PROTECTED] To >> >> >>>unsubscribe send a blank email to >>>[EMAIL PROTECTED] >>>Aussie Macromedia Developers: http://lists.daemon.com.au/ >>> >> >>--- >>You are currently subscribed to cfaussie as: >>[EMAIL PROTECTED] To unsubscribe send a blank email to >>[EMAIL PROTECTED] >>Aussie Macromedia Developers: http://lists.daemon.com.au/ >> >> >>--- >>You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To > > >>unsubscribe send a blank email to >>[EMAIL PROTECTED] >>Aussie Macromedia Developers: http://lists.daemon.com.au/ >> > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To > unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
