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.
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.
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.