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 · Accepted solution]

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!

[Brian Spence]

That did it, many thanks.  Wish that table also had the filter name to make it easier, but I can get there with the ID.

[105349]

No problem!  Glad to help.