RE: Please Help

Hi,

We use MySql (free database software) to log users logons and logoffs that
is pulled from a kixscript set as a logon and logoff script.

It is a pretty amazing piece of free software. You can download from their
website as well as downloading kixscript from www.kixtart.org . You need to
create a database with the fields that match up with the script. I have
posted my kix script. You need the kix.exe and the mysql.exe in the Netlogon
share as well as having the mysql installed on a server and running.

$RAM = MemorySize(0)

$SqlString = "mysql.exe -h server -u mysqlusername -e " + chr(13) + chr(10)
$sqlString = $SqlString + chr(34) + "insert into log.log set " + chr(13) +
chr(10)
$sqlString = $SqlString + "Type='logoff'," + chr(13) + chr(10)
$sqlString = $SqlString + "Username='" + @userid + "'," + chr(13) + chr(10)
$sqlString = $SqlString + "Workstation='" + @wksta + "'," + chr(13) + chr(10)
$sqlString = $SqlString + "Date= now()," + chr(13) + chr(10)
$sqlString = $SqlString + "Time= now()," + chr(13) + chr(10)
$sqlString = $SqlString + "IP='" + @ipaddress0 + "'," + chr(13) + chr(10)
$sqlString = $SqlString + "Mac='" + @address + "'," + chr(13) + chr(10)
$sqlString = $SqlString + "Domain='" + @lserver + "'," + chr(13) + chr(10)
$sqlString = $SqlString + "os='" + @ProductType + "'," + chr(13) + chr(10)
$sqlString = $SqlString + "cpu=ltrim('" + @cpu + "')," + chr(13) +
chr(10)
$sqlstring = $sqlstring + "FullName='" + @FullName + "'," + chr(13) + chr(10)
$sqlstring = $sqlstring + "ram='" + $ram + "'," + chr(13) + chr(10)
$sqlString = $SqlString + "speed='" + @mhz + "';" + chr(34) + chr(13) +
chr(10)

shell $sqlstring

Cheers,
Lara

"ankit ." wrote:

I am a student of engineering college in India. In our computer lab,
our professor wants to save a log of each and every student(i.e their
logon time, logoff time, their roll no.).

For this we proposed a solution that the authentication of the user
should be done at remote computer for logging into local computer i.e.
we want a server that will authenticate a user for logging into local
computer.

Can anyone help us, what to do and how?

Is active directory useful in this case.

Ankit

.

Relevant Pages

  • Re: To prohibit users sharing the logins
    ... >> Is there a script would prohibit the user to share their logins? ... > The general idea is to create (throu logon script) folders on the server ... If the "intruder" has the account name and password, ... since the next logon is enabled by the running of the logoff ...
    (microsoft.public.windows.server.scripting)
  • Re: Login/Logoff
    ... One solution is logon and logoff scripts configured in a group policy that ... I have an example logon script that logs ... date, time, username, computername, and IP address linked here: ...
    (microsoft.public.windows.server.active_directory)
  • Re: Login/Logoff
    ... One solution is logon and logoff scripts configured in a group policy that ... I have an example logon script that logs ... Each logs information to a shared log file. ...
    (microsoft.public.windows.server.active_directory)
  • Re: how to generate a daily report for logon/logoff time?
    ... GUI or script? ... AD keeps track of the last logon time, ... AD does not keep track of last logoff time. ... A similar logoff script could add lines corresponding to logoff. ...
    (microsoft.public.windows.server.general)
  • Re: Users last logon info from logon script
    ... I put this line in the users logon script: ... If I run the script manually, it shows the last logon time. ... I guess it is because Windows update the lastlogon attribute once a user ... Then, for each Domain Controller, ADO is used to search the ...
    (microsoft.public.security)