KB Article #101854
To Find Out How Many Messages Are in the Spam Queue
To Find Out How Many Messages Are in the Spam Queue
Summary:
The Spam Analysis Queue holds messages that are to be processed by the EMF Anti-spam engine. After messages are processed by the Anti-spam engine, they are placed into the Inbound queue for processing by the Policy Engine.
Resolution:
Running the following query in SQL Query Analyzer will tell you how many messages are currently in the Spam Analysis Queue:
USE EMFMail
SELECT COUNT(*)
FROM RelayStoreMessageHeaders WITH (NOLOCK)
WHERE queueName = 'spam'
Additional Info:
In EMF 5.6 and later, the Spam Analysis Queue has been exposed in the Web Admin under the Status page.