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 ...
30th April 2008, 10:22 AM #1
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
IDG Tech News
30th April 2008, 10:43 AM #2
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.
30th April 2008, 11:36 AM #3
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.
30th April 2008, 11:43 AM #4
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.
30th April 2008, 01:09 PM #5
Originally Posted by kestrel1
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
30th April 2008, 05:18 PM #6
I started using the database method on here. Does the job well
30th April 2008, 07:10 PM #7
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.
30th April 2008, 07:15 PM #8
You can set the script to any OU you like. We log every user on the Domain.
30th April 2008, 08:40 PM #9
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?
30th April 2008, 08:47 PM #10
- Rep Power
The access DB is working well so far.
30th April 2008, 08:53 PM #11
How long has it been running for?
Originally Posted by dan400007
30th April 2008, 09:36 PM #12
Well he has 80,000 records and still going....
1st May 2008, 12:30 PM #13
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
1st May 2008, 12:45 PM #14
What happens if they do not logoff/shutdown , but just switch it off?
Will the logged on count not go wrong?
1st May 2008, 01:36 PM #15
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).
By stevenwitthers in forum How do you do....it?
Last Post: 13th March 2008, 01:14 PM
By manick in forum Hardware
Last Post: 19th September 2007, 10:16 AM
By binky in forum Wireless Networks
Last Post: 7th September 2007, 12:40 AM
By dave.81 in forum How do you do....it?
Last Post: 20th June 2007, 08:24 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)