Search This Blog

Monday, January 28, 2013

Get mailbox size exchange 2007

How to get mailbox size in exchange 2007 via PowerShell.
Very simple!
1. If you need to check mailbox size for individual use string bellow:

Get-MailboxStatistics username | ft DisplayName, TotalItemSize, ItemCount
******for more information use get-help Get-MailboxStatistics -full******

2. If you need to get mailbox size for all user use next command:

Get-MailboxStatistics | ft DisplayName, TotalItemSize, ItemCount
******To export output to the file, add > c:\mailboxsize.txt******

FOR EXAMPLE:  Get-MailboxStatistics | ft DisplayName, TotalItemSize, ItemCount > c:\mailboxsize.txt

To view more friendly output you can try to use my string:


Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label="TotalItemSize(MB)";expression = {$_.TotalItemSize.Value.ToMB()}},ItemCount > c:\mailboxsize.txt


:)


******If the command is not working run this before:******

add-pssnapin Microsoft.Exchange.Management.PowerShell.Admin

Sunday, January 20, 2013

From network drive Excel file takes long time to open (Office 2003)

Office 2003
The problem is with big excel files. When you try to open them from network drives, it takes long time to load.
For fix this issue you will be need to edit your REGISTRY.
Please follow these steps:

Please open StartRun →  and type regedit  <Enter>
Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileValidation
****(If under Excel Key, Security and FileValidation does not exist, create it.)****
Right click on key "FileValidation" New → DWORD
Under Name of DWORD type EnableOnLoad  <Enter>
Right clcik on DWORD and choose Modify.
Set Value Data 0
Click <Ok> and exit from editor. Try Open again your EXCEL File.
Should be ok. :)