Exchange – Using MailboxExportRequest ContentFilter for Date Queries

exchangeexchange-2013powershell

I am trying to export a mailbox to a PST. All email that was received before yesterday is what I am trying to export.

$y = ((get-date).addDays(-1)).ToShortDateString()
$exportRequest = New-MailboxExportRequest -ContentFilter {(Received -lt $y)} -mailbox userID -FilePath\\SHARED\folder\userID.pst

Something is not right here. I end up exporting the entire mailbox.

When I run a:

Get-MailboxExportRequest | Get-MailboxExportRequestStatistics | select ContentFilter

It says that my content filter is:

Received -ne $null

I am sure something is wrong with my syntax here, but I can't seem to get it.

Best Answer

It's a finicky syntax error and made worse by incorrect/unclear documentation. Please try the following --

$y = ((get-date).addDays(-1)).ToShortDateString()
$exportRequest = New-MailboxExportRequest -ContentFilter "Received -lt '$y'" -mailbox userID -FilePath \\SHARED\folder\userID.pst

Related Solutions

Powershell – How to detect when Antivirus is out-of-date with Powershell

This is dependent on the Anti-Virus software:

Does it provide logging you could parse?
Does it provide a programmatic notification of being "out of date"?
Does it provide an administrative API?

If the software logs definition/engine updates to the Windows event log you could look for the most recent update, and see when that happened. E.g. with Microsoft Security Essentials in Windows 7, this will tell me the date/time of the most recent definition update (Get-EventLog returns events in order from the event log, so the first match is the most recent):

(get-eventlog -LogName system -Source "Microsoft-Windows-WindowsUpdateClient" -InstanceId 19 |
?{$_.Message -match "Microsoft Security Essentials"} | select -first 1).TimeGenerated

Clearly the details will vary by OS and AV package.

Powershell – Kill process, then uninstall application–Can I do this with PowerShell, over 400 computers, from a txt file

While this is technically possible, there's probably a better way to go about it.

And speaking of better ways to go about it, You could do this in a GPO with a few lines of code as a startup or shutdown script, which is how I handle this. With a few more lines of code you could log the results of checking for the presence of this thing and/or uninstalling it, which would undoubtedly be useful in your compliance efforts.

If a GPO-linked startup/shutdown script's not an option for whatever reason, I think I'd use PSExec to kill the process on a list of computers read in from file and then script the uninstall in an appropriate language. Seem to me that this is a lot easier in VB, for example.

a=WshShell.RegRead("HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{2318C2B1-4965-11d4-9B18-009027A5CD4F}\UninstallString")

If a<>"" Then

WshShell.Run(a&" /S"),1,True
i=i+1

end if

(Goodbye Google Toolbar, in that example which I wrote or copied a few years back. Copied, probably. I am rather lazy.)

Without debugging the PS script you copied, I'd point out that you might be running a different PS version, different PS modules installed/loaded and/or there might be some dependencies that your XP machines don't have in place that's causing problems.

Best Answer

Related Solutions

Powershell – How to detect when Antivirus is out-of-date with Powershell

Powershell – Kill process, then uninstall application–Can I do this with PowerShell, over 400 computers, from a txt file

Related Topic