AUP agreement at login

[Theldron]

Hi, I have been tasked with finding a way that we can have students and staff agree to an acceptable use policy on login and for the results to be recorded. I know Impero, Netsupport DNA etc. do this but I need to find a free solution?

 

Is there a way to run it from a script that feeds into an excel spreadsheet?

 

I'm not much of a coder so any advice would be appreciated.

 

Many thanks

[BKGarry]

You can display a login message through group policy. You cannot log that it has been recorded, but if you state by clicking OK you agree, then you can use the fact that they have logged in to them agreeing. This is what I have done.

 

Computer Configuration > Policies > Windows Settings > Security Settings > Local Policies > Security Options

 

Change the Following:

 

Interactive Logon: Do not require CTRL + ATL + DEL (enable this so that you can have the AUP displayed instead of CTRL + ALT + DEL)

Interactive Logon: Message text for users attempting to log on (write it in notepad and paste it, I always found that easier)

Interactive Logon: Message title for users attempting to log on

 

This will display a message they have to click OK to before logging on.

[fiza]

Now that @bizzel is back on Edugeek maybe you could persuade him to resurrect AUP Informant? EduGeek AUP Informant

 

It was great!

[k-strider]

We push sign-ins and outs to a SQL Express Database the database time stamps one of the columns but the script populates the username and computer name where the user signs in... you could put a message box up first with your AUP message then its all neatly in a database..

i wrote a small C# program to interrogate the database so we can search who signed in where.... something similar could be done to see who accepted the AUP

 

this is the vb script that runs as a login script.

on error resume next

 

dim m_cn, m_rs, s_sql

 

Set m_cn = CreateObject("adodb.connection")

m_cn.open "Driver={SQL Server};Server=DBSERVERNAME\Instance;Database=dbSign;Trusted_Connection=True;"

 

Set m_rs = CreateObject("adodb.recordset")

Set WshNetwork = CreateObject("WScript.Network")

 

s = Wshnetwork.computername

nm = wshnetwork.username

 

'msgbox s

'msgbox nm

theTime = FormatDateTime (now(),4)

theDate = Date()

'msgbox theTime

'msgbox theDate

 

s_sql = "INSERT INTO Tbl_Sign (SignUser, SignComputer, SignLogInOut) VALUES ('" & nm & "','" & s & "','1')"

'msgbox s_sql

m_rs.open s_SQL, m_cn, adOpenStatic

 

'msgbox "Finished!"

[Sheridan]

We use the GPO method to say that clicking OK shows your acceptance of the AUP, and use a messaging system to notify of any changes once they’ve logged on. Obviously everyone clicks OK without reading it but there’s only so much you can do!

[Bertie_Dellend]

We use the GPO message method - message starts "By logging in to this system you are accepting the terms and conditions of the school AUP"

[bizzel]

Now that @bizzel is back on Edugeek maybe you could persuade him to resurrect AUP Informant? EduGeek AUP Informant

 

It was great!

 

I still have the AUP Informant source code safely tucked away, and I still regularly receive requests for the app installer (which I don't have). Some of you may be aware that I am in the process of resurrecting EduSweep and that the source for that is now on GitHub (https://github.com/paulbeesley3/EduSweep). I could do the same for AUP Informant but it would take quite a lot of effort; for EduSweep I was working on it for three months during a period of unpaid holiday and now I'm back at work full-time. I also don't have a large enough network for proper local testing of the server and client applications.

 

With that said, I would perhaps be willing to do a very rough fix-up of the old code to get something out there. Let me take a look at the codebase to see what kind of state it's in - for EduSweep I ended up re-writing almost two-thirds from scratch but I think AUP Informant was in better shape overall.