Archiving Years of Dataverse Audit History (opens in new tab)
Why the audit table is special The audit table is different from the rest of Dataverse in two ways that matter for an archive design: It’s an immutable, append-only record of who changed what, when, and from where — the closest thing Dataverse has to a forensic ledger. The valuable part of an audit row is not the row itself; it’s the diff (old value → new value, attribute mask, related-record context). The audit row stores that diff in a packed changedata column, and the bound RetrieveAuditDe...
Read the original article