History/Audit of Logged Users

[danson]

Recording to a table Who is logged on to Database, When they logged on and when they logged off.
Gets tricky as I really would like the info to come from the mdw file(all users go through this for access)
If someone can help would be great. Need my hand held for this as I have been attempting to do this for over a month with no real success. I have so many samples that don’t quite make it happen I am now totally confused.

Forever grateful - every crumb helps

Danson

 

[llkhoutx]

What you are doing is frought with problems, simply because users exit the program abnormally for a variety of reasons and a log-off is missed.

When a user first logs in, if he is "logged on" in the audit table, check the username and machine name, if they're the same, log them off in the table for the prior session and relog 'em in. I keep not only the user name, but also the computer name and log off method in the table because a user will log-in on multiple machines. Log off method will provide interesting info aout the users.

Statistics are like a bikini. What's revealed is interesting, but not what your really interested in.

Can't give you the code. Sorry.

 

[danson]

All comments greatfully recieved - am still plugging away - just thought someone may have an answer or a work arould that may put a different perspective on this

Thanks