none
Mailbox Stats Report RRS feed

  • Question

  • Hello,

    I'm trying to run the following cmdlet on my Exchange 2013 environment and I can't figure out a way for this report to not display the hidden items (I believe MS calls it "non_ipm_data") in the results.  If I look at what I actually have in Outlook, the numbers are generally lower.  I need to find a way to exclude this "hidden data" from my results...any clue?

     Get-MailboxFolderStatistics | Where {$_.Name -match “Inbox”} | Select Name, ItemsInFolder

    Any help would be massively appreciated!

    Friday, October 23, 2015 8:00 PM

Answers

  • Hi,

    It's normal. See the Note in this document:

    A mailbox can have hidden items that are never visible to the user and are only used by applications. The Get-MailboxFolderStatistics cmdlet can return hidden items for the following values: FolderSize, FolderAndSubfolderSize, ItemsInFolder, and ItemsInFolderAndSubfolders.

    https://technet.microsoft.com/en-us/library/aa996762%28v=exchg.141%29.aspx

    And we can't exclude the hidden items from cmdlet.

    Best Regards.


    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

    Lynn-Li
    TechNet Community Support

    • Proposed as answer by Lynn-Li Monday, November 2, 2015 2:11 AM
    • Marked as answer by Lynn-Li Monday, November 9, 2015 1:15 AM
    Monday, October 26, 2015 8:30 AM

All replies

  • Because you need to tell it what mailbox(s) to look at.
     Get-MailboxFolderStatistics personnamehere | Where {$_.Name -match “Inbox”} | Select Name, ItemsInFolder
    
    
    Get-Mailbox personnamehere |  Get-MailboxFolderStatistics | Where {$_.Name -match “Inbox”} | Select Name, ItemsInFolder


    Cheers,

    Rhoderick

    Microsoft Senior Exchange PFE

    Blog: http://blogs.technet.com/rmilne  Twitter:   LinkedIn:   Facebook:   XING:

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Friday, October 23, 2015 8:40 PM
  • Thanks for the reply Rhoderick!

    Understood.  I can add a username there or if you run the command the way I listed it then it just asks you for the username you wish to query.  Regardless, if I use your method, the main part of my issue still remains regarding the hidden items.

    Regards,

    Paul

    Friday, October 23, 2015 8:56 PM
  • Hello Paul,

    Try the below command

    Get-MailboxFolderStatistics | Where {$_.Name -match “Inbox|Sent Items|Deleted Items|Junk E-Mail”} | Select Name, ItemsInFolder

    Also follow the below article

    https://technet.microsoft.com/en-us/library/aa996762%28v=exchg.160%29.aspx?f=255&MSPPError=-2147217396

    https://exchangeserverpro.com/reporting-mailbox-folder-sizes-with-powershell/

    Regards,

    Praveen

    ----------------------------------------------------------------------

    Remember to mark as helpful if you find my contribution useful or as an answer if it does answer your question.That will encourage me - and others - to take time out to help you Check out my latest blog posts @ Techrid.com

    Saturday, October 24, 2015 8:45 PM
  • Hi,

    Is there any particular reason why you are concerned about the difference between the item count in Outlook vs Exchange?

    Outlook performance can affected by the item count. More information can be found here: http://blogs.technet.com/b/exchange/archive/2005/03/14/395229.aspx.

    If you're using Outlook 2010/2013 then the recommendation is to ensure that there are not more than 50,000 items per folder and that there are not more than 500 folders. See links below:

    Thanks.


    Please mark as an answer if this answers your question

    Mark Gossa

    MCSE 2003, MCITP Enterprise Administrator 2008 R2, MCSA 2012 R2, MCTS Exchange 2010, MCTS SQL 2012, MCTS SharePoint 2007, VCP4, VCP5, CCNA

    Blog: http://markgossa.blogspot.com LinkedIn:

    Posts are provided “AS IS” without warranty of any kind, either expressed or implied.

    Sunday, October 25, 2015 8:44 PM
  • Hi Mark,

    The reason posted in my reply to Praveen in the above post.  This is a brand new implementation with only IT testers on the system for mailbox data..and not much mail at that to be honest.  For example, I have one mailbox account that should report 8 total messages but in this case, the powershell cmdlet displays 25 items in the inbox...there is a visual discrepancy there as you can see.

    My requirements are simply to run this or a similar command and report on my users item count in their inbox.  As I mentioned to Praveen, I believe this "hidden" data is referred to or called IPM or non-IPM data.  I need to filter this in my powershell query.

    Best regards,

    -Paul

    Sunday, October 25, 2015 9:42 PM
  • Thanks Praveen!  The command you've provided is similar to what I've tried but unfortunately, the results are a higher number in each mailbox folder than what is "visually" there via a mail client like Outlook.  This extra or "hidden" data is I think called IPM data??  I need to exclude this data from the results so that I have an actual representation of what the user does see.
    Sunday, October 25, 2015 9:44 PM
  • Hello Paul,

    Please follow the below article related Public Folder Mailbox Database (IPM & Non_IPM Data)

    http://blogs.technet.com/b/exchange/archive/2013/08/23/recovering-public-folder-information-in-exchange-2013.aspx

    https://technet.microsoft.com/en-us/library/aa997615(v=exchg.160).aspx

    https://technet.microsoft.com/en-us/library/ee364755%28v=exchg.150%29.aspx?f=255&MSPPError=-2147217396

    https://technet.microsoft.com/en-us/library/aa997615(v=exchg.160).aspx

    Regards,

    Praveen

    ----------------------------------------------------------------------

    Remember to mark as helpful if you find my contribution useful or as an answer if it does answer your question.That will encourage me - and others - to take time out to help you Check out my latest blog posts @ Techrid.com

    Monday, October 26, 2015 1:58 AM
  • Hi,

    It's normal. See the Note in this document:

    A mailbox can have hidden items that are never visible to the user and are only used by applications. The Get-MailboxFolderStatistics cmdlet can return hidden items for the following values: FolderSize, FolderAndSubfolderSize, ItemsInFolder, and ItemsInFolderAndSubfolders.

    https://technet.microsoft.com/en-us/library/aa996762%28v=exchg.141%29.aspx

    And we can't exclude the hidden items from cmdlet.

    Best Regards.


    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

    Lynn-Li
    TechNet Community Support

    • Proposed as answer by Lynn-Li Monday, November 2, 2015 2:11 AM
    • Marked as answer by Lynn-Li Monday, November 9, 2015 1:15 AM
    Monday, October 26, 2015 8:30 AM
  • Hi,

    This is not a solution, but just a faster method instead of using Where{}.

    Get-MailboxFolderStatistics Satyajit -FolderScope Inbox | Select Name, ItemsInFolder,ItemsInFolderAndSub

    Works if you are intested on the default folders only, custom folders don't list well here.

    Measure-Command{}
    Where:           TotalMilliseconds : 696.5636
    FolderScope:  TotalMilliseconds : 175.2369

    Regarding the hidden data, are the testing accessing a common user mailbox to check visually. Login using the actual useraccount and see what do you see. Sometimes Private Items are not visible in GUI to Delegates.

    What does Search-Mailbox reports.


    Regards,

    Satyajit

    Please“Vote As Helpful” if you find my contribution useful or “MarkAs Answer” if it does answer your question. That will encourage me - and others - to take time out to help you.


    • Edited by Satyajit321 Monday, October 26, 2015 9:35 AM
    Monday, October 26, 2015 9:31 AM
  • Thanks for the reply Lynn-Li!  Do you know of any other way I can get the results I'm looking for?  At this point I'm desperately needing this and have exhausted every means.

    Monday, October 26, 2015 11:18 AM
  • Some alternatives going the GUI way.

    Using client side PowerShell instead of Server side

    Managing an Outlook Mailbox with PowerShell:

    Use PowerShell to Data Mine Your Outlook Inbox


    Regards,

    Satyajit

    Please “Vote As Helpful” if you find my contribution useful or “Mark As Answer” if it does answer your question. That will encourage me - and others - to take time out to help you.

    Monday, October 26, 2015 11:28 AM
  • Hi,

    Please try using the EWS API to find out if this gives you a more accurate item count. See here: http://gsexdev.blogspot.co.uk/2014/08/getting-folder-sizes-and-other-stats.html.

    Thanks.


    Please mark as an answer if this answers your question

    Mark Gossa

    MCSE 2003, MCITP Enterprise Administrator 2008 R2, MCSA 2012 R2, MCTS Exchange 2010, MCTS SQL 2012, MCTS SharePoint 2007, VCP4, VCP5, CCNA

    Blog: http://markgossa.blogspot.com LinkedIn:

    Posts are provided “AS IS” without warranty of any kind, either expressed or implied.

    Monday, October 26, 2015 1:30 PM
  • Thanks for the reply Lynn-Li!  Do you know of any other way I can get the results I'm looking for?  At this point I'm desperately needing this and have exhausted every means.

    Hi,

    Perhaps, we can use MFCMAPI tool to find these hidden items under inbox folder.

    Document for reference:

    https://technet.microsoft.com/en-us/library/bb508857%28EXCHG.65%29.aspx?f=255&MSPPError=-2147217396

    Best Regards.


    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

    Lynn-Li
    TechNet Community Support

    • Proposed as answer by Lynn-Li Monday, November 9, 2015 1:15 AM
    Tuesday, October 27, 2015 7:52 AM
  • Hello Paul,

    Please try MFCMAPI tool as suggested by Lynn.

    MFCMAPI Tool : https://mfcmapi.codeplex.com/

    http://blogs.technet.com/b/outlooking/archive/2010/05/14/useful-tools-while-troubleshooting-outlook-issues-3-mfcmapi.aspx

    Regards,

    Praveen

    ----------------------------------------------------------------------

    Remember to mark as helpful if you find my contribution useful or as an answer if it does answer your question.That will encourage me - and others - to take time out to help you Check out my latest blog posts @Techrid.com

    Tuesday, October 27, 2015 6:24 PM