Hi Sameer,
Sameer Kekade wrote:
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.
Great minds?!? Or an obvious solution? ;)
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
I also have a userId field in my session table. It is set to sero when
the session record is created but updatd with the real userId when (if)
the visitor logs in.
Activity/Event table as follows
SECURITY_SESSION_ID, (FK)
EVENT_NAME,
EVENT_VALUE,
URL
You will also need an id field of some kind. Just make it an autonumber
field..
What is a reliable source/method of getting SESSION ID's.
I use <cfset session.sessionId = createUUID()>
hth,
Brett
B)
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)
---
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/
