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 :-)
So here is the query I'm using, it gets info about plans that are scheduled and active:
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
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 (
MAX(BUILD_COMPLETED_DATE) AS LAST_DATE
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! :-)
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
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...
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!
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