How to retrieve audit log information of the movement of folder in the ALM Test Plan module.

  • Questions
  • How to retrieve audit log information of the movement of folder in the ALM Test Plan module.
Question ID: 107997
1
0

One of my Team move one folder from one folder to Recycle bin folder. I want to find out the audit log details that who was performed that action.

can you please help me in that query to get that information.

Marked as spam
Posted by (Questions: 113, Answers: 8)
Asked on November 1, 2017 2:10 am
33 views
Answers (1)
1
Private answer

The only place that I know of to find the information that you are looking for would be in the AUDIT_LOG table of the project.

https://alm-help.saas.hpe.com/en/12.53/api_refs/project_db/webframe.html#topic74.html

This table does not record the insert, update, or deletion of folders but does record them for the entities (ex. Tests) in the folders. Since the entities were moved to the ''Recycle Bin'' you should be able to find the tests that were moved and get the Test ID of the test. Using that information, you can query the AUDIT_LOG table to find out who moved them. This query can be run from within the Site Admin.

SELECT * FROM AUDIT_LOG
WHERE AU_ENTITY_TYPE = 'TEST' AND AU_ENTITY_ID = ###
ORDER BY AU_TIME_DESC

Marked as spam
Posted by (Questions: 0, Answers: 310)
Answered on November 1, 2017 2:12 am