Is there a way to determine the name of user that created, edited, and deleted Test plans in Test plan module?

  • Questions
  • Is there a way to determine the name of user that created, edited, and deleted Test plans in Test plan module?
Question ID: 107133
0
0

Is there a way to determine the name of the user that created, edited, and deleted Test plans in Test plan module?

Marked as spam
Posted by (Questions: 202, Answers: 2)
Asked on October 4, 2016 6:05 pm
7 views
Answers (1)
0
Private answer

If you want to view all tests changes, you can do that from Site Administration as follows:
From Site Administration (must have Site Admin permissions) goto Site Projects tab
*Select the project in question and click the + sign to expand the view of the tables
*Run the following query from the Audit_Log table
*Replace the default query SELECT * FROM AUDIT_LOG with
*SELECT * FROM AUDIT_LOG where au_entity_type = 'test'
*The list of items returned will include all tests, the date, and the user

To add changes to the Test Steps add an OR condition to the WHERE clause such that the query is as follows:

SELECT * FROM AUDIT_LOG where au_entity_type = 'test' or au_entity_type = 'DESSTEPS'

*If export of data is required, run the above query from SQL Query and export data (DBA assistance for this is required)

Marked as spam
Posted by (Questions: 1, Answers: 215)
Answered on October 4, 2016 6:11 pm
EyeOnTesting