Forum Discussion

Deleted's avatar
Deleted
Mar 27, 2018
Solved

How to filter last 30 days on Get-MailboxSearch?

Hi I have this script but I need to be able to report on the last 30 days only: $When = (get-date).AddDays(-30).ToString("dd/MM/yyyy HH:mm:ss") Get-MailboxSearch | Select Name, InPlaceHoldEnab...
  • Deleted's avatar
    Deleted
    Mar 27, 2018

    Got the solution - the date variable needs the same format as the property:

     

    $When = (get-date).AddDays(-30).ToString("MM/dd/yyyy HH:mm:ss")
    $holdsReport = Get-MailboxSearch   |  Select Name, InPlaceHoldEnabled,@{n="ExportDate";e={[datetime]($_.LastEndTime)}}| Where-Object ExportDate -GT $when | Sort-Object ExportDate -Descending
    

    M

Resources