in reply to Defensive Programming and Audit Trails
Trace was for things that a developer wanted to see like SQL statements, variable info, etc.
Since our support people weren't developers, they would see all the status messages -- startup, shutdown, records inserted, updated and deleted.
If an alert log was written, an email would be generated and a CriticalAlert log would generate a page to the on-call support person.
The dll did a couple of things...it would write a local log file and then broadcast the same information to a server where it was stored in a database. A service-type application would poll the database every n minutes and, depending on the severity of the error, would do nothing, email a list of people or send a page to the person on call.
It was very cool and I haven't seen anything like it since. I make sure I log things like startup, person logged in (username), things involving the data (inserts, updates, deletes) and then finally shutdown. Each entry is timestamped (do ya know how many times I've seen logs with no timestamp -- only the date?) and of course my log files are comma-delimited. It's amazing now many times I've seen people log in a format that is NOT readable with a text editor.
mike
|
---|