Someone executed a report in Production environment and DBAs see one query running in database from past 2 hours.
In cognos, I do not see any Interactive report running.
How do I check if someone has executed a report between a certain time and that query belongs to which report?
Quote from: Ana on 30 Jan 2015 06:12:55 PM
Someone executed a report in Production environment and DBAs see one query running in database from past 2 hours.
In cognos, I do not see any Interactive report running.
How do I check if someone has executed a report between a certain time and that query belongs to which report?
What do you see if you select Background Activities?
MF.
Hi MF,
I checked immediately the background processes and I did not see any report running there.
Hi Ana,
Is the auditing option ON in your environment? If yes than querying content store can give your fair idea of query execution.
Regard,
Nishant