Can we get all active campaign reviewers report

mcheek · November 19, 2024, 2:11pm

You can achieve this using the PowerShell SDK

Here is a sample script I came up with

$reportOutput = @()
$campaignfilter = "status eq `"ACTIVE`""

$campaigns = Invoke-Paginate  -Function "Get-ActiveCampaigns" -InitialOffset 0 -Limit 10000 -Increment 250 -Parameters @{"Filter" = $campaignfilter}
foreach ($campaign in $campaigns) {
    $certs = Invoke-Paginate  -Function "Get-IdentityCertifications" -InitialOffset 0 -Limit 10000 -Increment 250 -Parameters @{"Filters"  ="campaign.id eq `"$($campaign.id)`""}
    foreach ($cert in $certs) {
        $reportObject = [PSCustomObject]@{
            CampaignName = $campaign.name
            ReviewerName = $cert.reviewer.name
            DecisionsTotal = $cert.decisionsTotal
            DecisionsMade = $cert.decisionsMade
        }
        $reportOutput += $reportObject
    }
}
$reportOutput | Sort-Object CampaignName,ReviewerName

Here is a sample of the output