Hi All,

Does anybody have a sql query to generate Test id >> Run id >> Expected result>> step description >> configuration name report from ALM 11

Please suggest I am trying the below report but its pulling the configuration name from Test plan I want it from Test lab

SELECT CYCLE.CY_CYCLE as Test_Set ,
TEST.TS_NAME as Test_Case,
rn_run_id as ‘run id’ ,
"test_configs"."TSC_NAME" AS " Configuration Name",
–st_description as Step_Description ,
–st_expected as Step_expectedresult ,
TESTCYCL.tc_actual_tester as Tester,
testcycl.tc_plan_scheduling_date as ‘Planned Esec Date’,
STEP.ST_STATUS as Step_Status ,
RN_EXECUTION_DATE as rn_exe_date,
rn_execution_time as execution_time , ,
RUN.RN_TEST_CONFIG_ID AS "Configuration ID"
FROM CYCLE, TESTCYCL, TEST, STEP, RUN ,cycl_fold ,test_configs
where CYCLE.CY_CYCLE_ID = TESTCYCL.TC_CYCLE_ID
and cf_item_path like ‘A%’
AND (TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID)
and(test_configs.TSC_TEST_ID = TESTCYCL.TC_TEST_ID)
AND (RUN.RN_TESTCYCL_ID = TESTCYCL.TC_TESTCYCL_ID)
AND (STEP.ST_RUN_ID = RUN.RN_RUN_ID)
AND TESTCYCL.TC_TESTCYCL_ID = RUN.RN_TESTCYCL_ID
and tc_cycle_id = cy_cycle_id
and cf_item_id = cy_folder_id
ORDER BY CYCLE.CY_CYCLE, TESTCYCL.TC_TEST_ID