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
officertangoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.