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/
