Hello. I have entered the query below that can be used to create a report displaying the data you are looking for. It displays the Defect ID, Status, User ID (Who made the change), Old Value, New Value, and Time for each defect that has been updated, and sorts the order of the updated defects from newest to oldest, so the latest update will be displayed first in the report. You will need to run this query in the 'Analysis Module' within ALM. To create this report, you will need to create a 'New Excel Report' within the Analysis module, then enter the script below into the 'Configuration' tab. If the 'New Excel Report' option isn't available in the Analysis module, then you will need to add the 'ENABLE_CREATE_LEGACY_EXCEL_REPORT' parameter into the 'Site Configuration' tab within Site Admin, and set the value field to 'Y'. I hope this provides the information you are looking for.
''defect''.BG_BUG_ID AS ''Defect ID'',
''defect''.BG_STATUS AS ''Status'',
''audit_log''.AU_USER AS ''User ID'',
''audit_property''.AP_OLD_VALUE AS ''OLD Value'',
''audit_property''.AP_NEW_VALUE AS ''NEW Value'',
''audit_log''.AU_TIME AS ''Time''
INNER JOIN AUDIT_LOG ''audit_log'' ON ''defect''.BG_BUG_ID = ''audit_log''.AU_ENTITY_ID
INNER JOIN AUDIT_PROPERTIES ''audit_property'' ON ''audit_log''.AU_ACTION_ID = ''audit_property''.AP_ACTION_ID
''audit_property''.AP_TABLE_NAME = 'BUG' AND
''audit_property''.AP_PROPERTY_NAME = 'Status' AND
''audit_property''.AP_NEW_VALUE IN ('Failed', 'Retest', 'Reopen')