Audit - Granularity

LabKey Support Forum
Audit - Granularity marcia hon  2018-09-12 10:32
Status: Closed
 

Hi,

I would like to ask you if in the Audit Log, we can see what records/variables were added/updated/deleted?

I need to have this very fine granularity.

Thanks,
Marcia

 
 
Jon (LabKey DevOps) responded:  2018-09-26 10:22
Hi Marcia,

Some of the AuditLogs have extra columns to show "Old Record Values", "New Record Values", and "Data Changes". These should allow you to see what records were there before and after a change, which includes inserts, changes, and deletes.

To enable these fields, access your Audit Log under the Admin Console, select the specific type of Audit Log you want to look at, then click the Grid button to look at the available fields. If that specific Audit Log has those fields mentioned earlier, you should be able to enable them in your view and see the information you want.

Regards,

Jon
 
marcia hon responded:  2018-09-26 10:26
Thank you Jon.

I have another related question.

I have created a custom table. How do I enable auditing for this custom table?

I tried <auditlogging>DETAILED</auditlogging> . It does not work at all.

I look forward to your expertise.

Thanks,
Marcia