attachments by month

Can't figure out how to get attachment sizing trends out of JIRA.

Example:

	Unzipped		Zipped		Total Attachments by Month
Month	Files	Bytes	Files	Bytes	Files	Bytes
2014-01	2,264	2,117,700,771	575	1,608,367,762	2,839	3,726,068,533
2014-02	2,053	1,713,796,369	372	1,388,456,805	2,425	3,102,253,174

1 answer

2 votes

Here's a Groovy Script Runner sample code that will get you a nice HTML table. You can put this script into a scripted field or anywhere else that you can execute groovy code.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.AttachmentManager
import com.atlassian.jira.issue.attachment.Attachment;
import com.atlassian.jira.issue.attachment.AttachmentConstants
import com.google.common.collect.ArrayListMultimap;
import com.google.common.collect.Multimap;
import java.text.SimpleDateFormat;
import org.joda.time.DateTime
List&lt;Attachment&gt; attachments = ComponentAccessor.getOfBizDelegator().findAll(AttachmentConstants.ATTACHMENT_ENTITY_NAME).collect({
	ComponentAccessor.getAttachmentManager().getAttachment(it.getLong("id"))
})
SimpleDateFormat monthFormat =  new SimpleDateFormat("Y-MM");
Multimap&lt;String, Attachment&gt; multimap = ArrayListMultimap.create();
attachments.each({
	multimap.put(monthFormat.format(it.created),  it)
})
def zipmimes = ["application/zip"]
def lines = multimap.keySet().collect({ key -&gt;
	def atts = multimap.get(key)
	def tfiles = atts.size()
	def tbytes = String.format("%,8d%n",atts.sum{it.filesize }?:0)
	//
	def zips = atts.findAll({it.zip || zipmimes.contains(it.mimetype)})
	def zfiles = zips.size()
	def zbytes = String.format("%,8d%n",zips.sum{it.filesize}?:0)
	//
	def uzips = atts.findAll({!it.zip &amp;&amp; !zipmimes.contains(it.mimetype)})
	def uzfiles = uzips.size()
	def uzbytes = String.format("%,8d%n", uzips.sum{it.filesize}?:0)
	
	"&lt;tr&gt;&lt;td&gt;$key&lt;/td&gt;&lt;td&gt;$uzfiles&lt;/td&gt;&lt;td&gt;$uzbytes&lt;/td&gt;&lt;td&gt;$zfiles&lt;/td&gt;&lt;td&gt;$zbytes&lt;/td&gt;&lt;td&gt;$tfiles&lt;/td&gt;&lt;td&gt;$tbytes&lt;/td&gt;"
})
$/
&lt;table class="aui"&gt;
&lt;thead&gt;&lt;tr&gt;&lt;th id="month"&gt;Month&lt;/th&gt;&lt;th id="name" colspan="2"&gt;Unzipped&lt;/th&gt;&lt;th id="type" colspan="2"&gt;Zipped&lt;/th&gt;
    &lt;th id="order" colspan="2"&gt;Total Attachments by Month&lt;/th&gt;&lt;/tr&gt;&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;&lt;td&gt;Month&lt;/td&gt;&lt;td&gt;Files&lt;/td&gt;&lt;td&gt;Bytes&lt;/td&gt;&lt;td&gt;Files&lt;/td&gt;&lt;td&gt;Bytes&lt;/td&gt;&lt;td&gt;Files&lt;/td&gt;&lt;td&gt;Bytes&lt;/td&gt;${lines.join()}
&lt;/tbody&gt;
&lt;/table&gt;
/$

Here's a sample table produced by this script:

Month	Unzipped		Zipped		Total Attachments by Month
Month	Files	Bytes	Files	Bytes	Files	Bytes
2015-11	11	9,315,894	0	0	11	9,315,894
2016-01	27	6,905,986	0	0	27	6,905,986
2015-10	6	646,983	2	286,290	8	933,273
2014-03	22	2,667,618	3	1,270,255	25	3,937,873
2016-05	55	21,215,496	1	576,759	56	21,792,255
2016-04	97	24,387,805	2	233,084	99	24,620,889