Where are the scripts stored?

[Bam Boo]

We have many developers using the bamboo server, some of them are abusing it with scripts. Where are the scripts stored on the bamboo server? I need to get the inline and the regular ones too. Any ideas?

[Gabriel Ribeiro]

Hi There,

I'm sure you'll find this information in the build_definition_data column from the build_definition table in Bamboo database.  Some XML parsing skills might be needed to extract the values.

thanks

[Bam Boo]

Thank you, indeed I found the scripts there, right in the build_definition table. I guess it's time to learn some XQuery then.

[Gabriel Ribeiro]

Hi Bam Boo,

Great! If you don't mind, it would be great if you share with us the query as soon as you have it. I'm sure it will bring value to the Bamboo community. 

thanks