+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 26
General Chat Thread, Student 'Tracking' in General; Hiyo! For the past week or so Iíve been working on a method of tracking students logins and logouts, the ...
  1. #1
    richard.thomas's Avatar
    Join Date
    Sep 2007
    Posts
    491
    Thank Post
    5
    Thanked 11 Times in 10 Posts
    Rep Power
    17

    Student 'Tracking'

    Hiyo!

    For the past week or so Iíve been working on a method of tracking students logins and logouts, the day before yesterday the mySQL server survived the full day with about 1000 entries made in the day. So now I need to start work on a web GUI for this system.
    Basically Iíve started this thread because I feel that you will be able to help me add more features to this system, and eventually help me test it by having it running in your school. I donít expect this to happen for awhile as currently the system is bespoke to this schoolís setup. However, because Iím hoping to use this as my final year project for university I will require a fairly large test base.

    Currently the system stores the following data:
    Logs Username, Computer name, Login time, logout time, reason (Timeout, or proper logout), and logon server.


    A few ideas I've had for the web GUI so far are:
    • Total Number of users currently logged in
    • Total Number of users logged in throughout the current day
    • 'Quick Search' - This will enable admin to search by username or computer name
    • List ICT rooms in the school and show how many users are currently using these rooms
    • Being able to 'flag' known trouble causing users and flag them up on login
    • Pretty managerial type graphs to show room/computer usage


    In the future Iím hoping to be able to overlay some of this information over a map of the school.


    Iíd like to hear from you any other features you feel would be useful in a system like this.

    Thank you for taking the time to read this

  2. #2
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,488
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75
    It is sometimes useful to know when a particular user last logged in. Handy if they say "I tried to print the coursework at lunchtime, but the printer didn't work"...

    Another report which would be useful would be to see if/how often every PC in the IT Suite and/or Library is in use, so you could see if you need more resources in those areas to cover peak times of day.

  3. #3

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,139
    Thank Post
    403
    Thanked 622 Times in 568 Posts
    Rep Power
    181
    It would be nice to see how long each person used the computer for too, without needing to work it out yourself using the login and logout time.

  4. #4
    kestrel1's Avatar
    Join Date
    Jul 2005
    Location
    New Forest
    Posts
    294
    Thank Post
    3
    Thanked 11 Times in 11 Posts
    Rep Power
    20
    Maybe if it could flag up machines that are on, but not used during the day. That way resources could be moved to better locations.

  5. #5
    richard.thomas's Avatar
    Join Date
    Sep 2007
    Posts
    491
    Thank Post
    5
    Thanked 11 Times in 10 Posts
    Rep Power
    17
    Quote Originally Posted by kestrel1 View Post
    Maybe if it could flag up machines that are on, but not used during the day. That way resources could be moved to better locations.

    I like the idea of that. It may also indicate that there's a fault with that machine.
    I'm planning on adding something like this for wireless points later on when it gets to the putting of information onto a map.


    Thanks for all your suggestions, keep them coming

  6. #6

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,931
    Thank Post
    886
    Thanked 1,692 Times in 1,471 Posts
    Blog Entries
    12
    Rep Power
    446
    I started using the database method on here. Does the job well

    Log logons

  7. #7

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,206
    Thank Post
    372
    Thanked 377 Times in 335 Posts
    Rep Power
    148
    Will this just log student users or all users? (....method of tracking students logins and logouts). It would be useful if it could track all users including admin.

    Thanks

  8. #8

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,931
    Thank Post
    886
    Thanked 1,692 Times in 1,471 Posts
    Blog Entries
    12
    Rep Power
    446
    You can set the script to any OU you like. We log every user on the Domain.

  9. #9

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,139
    Thank Post
    403
    Thanked 622 Times in 568 Posts
    Rep Power
    181
    Don't you find that Access starts to complain after a while and you have to create a new database for the script to store information in?

  10. #10

    Join Date
    Jul 2007
    Location
    Nottingham
    Posts
    196
    Thank Post
    19
    Thanked 7 Times in 7 Posts
    Rep Power
    16
    The access DB is working well so far.

  11. #11

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,139
    Thank Post
    403
    Thanked 622 Times in 568 Posts
    Rep Power
    181
    Quote Originally Posted by dan400007 View Post
    The access DB is working well so far.
    How long has it been running for?

  12. #12

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,931
    Thank Post
    886
    Thanked 1,692 Times in 1,471 Posts
    Blog Entries
    12
    Rep Power
    446
    Well he has 80,000 records and still going....

  13. #13
    richard.thomas's Avatar
    Join Date
    Sep 2007
    Posts
    491
    Thank Post
    5
    Thanked 11 Times in 10 Posts
    Rep Power
    17
    I feel my thread has been hijacked a wee bit... trust someone from Rochdale.. :P

    My script uses two exe, one for login and one for logout, you can put these in who evers OU you wish!!

    Everything is stored in an mySQL database and has been running for a few days now, think its at about 5,000 records and querys are still at around 0.001 seconds.


    The web GUI is what i'm currently focusing on now, thank you for your suggestions I'm adding these into my plan as i go along

  14. #14
    Quackers's Avatar
    Join Date
    Jan 2006
    Posts
    1,318
    Thank Post
    40
    Thanked 142 Times in 117 Posts
    Rep Power
    53
    What happens if they do not logoff/shutdown , but just switch it off?

    Will the logged on count not go wrong?

  15. #15

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    A way round that would be to run at machine startup. Then log that startup time as the 'unclean' logoff time.

    That's how PAM on linux deals with it anyway (check out the 'last' command).

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Tracking BTECs
    By stevenwitthers in forum How do you do....it?
    Replies: 0
    Last Post: 13th March 2008, 01:14 PM
  2. Asset Tracking
    By manick in forum Hardware
    Replies: 3
    Last Post: 19th September 2007, 10:16 AM
  3. Tracking Bittorent
    By binky in forum Wireless Networks
    Replies: 1
    Last Post: 7th September 2007, 12:40 AM
  4. Asset Tracking/Marking
    By dave.81 in forum How do you do....it?
    Replies: 3
    Last Post: 20th June 2007, 08:24 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
  •