Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Query sprawl....

Updated: 23 May 2010 | 1 comment
nstafford@cabelas.com's picture
0 0 Votes
Login to vote

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?

discussion Filed Under:

Comments

lalanderj's picture
02
Mar
2009
0 Votes 0
Login to vote

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