Export Quarantine using a script

Question

I am trying to create a script that export the quarantena of the list of the day when it is runned.

To make it automatic I have to enter the user's password when connecting to the tenant (how??):

Connect-IPPSSession -UserPrincipalName ******@contoso.com -ConnectionUri https://ps.protection.outlook.com/powershell-liveid/

and include the script below which works but capture only a very low number of data.

$today=(get-date)
$keydate=$today.Date.AddDays(-1)
Get-QuarantineMessage | Where-Object {($_.receivedtime -ge $keydate) -and ($_.ReleaseStatus -ne ‘RELEASED’)} | Export-Csv -Path C:\quarantined.csv

Answer 1

Assuming(!) that the account doesn't use MFA:

Step 1:

$cred = Get-Credential
$cred | Export-Clixml -Path c:\junk\mycredential.cred

Step 2:

$cred = Import-Clixml -Path c:\junk\mycredential.cred
Connect-IPPSSession -Credential $cred -ConnectionUri https://ps.protection.outlook.com/powershell-liveid/

Answer 2

Thank you it worked.

Do you have any suggestion regarding the quarantine list?

Answer 3

Hi RichMatheisen-8856,

could you please help me to find a way to include user and password (even plan/visible) inside the script in orther to make it works without human interaction?

Do you know why the command "Get-QuarantineMessage | Where-Object {($_.receivedtime -ge $keydate)" doesn't work properly ? It is giving a low list of emails.

Answer 4

The Connect-IPPSSession takes a credential as a parameter. You can create the credential and save it to a file independently and use the file to recreate the credential in your script. The easiest way is to save the credential as an XML file.