Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
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
Medium Priority
?
68 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
[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
  • 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 8

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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 16

Accepted Solution

by:
Todd Nelson earned 2000 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 8

Expert Comment

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

Author Closing Comment

by:itadminhelp
ID: 41849847
got solution
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses

722 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