Pull Report Details by Execution ID

TheLast Queryreviewed: September 28, 2026

Use this article when a team needs to pullretrieve report details offor alla specific AIQ execution ID.

What changed in this article

• Simplified the stepstitle and made the retrieval key explicit: execution ID.
• Added validation checks for execution ownership, report availability, query/API permissions, and matching UI results.
• Added caution against exposing raw query output that contains customer data, internal URLs, or environment names.

Validation workflow

1. Locate the exact execution ID from AIQ results or reporting.
2. Run the approved query or API call using Executionan IDaccount iswith givenreporting below:access.
3. Compare returned report metadata with the AIQ UI before sharing or storing it.

UseReview utp;
SELECTnote: DISTINCTAdded i.Duration,i.StartTime,i.EndTime,i.ScenarioExecutionID,t.TestcaseSummaryID,ts.TestcasePercentage,td.TestcaseName,sdef.name,sd.TotalSuccess,sd.TotalFailures,sd.MaxDuration,sd.MinDuration,sd.AvgDuration
FROMgovernance IterationPerExecutionchecks i
INNERaround JOINquery ScenarioExecutionoutput sso ONreport i.ScenarioExecutionID = 1437391897724
INNER JOIN TestcasePerIterationSummary t ON i.IterationPerExecutionID = t.IterationPerExecutionID
INNER JOIN TestcaseSummary ts ON t.TestcaseSummaryID = ts.TestcaseSummaryID
INNER JOIN TestcaseDefinition td ON ts.TestcaseDefinitionID = td.TestcaseDefinitionID
INNER JOIN SummaryData sd ON ts.SummaryEntryID = sd.SummaryEntryID
INNER JOIN StepSummary ss ON t.TestcaseSummaryID = ss.TestcaseSummaryID
INNER JOIN StepDefinition sdef ON ss.StepDefinitionID = sdef.StepDefinitionID order by sdef.name;

The Execution IDdetails can be obtainedused fromsafely outside the URL(Results Analysis page) or from the Test Controller pageUI.

Ex: Test Controller Page

The scenario Query Load Test is starting at Tue Jul 21 12:01:21 IST 2015
Execution ID = 1437460281217

Ex: URL

http://localhost:8080/Appvance/analyze.html?config=1511216891&exeId=1437391897724