Monitoring Outlook in cached mode
So I've been rather remiss answering mails that come in with technical questions concerning Exchange or LCS. Usually the questions involve just a quick search and a reply mail straight back with the link to the document /white paper/ kb article. Some of these mails are failry complicated - descriptions of architectures, and quite complex queries.
But this one had me stumped for a while. Rachel asked if it was possible to find out how she could monitor Outlook users and identify those running in cached mode. Additionally she wanted to identify the top ten users fr sending and receiving messages. I recommended the usual perfmon counters but then I remembered something today that took me down a different route. The SQL reporting pack for Exchange which fite quite nicely with Quests tool for managing Exchange
This Report Pack includes the following reports:
Current - All Mailboxes (By Folder)
Shows folder statistics over all folders. Tip: Be on the lookout for especially large mailboxes.
Current - Folder Tree Sizes (By User)
Shows the folder tree and size of items contained within each folder of a specific user's folder. Drill down for breakdown. Tip:Find the largest folders and the largest items so you can free up space.
Folder Tree Sizes (All)
Shows the folder tree and size of items contained within each folder for all user's folders since the last extraction. Drill down for breakdown. Tip: Find the largest folders and the largest items so you can free up space.
Outgoing - Sent E-mails for User (Plain Table)
Compares the number of items found in users' Sent Items box. Tip: The highest send the most e-mail, which often correlates to the hardest workers.
Outgoing Sent E-mails for User (With Graph)
Compares the number of items found in users' Sent Items box. Tip: The highest send the most email, which often correlates to the hardest workers.
Outgoing Sent E-mails for User (With Bar Chart)
Compares the number of items found in users' Sent Items box. Drill down for breakdown. Tip: The highest send the most email, which often correlates to the hardest workers.
Outgoing - Busy Receivers of Our E-mail
The top 50 people who were sent email from members of our organization.
Incoming - Received E-mails for User (By Date)
Compares the number of items found in users' Sent Items box. Drill down for breakdown. Tip: The highest receive the most e-mail, they probably stress out the most.
Incoming - Busy Receivers of Incoming E-mail
Shows how many emails were received into peoples' inbox.
Outgoing - By Keyword
Examines the content of mail items to indicate which key phrases are being used by employees based on items in their Sent Items folders. Tip: Configure with your product names to see the e-mail activity by product.
Outgoing - Largest E-mail Senders
Shows the people who sent e-mail with the largest sizes.
Extraction Log (All Records)
Shows all of the Extraction Log records, including time to extract data from Exchange and store to the database for each user.
Extraction Log (Last Extraction)
Shows the Extraction Log records for the most recent extraction, including time to extract data from Exchange and store to the database for each user.