There are tools for this type of work if you really wanted to go there. Tools that deal with host intrusion detection can do this as can tools such as remote management tools (think SMS, Tivoli, etc). Anything that watches the event log can do this.
Your idea can also work, but has some flaws such as being able to detect whether or not the user was active or had the screen locked etc. That's another issue, but I suggest that you may want to have a logon and a logoff script if you continue down your path. The logon script will update a table (table1) with the information you currently capture. The logoff script would have to update a different table (table2). Your query would then be a join of the two tables based on computer name (as the key field). You can run that report from Access or Excel if you want. Again, that gives a picture of some of the workstations under particular scenarios. Not all will be recorded with this solution. Al -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Wilkinson Sent: Friday, July 02, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: [ActiveDir] Logging User Logon and Logoffs Is anyone logging both logion and log offs? I'm working on a method of recording this info for a computer lab environment, and I'd like to see if someone else is already doing it. I want real time utilization info and I want to be able to build stats off of it for latter use. On Cs, you can determine when I person logs on to a client machine, but you don't know when they log off because that information is only on the client machine. Right now I'm running a log on, and log off script to insert a row in SQ database in the following format: Computer name, use rid, login, log off Where either the login, or log off fields are date/time, and the other field is NULL. The problem with this approach is that you get logs like this: computer1, bob, 2004-04-29 14:36:08, NULL computer1, bob, NULL, 2004-04-29 14:52:34 So I need a way to combine the login/off logs into one roll to be able to perform stats. I'm a SQ novice, so I don't really know a good way of doing this besides exporting all of it to a cs, write a script that combines them, then export that back to a new database before running stats. -- Paul Wilkinson 865-974-0649 2422 Dunford Hall OIT Lab Services University of TN, Knoxville List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/mail_list.htm List FAQ : http://www.activedir.org/list_faq.htm List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
