Session Stats

Previous topic - Next topic

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