In QC10, how can I find outdated tests?



  • IN HP QC 10, I'm looking to find all tests that have not had their design steps altered in the last 6 months. Having trouble finding the correct table and query to do this..... Thanks,



  • You want to use the DESSTEPS table, grouping by test ID. You can join this on the TEST table to get details on the test

    SELECT DS_TEST_ID, max(ds_vts)
    FROM DESSTEPS s inner join TEST t on s.DS_TEST_ID = t.TS_TEST_ID
    group by DS_TEST_ID
    having max(ds_vts) < DATEADD(month,-6,GETDATE())     --6 months ago
    

Log in to reply
 

Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2