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.
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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No problem! Glad to help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.