Solved

Is it possible to supply me with a list of Exchange users and the number of items in each users "inbox" and "Sent Items" folders.

Posted on 2016-10-17
7
41 Views
Last Modified: 2016-10-19
Is it possible to supply me with a list of Exchange users and the number of items in each users "inbox" and "Sent Items" folders.

We are on Exchange 2010.
All users are on one Organisational Unit.(OU)

Any good powershell script we can use.
0
Comment
Question by:itadminhelp
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 6

Expert Comment

by:Niten Kumar
ID: 41847663
alan.reid is a user

C:\>Get-MailboxFolderStatistics alan.reid -FolderScope Inbox | Where {$_.FolderPath -eq "/Inbox"} | Select Name,FolderandSubFolderSize,ItemsinFolderandSubfolders
0
 
LVL 7

Expert Comment

by:Senior IT System Engineer
ID: 41847666
Hi IT,

I'm using this script: http://exchangeserverpro.com/powershell-script-create-mailbox-size-report-exchange-server-2010

It does more than waht you ask for, but then you can trim or edit the CSV result yourself.

Hope that help.
Get-MailboxReport.ps1.TXT
0
 
LVL 6

Expert Comment

by:Niten Kumar
ID: 41847678
To get a report for all mailboxes you can try creating a script as shown below:

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

foreach ($mailbox in $mailboxes)
{
    $inboxstats = Get-MailboxFolderStatistics $mailbox -FolderScope Inbox | Where {$_.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.FolderandSubFolderSize.ToMB()
    $mbObj | Add-Member -MemberType NoteProperty -Name "Inbox Items" -Value $inboxstats.ItemsinFolderandSubfolders
    $report += $mbObj
}

$report



Saving that as Get-InboxReport.ps1 I can then run it in the Exchange Management Shell.

[PS] C:\Scripts>.\Get-InboxSize.ps1

Output it to CSV file for further analysis.

[PS] C:\Scripts>.\Get-InboxSize.ps1 | Export-CSV inboxsizes.csv


You can modify the above script to add Sent Items folder.
0
Don't lose your head updating email signatures!

Do your end users still have the wrong email signature? Do email signature updates bore you or fill you with a sense of dread? You can make this a whole lot easier on yourself by trusting an Exclaimer email signature management solution. Over 50 million users do...so should you!

 
LVL 14

Accepted Solution

by:
Todd Nelson earned 500 total points
ID: 41847681
This will do it, with output to CSV file for each mailbox's Inbox and Sent Items.

Get-Mailbox | Get-MailboxFolderStatistics | Where-Object {$_.Name -match “Inbox|Sent Items”} | Select-Object Identity,Name,ItemsInFolder,FolderSize | Export-Csv C:\MailboxItemCount.csv -NoTypeInformation

Open in new window

0
 

Author Comment

by:itadminhelp
ID: 41849437
Got solution
0
 
LVL 7

Expert Comment

by:Senior IT System Engineer
ID: 41849442
Which one ?
0
 

Author Closing Comment

by:itadminhelp
ID: 41849847
got solution
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

If you don't know how to downgrade, my instructions below should be helpful.
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
how to add IIS SMTP to handle application/Scanner relays into office 365.

757 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now