Fetching data out of sys audit table

[hakansuri]

Hi,

we want to fetch historic incident data from sys audit table. moving forward we have implemented metrics which is populated by a BR on incident table as per business requirements.

but we still need to fetch /report on historic audit data when the metric was not created.

specifically we are looking for all update made to the incident table by members of certain group.

two possible solutions that came to my mind, create database view on audit table join them with sys user table etc, this could be still very slow.

or create a u_sys_audit table with exact same fields as audit table and populate that with some sort of back scripts.

thanks

HS

[Mike Allen]

Copy it to a test instance with audit data, then run a script in the background that populates the metric instances based on that data.   Then export your new metric instances out of test and import them into prod.