Return
-
Title
How to find out what queries ran on specific dates on the Playback database? -
Description
How is it possible to find what query was run on a specific date? Is this information available on a table that I can inquiry, like an audit table? -
Resolution
There isn't an audit table for the playback database.
WORKAROUND:
Create a connection to monitor the Playback instance and Windows host. In the connection properties, un-check the option "Exclude Spotlight Session...".
Once it's monitored, you can specify a date in “Show data for” drill down by selecting 'custom'. There too you can see all the statements it ran for the time specified and click on the Save Disk icon to export it to Excel (.csv).
