• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Aug 132010

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)

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>