locked
Boking statistics in Exchange 2007 RRS feed

  • Question

  • Hi folks!

    Is there any way to get statistics to see how often a resources calender (a room) has been booked the last month using PowerShell or other management tool?

    I really appreciate any help you can provide.

    \Emilio


    Monday, February 1, 2016 8:52 AM

Answers

  • The simplest way is to determine how many items are on the calendar.  Get-MailboxFolderStatistics <Room alias> | ? { $_.FolderPath -eq '\Calendar' } will give this, but it'll return the number of items in the entire calendar, not just those from the last month.  Search-Mailbox <Room alias> -EstimateResultOnly -SearchQuery { Received:1/1/2016..2/1/2016 } will give you all items in the mailbox for the last month, but it checks all folders in the mailbox.  I think that a mailbox export will give you your best results:  New-MailboxExportRequest -Mailbox <room alias> -SourceRootFolder Calendar -FilePath <network path and file name> -ContentFilter { Received -ge '1/1/2016' -and Received -le '2/1/2016' } will give the calendar items for the last month, but they are the ones that are received for that period - not sure if you can filter by the date of the meeting.

    Will Martin ...
    -join ('77696c6c406d617274696e2d66616d696c6965732e6f7267' -split '(?<=\G.{2})' | ? { $_ } | % { [char][int]"0x$_" })

    • Proposed as answer by Allen_WangJF Tuesday, February 2, 2016 5:05 AM
    • Marked as answer by Emilio Cotroneo Tuesday, February 2, 2016 7:10 AM
    Monday, February 1, 2016 2:31 PM

All replies

  • The simplest way is to determine how many items are on the calendar.  Get-MailboxFolderStatistics <Room alias> | ? { $_.FolderPath -eq '\Calendar' } will give this, but it'll return the number of items in the entire calendar, not just those from the last month.  Search-Mailbox <Room alias> -EstimateResultOnly -SearchQuery { Received:1/1/2016..2/1/2016 } will give you all items in the mailbox for the last month, but it checks all folders in the mailbox.  I think that a mailbox export will give you your best results:  New-MailboxExportRequest -Mailbox <room alias> -SourceRootFolder Calendar -FilePath <network path and file name> -ContentFilter { Received -ge '1/1/2016' -and Received -le '2/1/2016' } will give the calendar items for the last month, but they are the ones that are received for that period - not sure if you can filter by the date of the meeting.

    Will Martin ...
    -join ('77696c6c406d617274696e2d66616d696c6965732e6f7267' -split '(?<=\G.{2})' | ? { $_ } | % { [char][int]"0x$_" })

    • Proposed as answer by Allen_WangJF Tuesday, February 2, 2016 5:05 AM
    • Marked as answer by Emilio Cotroneo Tuesday, February 2, 2016 7:10 AM
    Monday, February 1, 2016 2:31 PM
  • Thanks Will! I will try those lines.
    Have a nice day.

    \Emilio
    Tuesday, February 2, 2016 7:13 AM