How to fetch attachment details present in Jira datacenter instance i.e. size, number of attachments present in that particular project, etc.?
Hi,
Do you have Scriptrunner?
Regards,
Jeroen
yes Jeron
Had a script for this on the shelf :-). You just need to change the JQL_QUERY variable. Be careful, test on small subset first!
import com.atlassian.jira.bc.issue.search.SearchServiceimport com.atlassian.jira.component.ComponentAccessorimport com.atlassian.jira.issue.AttachmentManagerimport com.atlassian.jira.issue.attachment.Attachmentimport com.atlassian.jira.jql.parser.JqlQueryParserimport com.atlassian.jira.web.bean.PagerFilterimport org.apache.log4j.Levelimport org.apache.log4j.Loggerdef log = Logger.getLogger("be.script")log.setLevel(Level.INFO)def JQL_QUERY = "<your-JQL>"AttachmentManager attachManager = ComponentAccessor.getAttachmentManager()SearchService searchService = ComponentAccessor.getComponent(SearchService.class)JqlQueryParser jqlParser = ComponentAccessor.getComponent(JqlQueryParser.class)def query = jqlParser.parseQuery(JQL_QUERY)def queryUser = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()def allIssues = searchService.search(queryUser, query, PagerFilter.getUnlimitedFilter()).getIssues()long totalSize = 0long totalAttachs = 0for (def issue: allIssues) { List<Attachment> issueAttachs = attachManager.getAttachments(issue) totalAttachs = totalAttachs + issueAttachs.size()for(Attachment attachment: issueAttachs) { totalSize = totalSize + attachment.getFilesize() }}log.info("Total Size => " + totalSize/1024/1024 + " MB")log.info("Total Attachments => " + totalAttachs)return "Done!"
Hope this helps!
PS: Mark your question as a Data Center question, not Cloud.
It looks like you're new here. Sign in or register to get started.
