report listing the scheduled builds times for all Bamboo plans

Is there a way I can generate dynamically a report listing the scheduled builds times for all Bamboo plans that have either "Single Daily Build" or "Cron Based Scheduling" triggers?

1 answer

1 accepted

0 votes
Accepted answer

Hi Roy,

I am wondering if you might find this KB useful:

Find repository type and build strategy used by each plan

It contains a SQL query that helps you retrieving this information.

I waited on accepting this because I have no way of converting that properly to an Oracle compatible query. The premise of it is sound, but its inches away from an accepted answer. It is ALMOST exactly what I needed. So close.

I may end up yet accepting this answer because noone else has anything... its just not a resolution to my issue since I can't actually use it.

Alright, I will concede that its a good answer. it didnt solve my problem, because I couldnt use it (I have Oracle DB) - but its the right answer for someone else.

Suggest an answer

Log in or Sign up to answer
Community showcase
Asked Dec 06, 2018 in Jira Ops

I'm John Allspaw, Ask Me Anything about incident analysis and postmortems

I'm John Allspaw, co-founder of   Adaptive Capacity Labs, where we help teams use their incidents to learn and improve. We bring research-driven methods and approaches to drive effective inciden...

5,641 views 22 17
View question

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