+ Post New Thread
Results 1 to 13 of 13
Windows Thread, Custom Logon tracking in Technical; Hi Despite my best efforts, we seem to get a lot of pupils logging onto other accounts and fiddling with ...
  1. #1
    Samson's Avatar
    Join Date
    Mar 2007
    Location
    Wales
    Posts
    201
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    17

    Custom Logon tracking

    Hi

    Despite my best efforts, we seem to get a lot of pupils logging onto other accounts and fiddling with work etc.

    Our Windows server Security logs only extend a day or so due to the sheer number of entries.

    Is there any way of creating a custom log in the windows Event View whereby it just shows Logon and Logoff details?

    i.e Date, Time, username and IP

    just simple, viewable data that will store for a month for example.

    I've noticed the event viewer's Security logs show Logon/Logoff entries 20-30 times per logon, hence why the logs get so cluttered.

    any help would be appreciated, thanks.

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181
    The easiest way is with a line like the following in a batch script:

    Code:
     echo %date%,%time%,%username%,%computername% >> \\servera\share\logons.csv
    Simple and will create huge text files.

  3. Thanks to Ric_ from:

    Samson (7th October 2008)

  4. #3

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,192
    Thank Post
    875
    Thanked 2,719 Times in 2,303 Posts
    Blog Entries
    11
    Rep Power
    780
    If you use the above method you can even automate some of the reporting from it as you can query CSV files with SQL commands like a database from VBS, ASP or .net

  5. Thanks to SYNACK from:

    Samson (7th October 2008)

  6. #4
    Samson's Avatar
    Join Date
    Mar 2007
    Location
    Wales
    Posts
    201
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    17
    That helps me greatly.

    Thanks both!

  7. #5

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,408
    Thank Post
    640
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    326
    I developed a similar thing but it stores logins in a database and has a web front-end to query users, rooms etc. Download here.

    Requires Apache/PHP/MySQL.
    Edit the include/config.inc.php and fill in the appropriate MySQL details.
    Edit the logon.vbs/logoff.vbs files to reflect the URL where you installed the web-based part.
    Place vbs files where everyone can run them and set them to run at logon and logoff.

  8. 2 Thanks to webman:

    box_l (9th October 2008), mrbios (7th October 2008)

  9. #6
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,543
    Thank Post
    363
    Thanked 264 Times in 216 Posts
    Rep Power
    101
    Webman that seems almost perfect, just got one small problem in that i cant get it workin 100%

    Is all the information meant to automaticly generate the relevant tables when someone logs on?

    So far ive got the site running and connected to the mySQL server and the logon and logoff scripts attached to a test OU but i dont think there creating anything in the database

    Error im getting: Message: MySQL Query fail: SELECT * FROM users ORDER BY username ASC MySQL Error: Table 'tracker.users' doesn't exist Date: Tuesday, October 7, 2008 at 2:30:58 PM Script: Message: Result set ID not freed. MySQL Error: Table 'tracker.users' doesn't exist Date: Tuesday, October 7, 2008 at 2:30:58 PM

    getting one like that on each section on the main screen, is it important to have a username and pssword in the logon and logoff scripts and do they need any particular privees?

    Using IIS, mySQL and PHP (with phpmyadmin for database maintainence)

  10. #7

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,258
    Thank Post
    671
    Thanked 1,644 Times in 1,466 Posts
    Rep Power
    424
    Have you run the included .sql file from phpmyadmin against your sql server to generate the tables required?

    Ben

  11. Thanks to plexer from:

    mrbios (7th October 2008)

  12. #8
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,543
    Thank Post
    363
    Thanked 264 Times in 216 Posts
    Rep Power
    101
    Quote Originally Posted by plexer View Post
    Have you run the included .sql file from phpmyadmin against your sql server to generate the tables required?

    Ben
    lol cheers

  13. #9
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,543
    Thank Post
    363
    Thanked 264 Times in 216 Posts
    Rep Power
    101
    got another issue, im using webmans logon and logoff scripts, getting this error popup:

    though we are currently having a bit of replication issue resulting in things like DNS not working properly so i reckon its possibly to do with that
    Attached Images Attached Images

  14. #10

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,408
    Thank Post
    640
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    326
    Line 53 is xml.send lcase(strFormData).. not sure what could be causing that.

    Is strHTTPUrl set to your web server address?
    Also try replacing with this line:

    Code:
    xml.send strFormData
    You don't have to log on and off all the time to test if it works, just run the script manually as a test user.

  15. #11
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,543
    Thank Post
    363
    Thanked 264 Times in 216 Posts
    Rep Power
    101
    Odd, it doesnt log anything if i run it manually on my machine

    i'll have to look into it a bit more over the next few days, for now its home time

  16. #12

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,408
    Thank Post
    640
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    326
    It logs errors to the Event Viewer if that helps.

  17. #13
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,543
    Thank Post
    363
    Thanked 264 Times in 216 Posts
    Rep Power
    101
    Found the problem with that script error webman, at the same time as me setting this up we had alot of big replication errors, we had an external contractor fixing the replication while i did this and when he fixed it it replicated an old policy which didnt have the proxy exception for the server its installed on, all sorted now though

    only other issue is getting people to show up correctly as staff and students, do i need to edit the logon/logoff scripts so that the names you have in there (EG "Student User") to what the user groups are called on our network?

SHARE:
+ Post New Thread

Similar Threads

  1. Tracking
    By Edu-IT in forum MIS Systems
    Replies: 0
    Last Post: 7th September 2008, 01:34 PM
  2. Student 'Tracking'
    By richard.thomas in forum General Chat
    Replies: 25
    Last Post: 2nd May 2008, 01:25 PM
  3. Tracking BTECs
    By stevenwitthers in forum How do you do....it?
    Replies: 0
    Last Post: 13th March 2008, 01:14 PM
  4. Asset Tracking
    By manick in forum Hardware
    Replies: 3
    Last Post: 19th September 2007, 10:16 AM
  5. Tracking Bittorent
    By binky in forum Wireless Networks
    Replies: 1
    Last Post: 7th September 2007, 12:40 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •