How to view all scheduled subcriptions

Brian Spence

As an Administrator, I want to view all the schedules for filter subscriptions.  I'm looking for very large filters that are running at specific times and slowing down the system and generating excessive e-mails.

I can't imagine this is available through the UI, so if anyone has a SQL query that would return this, I would be very grateful.

105349

Hey Brian!  

Give this query a try:

SELECT * FROM filtersubscription;

Or this one:

SELECT ID, authorname, reqcontent FROM searchrequest WHERE ID IN (select FILTER_I_D from filtersubscription);

That should get you started, at least.  I found it near the bottom of this KB article:

Notification Mail Slow or Delayed

Good luck!