HP ALM-QC Daily report extraction

SIT Test Lab will extract the Test Set, test case name, executed on, Executed by and it status.

SELECT CY_CYCLE AS "Test Set",
       TS_NAME AS "Test Script Name",
       TC_ACTUAL_TESTER AS "Tester",
       TC_STATUS AS "Execution Status",
       LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10)  AS "Execution Date"
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND   TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (Cycleids)

High level summary of the metrics

SELECT CY_CYCLE,
       TC_STATUS,
       COUNT(TS_NAME)
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND   TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (cycleids)
GROUP BY CY_CYCLE, TC_STATUS
ORDER BY CY_CYCLE, TC_STATUS

SIT Execution Rate/Run Rate

SELECT CY_CYCLE,
       TC_ACTUAL_TESTER,
       TC_STATUS,
       LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10),
       COUNT(TS_NAME)
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND   TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (Cycleids)
GROUP BY CY_CYCLE, TC_ACTUAL_TESTER, TC_STATUS, TC_EXEC_DATE
ORDER BY CY_CYCLE, TC_ACTUAL_TESTER, TC_STATUS, TC_EXEC_DATE

Cumulative execution summary on daily basis.

SELECT TC_STATUS,
       COUNT(TS_NAME)
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND   TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (cycleids)
GROUP BY TC_STATUS
ORDER BY TC_STATUS

Defect report extract based on the field needed

SELECT BUG.BG_BUG_ID AS "Defect ID",
BUG.BG_USER_03 as "Application",
BUG.BG_SUMMARY AS "Summary",
BUG.BG_DETECTED_BY AS "Detected by",
LEFT(CONVERT(VARCHAR,BUG.BG_DETECTION_DATE,20),10) AS "Detected on",
BUG.BG_RESPONSIBLE AS "Assigned To",
BUG.BG_SEVERITY AS "Severity",
BUG.BG_PRIORITY AS "Priority",
BUG.BG_STATUS AS "Status",
BUG.BG_USER_01 AS "Test Environment",
BUG.BG_USER_02 AS "Test Phase",
BUG.BG_USER_09 AS "Root Cause"
FROM BUG
WHERE BUG.BG_DETECTED_IN_RCYC = 1028
/*AND BUG.BG_USER_01 = 'SIT'*/
AND BUG.BG_USER_02 = 'SIT'
ORDER BY BUG.BG_BUG_ID

Duplicate test scripts/cases were extracted from the project.

select rcyc_id as cycle_id, cycle_name,
cy_cycle_id as test_set_id, cy_cycle as test_set_name, test_id, ts_name
from testcycl t
join cycle on cy_cycle_id = tc_cycle_id
join (
select rcyc_id, rcyc_name as cycle_name, tc_test_id as test_id
from release_cycles
join testcycl on tc_assign_rcyc = rcyc_id
-- where rcyc_name = 'MY CYCLE NAME'
group by rcyc_id, rcyc_name, tc_assign_rcyc, tc_test_id
having count(tc_test_id) > 1
) multi on test_id = t.tc_test_id and tc_assign_rcyc = rcyc_id
join test on ts_test_id = t.tc_test_id
order by 2, 6, 5, 4


Comments

Post a Comment

Popular posts from this blog

Terminal Emulation – QTP Automation Testing

Terminal Emulation – QTP Automation Testing Topics to be covered 1. Basic understanding of the terminal emulator 2. Emulation terminology 3. Configuring the QTP to work with TE application 4. Automation testing methodology Basics of Emulator • Duplicates the functions of one system using a different system, so that second system behaves like a first system. • Computer simulation Example: AS400 and mainframes is a dark green color screen AS400 is introduced in the year of 1988 by IBM, formally renamed as IBM iseries but still called as AS400 is mid range server for the small business and large enterprises. It will work good within distributed network and web based applications for execution it uses OS400 ie operating systems. TN5250 Terminal emulation protocol IBM owned iseries access by TN5250 with WRQ’s reflection, humming bird’s host explorer, Cybele software’s Z scope Express 5250. AS400 is also a Mainframe which are used for large organizations, for critical applic...
Read more

Challenges while executing the test cases for large project

Defects are in Closed status but the test scripts in either Not Completed or Failed or Blocked Status. Based on the conversation with Program Director regarding this, we have followed this method to get more productivity Identify the defects which are closed and find the linked test scripts. Moved those to No Run status by updating the comment section in the test plan>>Run suite. Identified the test scripts which are in the Not completed status for more than two or three days Check the test steps status and if there is an update on those ie more than 50% of the test steps has been executed in that case need to check with the concerned tester for further update. Else move the test script to no run status. Possibility of no action on the test scripts due to concern tester is moved out of the portfolio or left the company or not feeling well or any emergency Defect is in "closed" status, so the test script is moved to "No Run" status t...
Read more

Presentation for Phd compre

__________________ 0) Agenda 1) Video Analytics - 4/5 Slides    i) Video Analytics - What?    ii) Intro and importance of video    ii) Domain Snapshots    iii) Literature Survey    iv) Research Obj    v)  Res Challenges 2) Topic 1   i) Research Objective (Existing vs new)   ii) Algorithm   iii) Experimental Analysis      A)  Data sets (Table and Graphs)      B)  Parameter setting      C) Performance Metrics      D) Outcomes  (Data and outcomes) 3) Topic 2,3,4,5 7) Conclusion 8) Reference 9) Thanks
Read more