Is there a report of what individual users have been running reports on in the Console?
We think data went missing in a particular report, is there history of how many rows a specific report has returned on previous executions?
This SQL Query below will return the last 30 days (by default) of reports run and the results returned from each report.
select rr.[User], rr.ItemName Report, rr.StartTime, rr.TimeTakenSecs
, rr.NumRowsReturned [Rows Returned], rr.NumRowsTotal [Rows Total], rr.ReportParams [Report Parameters]
from Evt_NS_Report_Run rr
where rr.StartTime > getdate() - 30 --- returns data from last 30 days