Anyone know of a way to determine how long a user had a session open ?
I believe you can calculate it from the system log table.
Msg No : 30 -> Conveys login action and
Msg No : 32 -> Conveys logoff action
From the time difference between this two we can find how log the session was open