[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 72
  • Last Modified:

exchange 2007 inbox report

I am running exchange 2007, I need to run a report for all mailbox size for Inbox (excluding subfolder), deleted items and Sent items Can someone provide me the command?

thanks
0
officertango
Asked:
officertango
  • 6
  • 6
2 Solutions
 
A KarelinCommented:
0
 
officertangoAuthor Commented:
I am only interested in the root level size of Inbox, not subfolders, for all mailboxes. I can't find a command string for that. Is that possible?

thanks
0
 
A KarelinCommented:
Do you want to know the size of inboxes for all mailboxes like a sum?
I think you cannot do it with one coomand.
You can do for each mailbox
Get-MailboxFolderStatistics mailboxname -FolderScope Inbox | select foldersize, folderpath | Wher
e-Object {$_.folderpath -eq "/Inbox"}
and sum them.
0
Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

 
officertangoAuthor Commented:
I want to know the inbox only, without subfolder for each mailbox. I do not want the sum of all inbox.  I hope I explained it well.

Thanx
0
 
A KarelinCommented:
Ok! Try my version of powershell command. It is only for inbox without subfolders, because with subfolders that command look like Get-MailboxFolderStatistics mailboxname -FolderScope Inbox | select FolderandSubFolderSize ...
0
 
officertangoAuthor Commented:
thanks for all your help.
I can't figure out how to get the command to run for all users. What is the command srting? Also where does the file gets dump once script finished?


thanks
inbox-sniptool.JPG
0
 
A KarelinCommented:
Create ps1 file and put this text into

$mailboxes = @(Get-Mailbox -ResultSize Unlimited)
$report = @()

foreach ($mailbox in $mailboxes)
{
    $inboxstats = Get-MailboxFolderStatistics $mailbox -FolderScope Inbox | Where-Object {$_.folderpath -eq "/Inbox"}

    $mbObj = New-Object PSObject
    $mbObj | Add-Member -MemberType NoteProperty -Name "Display Name" -Value $mailbox.DisplayName
    $mbObj | Add-Member -MemberType NoteProperty -Name "Inbox Size (Mb)" -Value $inboxstats.FolderSize
    $report += $mbObj
}

$report

Open in new window


then run into exchange managment shell eg c:\scripts\mailboxstats.ps1
0
 
officertangoAuthor Commented:
I created a mailboxstats.ps1 file with the text that you sent and placed on desktop of server, than I open Exchange management Shell and ran mailboxstats.ps1. It completed the script but I do not know where the output file is. It is not on desktop??

thanks for all your help
0
 
A KarelinCommented:
There is output in console.
0
 
officertangoAuthor Commented:
This is what I see within the powershell, and it is not completed. Does it not output to a file?


thanks
Capture10.JPG
0
 
A KarelinCommented:
Try in ps1 file instead "$report" put "$report | export-csv c:\scripts\mailboxstats.csv"
or run like mailboxstats.ps1 > c:\scripts\output.txt
0
 
officertangoAuthor Commented:
na
0

Featured Post

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

  • 6
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now