Tuesday, June 12, 2018

How to verify what are all the changes made on a specific table or form

This is a very common requirement to verify who and what all are the changes being done on a specific table or form.

For eg: I wanted to see what are all the changes made on Problem or Problem Task for last two weeks

- Run this list in application navigator  sys_update_xml.list
- Filter the data by Target Name, Table Name, Application, etc..  This will give you information about what are all the update sets loaded and by whom.

-If you need to identify all the changes on form layout, then
                        Select Type = =Form Layout
         Go through each entry payload and search for the specific field that you are looking for.
       


How to enable Audit at table level?

- System Definition -> Dictionary
- Filter the data by the table name, and modify 'Audit' field to 'true'