Control Server Maintenance Programs

Before i consider the initial release of the Control server complete, i need to finish a couple more programs that will scrub the db. The big one is for accounting. I will be moving data to a history table and only keeping data from "today" (relevant to a zone's tz) in the accounting table. Since limits are reset at midnight, this will not effect control, but it will keep the table lean for faster updates. Also, this means that reports will be pulled from the history table which will prevent control updates from being delayed because someone is running a report for "all time".

I will also be adding a "Denied Report" to Zone Control. This will list all the users that have been blocked and why. In order to do this i need to run a job to minimize the denied records. A deny is recorded whenever it occurs.... this means that if a user hits refresh a hundred times, a hundred denies are recorded. Not a very useful report. I will clean it up before you see it so you can use it to adjust a user's limitations or maybe set a persistent block.