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?

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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