Use Dataverse APIs to query table and column definitions to determine which tables and columns are enabled for auditing
If you have the System Administrator or System Customizer role, you can configure tables and columns to change the auditing behavior
Audit history data is stored in the Auditing (Audit) table
Audit tables are used by native or 3rd party auditing tools that capture data changes that have occurred on a database, usually including the information on who made the change, which objects were affected by it, when it was made as well as the information on the SQL login, application and host used to make the change
Cons You can't report on data you don't have, so this structure tells you almost nothing (except for deletes) 2
Clone table Each table has a copy plus the three audit fields and every time a user changes a record the audit table gets inserted into
Pros Performs pretty well
Easy to create a row by row history that the user can dig through
One other important aspect of audit tables that hasn't been highlighted thus far, is that in addition to keeping track of who did what to which rec...26
Audit Tables are used to track transactions against a particular table or tables. They allow you to see an ongoing "log" (for lack of a better word...Best answer · 24
Audit tables are generally used when you want to track changes in sensitive/confidential tables. If there is a table that is used for pay rate and...4
