You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I want to track the times it takes to deploy a project. (self-hosted Bamboo)
Through the web I can look at the logs and see who started(or stopped) a deploy, when it started, how long it ran, and if it succeeded or failed. All great stuff!
I want to find this data either in a report built in, or point me to where I can get physical access to these logs so that I can parse them and get the data/trending myself.
What I want to do is see how the changes we make affect the deployment runtime. Did the change I just made significantly change the deploy time? Are the times getting progressively longer? Etc. Bonus would be to also see if it succeeded or Failes and if it was manually stopped.
Hello @Aaron Johnson,
Welcome to Atlassian Community!
You can try the following SQL. It works on PostgreSQL.
SELECT DR.VERSION_ID Version_id,
FROM DEPLOYMENT_ENVIRONMENT DE
JOIN DEPLOYMENT_RESULT DR
ON DR.ENVIRONMENT_ID = DE.ENVIRONMENT_ID
JOIN DEPLOYMENT_VERSION DV
ON DV.DEPLOYMENT_VERSION_ID = DR.VERSION_ID
JOIN DEPLOYMENT_PROJECT DP
ON DP.DEPLOYMENT_PROJECT_ID = DV.PROJECT_ID
WHERE DR.EXECUTED_DATE = (SELECT Max(EXECUTED_DATE)
WHERE VERSION_ID = DR.VERSION_ID
AND ENVIRONMENT_ID = DE.ENVIRONMENT_ID)
AND ( ( DR.EXECUTED_DATE <= '2023-01-01 00:00:00' )
OR DR.EXECUTED_DATE IS NULL )
ORDER BY DR.EXECUTED_DATE DESC,
It has a date filter (current set to 2023 it will capture anything) but you can set it to a specific period to ease the filtering.
Then, you will need to understand the values from the *_date tables and do your reporting.
Atlassian Support APAC