How to check query running in db from cognos user belongs to which report?

[Daljith]

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?

[MFGF]

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.

[Daljith]

Hi MF,

I checked immediately the background processes and I did not see any report running there.

[nishant.thakar]

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