How to find the number of jobs in the Bamboo Data Center queue from the database
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
The steps outlined on this article are provided AS-IS. This means we've had reports of them working for some customers — under certain circumstances — yet are not officially supported, nor can we guarantee they'll work for your specific scenario.
You may follow through and validate them on your own non-prod environments prior to production or fall back to supported alternatives if they don't work out.
We also invite you to reach out to our Community for matters that fall beyond Atlassian's scope of support!
Summary
If you would like to know how many builds and deployment jobs that has been queued in Bamboo you can check the Build Activity page.
Alternatively if you would like to query Bamboo database you can use the below SQL.
Environment
Bamboo Data Center 9+
Tested on Postgres Database.
Solution
The query combines the build jobs and deployment jobs in the queue.
SELECT LIFE_CYCLE_STATE,
SUM(TOTAL_COUNT) AS TOTAL_COUNT
FROM (SELECT LIFE_CYCLE_STATE,
COUNT(*) AS TOTAL_COUNT
FROM BUILDRESULTSUMMARY B
WHERE BUILD_TYPE = 'BUILD'
GROUP BY LIFE_CYCLE_STATE
UNION ALL
SELECT LIFE_CYCLE_STATE,
COUNT(*) AS TOTAL_COUNT
FROM DEPLOYMENT_RESULT DR
GROUP BY LIFE_CYCLE_STATE) AS COMBINED_RESULTS
GROUP BY LIFE_CYCLE_STATE;Below are the sample values that life_cycle_state column can contain.
- Pending: The build pending status - as long as the build is not queued
- Queued: The build is queued, as long as agent hasn't started the build process
- InProgress: The build is really building, so once checkout started on agent
- Finished: The Build finished
- NotBuilt: The Build was not built
Sample outcome of the above query shows as below.
