Session Stats

[fnb4321]

 Anyone know of a way to determine how long a user had a session open ?

[rick]

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