Download Campaign Remediation Status Report for bulk campaign at once

[dgandhi (Devang Gandhi)]

Is the any way to find all the revocation task generated from the campaign based on time frame of the campaign?

And

Is there any to download Campaign Remediation Status Report for multiple campaign at once instead of going through each campaign and downloading it one by one?

[mcheek (Mark Cheek)]

@dgandhi

Is there any to download Campaign Remediation Status Report for multiple campaign at once instead of going through each campaign and downloading it one by one?

This should help with that, you may just have to change the logic to loop through multiple campaigns

Powershell Script for Downloading Campaign Reports

Credit to all the contributors in the topic Getting Campaign Reports .csv (Follow Up) for helping me put this together. Couple caveats/dependencies here You need to have the PowerShell SDK installed on your machine At the time of publishing the fixes for 404 when running “Get-CampaignReports” against valid campaign id and Error when attempting to run Start-CampaignReport have been committed but not yet released, so you’ll have to manually modify your module ps1 files locally, but @tyler_m…

[KevinHarrington]

This script downloads all campaign reports for campaigns with end dates set for a specified timeframe (default = current quarter). It can download all reports in CSV and PDF formats, compiles the CSV files into one master CSV file for each report type and puts together a summary email to send to the specified recipients. The email portion is in a separate custom PowerShell module, so it will throw an error at that point.

This was developed and tested with a customer that runs over 200 campaigns per quarter (very fine-grained campaign criteria). It includes pausing periodically to avoid API throttling issues and has a retry capability built-in.

It has grown over time, so it’s not the cleanest or most intuitive code, but hopefully it makes enough sense that you can use it.
DownloadCampaignReports.ps1 (25.7 KB)