Bamboo scheduled plans summary

Hello,

is there a Bamboo plugin that displays the summary of every scheduled plan, and an approximate duration (like based on the averaged duration on the last x runs). A display in a table, with cell length according to this duration, would be really nice.

I have a lot of test plans that are scheduled, and so far I have to manage this document myself, and check each plan to remember when it is scheduled and how long it usually takes.

Is there something, somewhere, that could generate this doc? If not, that would be a nice feature I think :-)

Thanks

Guillaume

2 answers

1 accepted

0 vote

I don't think so, but you could create a SQL query that would do it (BUILD_DEFINITION table will be tricky, but it looks doable). You'd have to query BUILD, BUILD_DEFINITION (to find schedules) and BUILDRESULTSUMMARY (to get durations).

Thanks for your help, I will try to do that. I still think it would be a nice feature for a next Bamboo version :-)

So here is the query I'm using, it gets info about plans that are scheduled and active:

SELECT
b.BUILD_ID AS BUILD_ID,
b.FULL_KEY AS FULL_KEY,
b.BUILDKEY AS BUILD_KEY,
b.TITLE AS TITLE,
b.LATEST_BUILD_NUMBER AS LATEST_BUILD_NUMBER,
b.PROJECT_ID AS PROJECT_ID,
ExtractValue(bd.XML_DEFINITION_DATA, '/configuration/repository/change/schedule/cronExpression') AS CRON,
brs1.BUILD_DATE AS BUILD_DATE,
brs1.BUILD_COMPLETED_DATE AS BUILD_COMPLETED_DATE,
brs1.PROCESSING_DURATION AS PROCESSING_DURATION
FROM
BUILD b
INNER JOIN BUILD_DEFINITION bd ON b.BUILD_ID = bd.BUILD_ID
INNER JOIN BUILDRESULTSUMMARY brs1 ON b.FULL_KEY = brs1.BUILD_KEY
INNER JOIN (
SELECT BUILD_KEY,
MAX(BUILD_COMPLETED_DATE) AS LAST_DATE
FROM BUILDRESULTSUMMARY
GROUP BY BUILD_KEY
) as brs2 ON brs1.BUILD_KEY = brs2.BUILD_KEY AND brs1.BUILD_COMPLETED_DATE = brs2.LAST_DATE
WHERE b.BUILD_TYPE = 'CHAIN' AND b.SUSPENDED_FROM_BUILDING = 'FALSE'
AND ExtractValue(bd.XML_DEFINITION_DATA, '/configuration/selectedBuildStrategy') = 'schedule'
ORDER BY brs1.BUILD_DATE ASC

So now I can make a nice HTML tab with that.

But I still think it could be a feature in Bamboo! :-)

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 18, 2017 in Bamboo

FAQ: How to Upgrade Bamboo Server

Bamboo 5.9 will no longer be supported after June 12, 2017. What does this mean? As part of our End of Life policy, Atlassian supports major versions for two years after the first major iteratio...

1,806 views 0 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you