Query to Pull report details using Execution ID

The Query to pull report details of all the steps using Execution ID is given below:

Use utp;
SELECT DISTINCT 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
FROM IterationPerExecution i
INNER JOIN ScenarioExecution s ON 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 ID can be obtained from the URL(Results Analysis page) or from the Test Controller page

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