How do I pull build activity from the SQL database for each plan?

Darrell Sutherland_ghfrok

I know there's already a built in report to do this in Bamboo but wanted to know how to pull the data straight form the database for build activity by date for use in an external report.

Any help would be greatly appreciated

Robert W_noca3r

Do you have anything specific you're looking for?

 

At it's simplest:

select * from buildresultsummary order by build_date desc