Return
-
Title
How to: Obtain further information for alert query. -
Description
We have an alert with the following SQL query:SELECT COUNT(*) FROM ArchiveManager.dbo.MailBox WHERE (EnableStoreManager = 1) AND (LastFolderPopulation < GETDATE() - 1)
The above query is returning a value of 1. What does this means?
-
Cause
- The Last Folder Population value (of a mailbox) indicates when the mailbox was last processed/updated.
- The above SQL query will return a value indicating the number of enabled mailboxes that were not processed by yesterday (i.e. Current date -1).
-
Resolution
- When the alert was triggered, the following SQL query will return the mailbox information related to this:
SELECT * FROM ArchiveManager.dbo.MailBox WHERE (EnableStoreManager = 1) AND (LastFolderPopulation < GETDATE() - 1)
- Using the MailboxID (from above results), locate and then inspect the respective ESM Worker log (e.g. MailboxID-XX-YYYYMMDD.wlog) for troubleshooting.