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

Starting to look into writing my own reports by extracting ALM data into excel. After looking through the HP documentation on the ALM Database I can't find any table that shows where they are storing data on the defects that are being logged. Does anyone know where this data is being stored?

Update: I have found what they call the "bug" table and its attributes seem to follow what is tracked for defects. Can anyone confirm that the bug table is essentially the defect table?

share|improve this question
up vote 3 down vote accepted

Yup, when I extracted data on reported bugs (or defects in QC/ALM), the BUG table is where I ran my queries on.

Just to check, you can preview your query results when using the Query Builder, or just go right on ahead and generate the report. Then you can compare the content of the BUG table against what you're finding in the Defects module.

share|improve this answer

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.