Page History
...
Code Block | ||
---|---|---|
| ||
SELECT COUNT(*) AS num_attachments, AVG(CAST(ao.FILE_SIZE AS FLOAT) / 10000001048576) AS avg_filesize_Mb, SUM(CAST(ao.FILE_SIZE AS FLOAT) / 10000001048576) AS total_filesize_Mb, p.pname, p.pkey FROM project p JOIN jiraissue j ON p.id = j.project JOIN AO_8B1069_ATTACHMENT ao ON ao.ISSUE_ID = j.id GROUP BY p.pkey, p.pname; |
...
Code Block | ||
---|---|---|
| ||
SELECT COUNT(*) AS num_attachments, SUM(CAST(file_size AS FLOAT) / (1024 * 1024)) AS total_size_MB FROM AO_8B1069_ATTACHMENT; |
...
Code Block | ||
---|---|---|
| ||
SELECT ao.FILE_NAME, CAST(ao.FILE_SIZE AS FLOAT) / 10000001048576 AS filesize_Mb, p.pname, p.pkey FROM project p JOIN jiraissue j ON p.id = j.project JOIN AO_8B1069_ATTACHMENT ao ON ao.ISSUE_ID = j.id; |
...