In Oracle 11g, you can use a new feature called Flashback Data Archive. The good thing is that you don't need to develop anything or configuring anything in Remedy, it's all done at the database level
To know more about this feature, go here: http://www.databasejournal.com/features/oracle/article.php/3786956/article.htm Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Howard Richter Sent: Mon 10/26/09 3:59 PM To: [email protected] Subject: Looking for ways to validate or lock down and then audit foundation data changes Good morning, afternoon and evening all, Here is a question posed to BMC with no response so far. As we know all of the ITSM 7 foundation data has been placed in a number of different forms with no way of placing this data some type of lock down or good audit trail (other then the last one who modified the record). So my question to the greatest and most intelligent group of Remedy programmers that exists in this world or any world (if you believe that there is Remedy in other worlds), is "How to audit and validate changes to all foundation data and where is all of the data stored?" That is if an audit of all changes to all foundation data is requested, how could anyone provide that information, without modifying the system? I was asked the question and had some programming ideas, but the customer is trying to stay out of the box. As always thanks, , -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [email protected] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

