Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,361,117
Community Members
 
Community Events
168
Community Groups

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 9.0 is now available

Hey there, Data Center community! I'm Martyna Wojtas and I am the Product Manager for Bamboo Data Center. I’m excited to share that Bamboo 9.0 is now available. We purpose-built this platform to help...

311 views 0 7
Read article

Atlassian Community Events