ALM Analysis Report with the number of test steps passes or failed

  • Questions
  • ALM Analysis Report with the number of test steps passes or failed
Question ID: 107336
0
0

We are in need of a test status analysis report for the number of test steps in ALM with a passed or failed status. We have multiple folders levels in the Test Lab, and we need to report on a given folder level and all of the sub-folders/test sets from that folder in Test Lab.

Marked as spam
Posted by (Questions: 217, Answers: 21)
Asked on January 12, 2017 10:05 pm
8 views
Answers (1)
0
Private answer

The query below will get you the steps passed, failed, not completed, blocked, or N/A with the most recent execution date, which prevents duplicates in the results. You may need to tweak them some to fit your needs. You can use these queries to pull the data into an Excel sheet, then have the calculations performed within the spreadsheet. I have entered them below, along with some additional info needed to prepare the queries to run.

First, you will need to access Site Admin, locate and expand the project you are wanting to export the test steps from and select the 'CYCL_FOLD' table. Record the value in the CF_ITEM_PATH column for the parent or child folder - For testing purposes, I used the Test_Folder_Parent - AAAAAA, and Test_Folder_Child - AAAAAAAAA as you will see in the queries below.

SELECT CF_ITEM_ID As 'Folder ID', CF_ITEM_NAME As 'Folder Name', TS_TEST_ID As 'Test ID', TS_NAME As 'Test Name',
RN_STATUS As 'Run Status', RN_TESTER_NAME As 'Tester Name', RN_HOST As 'Run Host', RN_RUN_ID As 'Run ID',
TC_STATUS As 'Test Run Status',
' ' + convert(varchar, sum( case ST_STATUS when 'Passed' then 1 else 0 end)) AS 'Passed',
' ' + convert(varchar, sum( case ST_STATUS when 'Failed' then 1 else 0 end)) AS 'Failed'
FROM TESTCYCL
INNER JOIN RUN ON RN_RUN_ID = (select max(RN_RUN_ID) from RUN WHERE RN_TESTCYCL_ID = TC_TESTCYCL_ID)
AND (select count(RN_RUN_ID) from RUN WHERE RN_TESTCYCL_ID = TC_TESTCYCL_ID) > 1
INNER JOIN TEST ON TC_TEST_ID = TS_TEST_ID
INNER JOIN CYCLE ON TC_CYCLE_ID = CY_CYCLE_ID
INNER JOIN CYCL_FOLD ON CF_ITEM_ID = CY_FOLDER_ID
INNER JOIN STEP ON ST_RUN_ID = RN_RUN_ID AND ST_TEST_ID = TS_TEST_ID
WHERE CF_ITEM_PATH IN ('AAAAAA', 'AAAAAAAAA')
GROUP BY TS_TEST_ID, CF_ITEM_NAME, CF_ITEM_ID, CY_CYCLE, TS_NAME, RN_STATUS, RN_HOST, RN_TESTER_NAME, RN_RUN_ID, TC_STATUS

Marked as spam
Posted by (Questions: 2, Answers: 278)
Answered on January 12, 2017 10:08 pm