Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Sql query for creator of bamboo plans

Edited

Hi,

I have a sql query that details for me all new Bamboo plans created in the last 30 days.

 

select p.TITLE as 'Project',
b.TITLE as 'Plan',
b.FULL_KEY as 'Plan Key',
b.CREATED_DATE as 'Created Date'
from dbo.PROJECT p, dbo.BUILD b
where b.PROJECT_ID = p.PROJECT_ID
and BUILD_TYPE= 'CHAIN'
and b.CREATED_DATE >= CURRENT_TIMESTAMP -30

 

Is there any way this can be modified to include who the creator of the plan is?

I can;t see anything obvious linking the plans to a user in the database?

 

Thanks

1 answer

1 accepted

0 votes
Answer accepted

I think I have manged to figure it out myself....

 

select p.TITLE as 'Project',
b.TITLE as 'Plan',
b.FULL_KEY as 'Plan Key',
b.CREATED_DATE as 'Created Date',
al.USER_NAME as 'Created By'
from dbo.PROJECT p, dbo.BUILD b, dbo.AUDIT_LOG al
where b.PROJECT_ID = p.PROJECT_ID
and BUILD_TYPE= 'CHAIN'
and b.CREATED_DATE >= CURRENT_TIMESTAMP -30
and b.FULL_KEY = al.ENTITY_ID
and al.MSG = 'Plan has been created.'

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Bamboo

Bamboo Data Center 8.1 is now available

G’day Bamboo customers, Bamboo DC 8.1 is now available with it the following features and programs: SAML 2.0, OpenID Connect, and Crowd SSO In order to help admins with a simplified user manage...

204 views 0 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you