The following one liner will export all mailboxes with size details to a csv file. Save it at as a .ps1 script for ease of use. Get-MailboxStatistics | where {$_.ObjectClass -eq “Mailbox”} | Sort-Object TotalItemSize -Descending | select-object @{expression={$_.DisplayName}},@{expression={$_.TotalItemSize.Value.ToMB()}},@{expression={$_.ItemCount}},@{expression={$_.StorageLimitStatus}} | Export-Csv mailboxes.csv
Viewing table dependencies will show you what SP’s depend on the table, but what if you need to find those SP’s which only reference a single field. The following queries will provide you with a list of SP’s which contain the reference you are searching for. SELECT OBJECT_NAME(id) FROM syscomments WHERE [text] LIKE ‘%look for me%’Read more about How to search all Stored Procedures for a reference[…]
To suppress the rows affected message from printing use the following TSQL statement: SET NOCOUNT ON
The exchange management console defaults to the currently logged in domain. If you’ve got multiple Active Directory domain trees in your forest this poses problems when managing mailboxes from the other domain trees. To view all of the domains in the exchange console you need to select the Recipient Configuration container, and from the actions scopeRead more about Managing multiple domain trees in the exchange console[…]