DAuditTrail logs an event when a user runs a LiveReport, but is the event logged when the user initiates the report, or when the report completes and the results are displayed? This could be significantly different for long-running reports.
If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.
Long-running SQL statements won't be audited until the query is complete. The audit is written after the SQL statement has been executed and the data has been returned from the DB but before the web page has been built on the server to send the results back to the browser.
Thanks, Ian. It would be really useful if two separate events were logged in DAuditNew - one when the LiveReport was initiated, and another when the results were returned from the database....