A question which was posed a few weeks ago was how to find out which users/archives have failed indices. We can find that out from SQL with a simply query as follows :
SELECT ArchiveName AS 'Archive',CountFailedIndexVolumes AS 'Failed Volumes' FROM IndexView WHERE CountFailedIndexVolumes != 0
Hope that proves useful.
(Thanks to Frank Beck for the SQL)