I am trying to create a log file for my physical files that shows me: the file name, the program making the change, the date of change, the name of the updated field, the old value, and the new value for that field. From what I've seen triggers only give you the RECORD old and new values but not FIELD values. Is there any way to get the old and new FIELD values since some of my records are pretty lengthy and I don't know how to go about tracking which particular field changed.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!