How to track deletion of a row in a dataset?

LabKey Support Forum
How to track deletion of a row in a dataset? Chichero  2020-06-19 04:07
Status: Active
 

I have not found any log information that states explicitly that a particular user deleted an entry in a dataset. In our study I looked in Audit Log - Assay/Experiment Events but only found info about who created an entry, Derive sample from sampleid-X and comment with Run deleted.

Could you help me to find a log with precise information about who deleted, who created and who modified an entry in a dataset and/or a sample set?

 
 
chetc (LabKey Support) responded:  2020-07-06 17:18

Hello,

Thank you for reaching out to us!

You should be able to see Audit information for both samplesets and datasets. If you navigate to the Audit log in the Admin console, then in the dropdown select either "Dataset Events" or "Sample Set Events". You should see what you are looking for (see screenshots).

Here are some docs that explains what is tracked by category.
https://www.labkey.org/Documentation/wiki-page.view?name=audits

Let me know if you were able to find what you're looking for.

Thanks,
Chet

 
Chichero responded:  2020-08-03 01:24

Thank you very much for your reply!

As I understand the logs in the Experiment events show the deletion of a Sample Derivation Protocol and not a deletion of an entry in the Sample Set. So when e.g. I delete a sample with parents/daughters I also get their ids in some cases and therefore I can not be sure that the deletion was done in a particular sample set. Moreover if the sample does not have any Sample Derivation Protocols where the deletion is tracked? In this case I only found a row in Sample Sets events: Samples inserted or updated in: SampleSet_name when I deleted an entry.

Would it be possible to show the name of the Sample set where the deletion occurred in the logs?

 
chetc (LabKey Support) responded:  2020-08-17 14:38

Hello,

You should be able to see what sample set/type an entry was deleted out of in Sample Set Events (known as Sample Type in newer versions of labkey). In the screenshot attached you will see that I inserted and deleted a record from the "test1" sample type.

Let me know if you don't see records for delete in your audit log.

Thanks,
Chet

 
Chichero responded:  2020-08-19 02:15

Hello Chet,

Thank you for your reply!

I am still struggling to find a clear prove that a user has deleted a particular entry in a sample set.

From your screenshot I can see that Samples were deleted in a particular sample set by chetc. Would it be possible to find information which sample id exactly (a row in this sample set) was deleted?

Thanks,
Natalia

 
chetc (LabKey Support) responded:  2020-09-02 14:18
Status: Closed

Hello Natalia,

I think you need to have detailed auditing on to do that. Check out this doc on setting the audit level per table.
https://www.labkey.org/Documentation/wiki-page.view?name=audits#level

You will likely need to add that metadata to the samples table via the query browser.

Thanks,
Chet