report showing audit trails for all requirements

  • Questions
  • report showing audit trails for all requirements
Question ID: 107526
0
0

is there a way to produce a sql report that shows all audit changes for all requirements ?

Marked as spam
Posted by (Questions: 18, Answers: 17)
Asked on April 11, 2017 1:28 pm
2 views
Answers (2)
0
Private answer

jgf8u12,

If you are just looking for information on who and when the changes were made you could query the AUDIT_LOG table within the project. You could use a query similar to following to do so.

SELECT * FROM AUDIT_LOG
WHERE AU_ENTITY_TYPE='REQ'
ORDER BY AU_TIME DESC

This would give you the who, when, and entity id that was changed.

Marked as spam
Posted by (Questions: 0, Answers: 297)
Answered on September 13, 2017 3:21 pm
0
Private answer

thanks but i guess what i am saying is for all requirements i'd like to generate a report that shows all changes who changed it when they changed it old/new value for the fields from the audit trails tab as opposed to having to extract this individually by requirement. If there is such a report that would help tremendously. thanks

Marked as spam
Posted by (Questions: 18, Answers: 17)
Answered on September 13, 2017 3:55 pm