Our apps have what we call session messages. Usually they're messsages returned to the user after performing an operation (stored in session). This might be something like "The user 'Heldt, Ryan' has been created." or "The product 'Kitchen Sink' has been deleted." Almost every action generates a message like that. Anway, what I've done before is log those messages along with the UserID performing the operation, date/time, IP, etc. Granted it's not as granular as keeping track of which fields changed, but it can give you a pretty good idea of who was doing what in case there is a problem later on.
Ryan > -----Original Message----- > From: Eron Cohen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 31, 2007 8:56 AM > To: CF-Talk > Subject: Creating an Audit Trail > > I have a multiuser CSR application that has some audit > functionality to track certain changes to customer records > (for instance change of first name or last name, who changed > it and what was it before?). It already logs these changes, > but I think it could be more efficient. I was wondering if > anyone could comment on how they would go about doing this. > Right now, it is strictly code-based. The database is SQL > Server 2000 and the server is ColdFusion 8. > > Thank you > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
