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' ;