Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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,

share|improve this question

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
share|improve this answer
I hope you don't mind but I suggested an update as the OP was asking for tests that have not been edited in the last 6 months this should be < instead of >=. +1 for the solution – Harrison Jan 30 '14 at 21:34

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.