I have the auditing database installed and enabled.
I need to find the long running reports in the last week or so.
I thought I had built the query correct but it didn’t return any data.
What will be criteria to pull back all the report showing the total run time?
Can you share your query? Here is mine written for SQL Server to pull all reports with a Duration_ms > 3600000 (1 hour) within the last 7 days…
SELECT *
FROM dbo.ADS_EVENT e
WHERE CONVERT (DATE, e.Start_Time) >= CONVERT (DATE, DATEADD (DAY, -7, GETDATE ()))
AND e.Duration_ms > 3600000
What Common Events do you have enabled within Auditing in the CMC? I think at minimum you would need Refresh (1003) and Run (1011).
