Query sprawl....

nstafford@cabelas.com's picture

We have lots of queries, many of which probably aren't used any more. is there a way to identify when a query was last used, and better yet how frequently queries are run?

lalanderj's picture

Query/Report...

Hello,

I don't know if that will help but if you go to "Reports", "Notification Servers Infrastructure", "Server", "Report History" within the NS Console.

The result will give you a count of reports executions last executed date and time.

You can also drilldown on a report to get every execution and number of rows returned.

RJ