Attachment inventory

for a successfully running site of JIRA software 7.6.2, can we have a way to summarize -

how many attached files on this site ?
a full name list of those attached files ?
any information can be brought up to end-users regarding their attachment inventory, e.g. user A, 10 attachments, file 1, file2, file3, ....file10

1 answer

Community moderators have prevented the ability to post new answers.

0 votes

Hi Quan,

In SQL you can query the fileattachment table and you'll get the following data:

Screen Shot 2017-12-29 at 1.11.05 PM.png

You can export your SQL queries as csv and generate a csv file that way if needed, e.g. using the COPY command in Postgres.

Cheers,

Branden

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thank you @somethingblue ! Happy New Year !

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.