Hi All
I'm looking to use this sql from the below sql query to get the artifact sizes per deployment project Useful SQL queries | Bamboo | Atlassian Documentation
im not an SQL expert, i just steal with abandon from the internet!
The sql all works fine up until the two lines pasted below
The sql was from 2015, so have any tables changed?
<span>JOIN</span> deployment_version_item dvi <span>ON</span> <span>(</span>dv<span>.</span>deployment_version_id <span>=</span> dvi<span>.</span>deployment_version_id<span>)</span>
<span>JOIN</span> deployment_version_item_ba dvia <span>ON</span> <span>(</span>dvi<span>.</span>deployment_version_item_id <span>=</span> dvia<span>.</span>version_bam_artifact_item_id<span>)</span>
from this query
<span>SELECT</span> dp<span>.</span>name<span>,</span> <span>sum</span><span>(</span>dvia<span>.</span>artifact_size<span>)</span><span>/</span><span>1024</span> <span>AS</span> artifacts_size
<span>FROM</span> deployment_project dp
<span>JOIN</span> deployment_version dv <span>ON</span> <span>(</span>dp<span>.</span>deployment_project_id <span>=</span> dv<span>.</span>project_id<span>)</span>
<span>JOIN</span> deployment_version_item dvi <span>ON</span> <span>(</span>dv<span>.</span>deployment_version_id <span>=</span> dvi<span>.</span>deployment_version_id<span>)</span>
<span>JOIN</span> deployment_version_item_ba dvia <span>ON</span> <span>(</span>dvi<span>.</span>deployment_version_item_id <span>=</span> dvia<span>.</span>version_bam_artifact_item_id<span>)</span>
<span>GROUP</span> <span>BY</span> dp<span>.</span>name
