What is a good way to monitor if any tests have been deleted in a given time period?
Question ID: 105257
1
0

We have had some tests go missing in some projects. By missing I mean deleted. I assume this is by mistake most times, and most users will bring it up and say they accidently deleted such and such. This sort of thing does not happen often, but mistakes do happen and with a lot of users, you get more mistakes.

However some things don't get reported and that can just be problematic. We keep a week of backups, so it has fallen to me as a new task to go about checking to see what got deleted before a backup is written over for the next week. One would think that tests would not get deleted very often; except for when being first written perhaps, so I don't think this should ever be a lot of data to parse through.

My question then would be what is a good, quick method of checking to see what got deleted for the given week for a specific project, in regards to Tests?

Marked as spam
Posted by (Questions: 104, Answers: 0)
Asked on January 31, 2014 3:58 pm
22 views
Answers (1)
1
Private answer

Hello. Best bet would be to look in the Audio_Log table for each project and run a query to find deleted Test items. Audio_Log table is quite large as it records everything, so a good query can show you deleted Test items only, with date and user ID as well.

Log into Site Admin and select a project you wish to search within. Expand the project's tree and select the Audit_Log table.

Replace the generic display SQL query at the top with this one (or one of your variation):

SELECT * FROM AUDIT_LOG where AU_ACTION = 'DELETE' AND AU_ENTITY_TYPE = 'TEST'

This query will display user who deleted, the test ID (au_entity_ID), and the time of the deletion. As you said, Tests generally don't get deleted as a usual habit, so I would think the above should provide you with the data to know if you need to go and question an action and /or to possibly utilize a backup to retrieve any missing data.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on January 31, 2014 4:00 pm
0
Excellent query. That shows me just what I need to know.
( at January 31, 2014 6:40 pm)
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top