How to create a user table recording Windows logon
Posted on 2006-05-18
I'd like to create a table with a list of users giving their Windows domain logons plus the time of their logon.
When a user logs on their logon name should go into the table as well as their machine name. Also a flag should be set to Yes to show they are logged in. When they exit the database the flag should be set to No (to enable checking if anyone exits and leaves the database in a suspect state), and the logoff time recorded.