Search for runs in Logic Apps with PowerShell

search_for_runs_in_logic_apps_with_powershell.html

param ([Parameter(Mandatory=$true)][string] $ResourceGroup,
       [Parameter(Mandatory=$true)][string] $Workspace,
       [Parameter(Mandatory=$true)][string] $Workflow,
       [Parameter(Mandatory=$true)][string] $Action,
       [Parameter()][int] $Top = 1000,
       [Parameter()][int] $To = 0,
       [Parameter()][int] $From = -31
)

$query = "Type=AzureDiagnostics And resource_workflowName_s=$Workflow And resource_actionName_s=$Action And status_s=Succeeded"

$date = $(get-date)
$end = $date.AddDays($To)
$start = $date.AddDays($From)

$result = Get-AzureRmOperationalInsightsSearchResults -ResourceGroupName $ResourceGroup -Workspace $Workspace -Query $query -End $end -Start $start -Top $Top

$result.Error.Message
$searchResults = $result.Value

Write-Host ""
foreach ($sr in $searchResults)
{
    $srObj = $sr | ConvertFrom-Json
    $logicApp  = $srObj.resource_workflowName_s
    $status    = $srObj.status_s
    $runId     = $srObj.resource_runId_s
    $action    = $srObj.resource_actionName_s
    $startTime = $srObj.startTime_t
    $d = $(Get-Date $startTime).ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss")
    
   Write-Host "$d $logicApp $action $status $runId"
}
Write-Host ""