Do you know how to clear the management reporter report queue?
When the Management Reporter (MR) – Report Queue gets full you will periodically need to clear the queue.
Although within MR you have the ability to review the Queue Status: [Tools >> Report Queue Status]
It does not give you the access to clear or reset the Queue.
To clear the Queue, you will need to log into the SQL Management Studio with administrative privileges.
- Open a New Query
- Point to the ManagementReporter database
- Then in the New Query section type the following query
DELETE REPOSITORY WHERE StatusType<> ‘0’
- Exit SQL Management Studio
Log back into MR and check the Report Queue Status [Tools >> Report Queue Status]
The screen should be clear of all data.
This article was written by Dean Anderson, consultant at