Skip to content
Advertisement

Tag: audit

Identifying specific changes via audit table

I have an audit table in a SQL database that is structured like the one below: audit_id id location location_sub location_status dtm_utc_action action_type 2144 2105 9 1 1 2022-09-08 12:36 i 4653 2105 9 1 1 2022-09-08 13:53 u 7304 2105 10 2 2 2022-09-13 15:51 u 7326 2105 11 1 2 2022-09-14 10:06 u I’m trying to write a

Advertisement