Confluence Attachment Extract

Harrison Wakeman

Hi,

I'm just wondering if it is possible to extract a list of attachments along with which project space they belong to from Confluence. I understand it was possible in previous versions when a mysql or sql db was being used but know that it is depreciated is there another way ? 

 

Thanks,

Harrison

Harrison Wakeman

In case it helps anyone else out, here is the SQL 

 

select contentid, c.title, c.version, c.spaceid, s.spacename, s.spacekey 
from content c 
join spaces s on c.spaceid = s.spaceid 
where contenttype = 'ATTACHMENT' ;