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 :-)
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).
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! :-)
Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...
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