Solved

exchange 2007 inbox report

Posted on 2014-11-11
12
68 Views
Last Modified: 2014-12-06
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
Comment
Question by:officertango
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 6
12 Comments
 
LVL 5

Assisted Solution

by:A Karelin
A Karelin earned 500 total points
ID: 40436620
0
 

Author Comment

by:officertango
ID: 40436818
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
 
LVL 5

Expert Comment

by:A Karelin
ID: 40436825
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:officertango
ID: 40436863
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
 
LVL 5

Expert Comment

by:A Karelin
ID: 40436882
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
 

Author Comment

by:officertango
ID: 40441359
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
 
LVL 5

Accepted Solution

by:
A Karelin earned 500 total points
ID: 40441763
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
 

Author Comment

by:officertango
ID: 40441847
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
 
LVL 5

Expert Comment

by:A Karelin
ID: 40441853
There is output in console.
0
 

Author Comment

by:officertango
ID: 40441865
This is what I see within the powershell, and it is not completed. Does it not output to a file?


thanks
Capture10.JPG
0
 
LVL 5

Expert Comment

by:A Karelin
ID: 40441869
Try in ps1 file instead "$report" put "$report | export-csv c:\scripts\mailboxstats.csv"
or run like mailboxstats.ps1 > c:\scripts\output.txt
0
 

Author Closing Comment

by:officertango
ID: 40485005
na
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question