Tuesday, September 15, 2015

Empty the Kaseya Email Queue

 on  with No comments 
In ,  
One of the problems I've seen with Kaseya is that when it is offline or loses it's network connectivity for a significant amount of time, it will assume that every machine with an agent is offline rather than it being the one that was offline. Depending on your configuration, this could result in dozens, or hundreds of emails being sent out once connectivity has been restored. This used to be easily solved by deleting the contents of a single folder on the Kaseya server, but it's not quite that simple any more. Here's what you can do. It's unsupported by Kaseya, but its worked fine for me a number of times.

First you'll need to open up SQL Server Management Studio on the server that hosts the ksubscribers database. Once this is up and you've logged into your database instance, on the left side of the screen, highlight the ksubscribers database and then press the button for "New Query" along the top. Enter these two lines into the query window that comes up, and then press "Execute."

TRUNCATE TABLE emailstatus;
DELETE FROM email;



It'll run for a few minutes, depending on the size of your database, and then that's it. Ideally you should run this before starting up the Kaseya core services to avoid any emails going out, but the sooner you can run it, the fewer emails there will be. Remember, Kaseya doesn't send them all out in one big bulk operation, it sends them in batches.
Share:

0 comments:

Post a Comment

Discuss this post!