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

[Darrell Sutherland]

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]

Do you have anything specific you're looking for?

At it's simplest:

select * from buildresultsummary order by build_date desc