How to calculate size of each space in confluence

Saketh Reddy January 10, 2017
 

2 answers

1 accepted

1 vote
Answer accepted
Vladimir Yakimov _Botron_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 10, 2017
1 vote
Greg Della-Croce January 11, 2017

I tried the code from the first link and (with some modification of tables name[see below]) it worked great.  I now can get a list of space with attachments and get their sizes.

My question does go beyond the attachment sizes.  What can we do to get the actual size of the space itself (with or without attachments)?  

My modified code:

SELECT
    s.spacekey,
    s.SPACENAME,
    SUM(filesize)
FROM
    ATTACHMENTS_BACKUP a
JOIN CONTENT c
ON
    a.pageid = c.contentid
JOIN SPACES s
ON
    c.spaceid = s.spaceid
GROUP BY
    s.spacekey

 

 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events