Sql query (sql server syntax) to return filesystem path for every attachment found in the confluence

Question

I found the following complex query for postgres:

https://www.redradishtech.com/display/KB/Confluence+attachment+filesystem+paths

But I need just a very simple query that could return the filesystem path for every attachment in the database.

ilakkuvaselvi manoharan · Answer

Thank you Nic!

Nic Brough -Adaptavist- · Answer

There is no "simple" query.  You have to derive the path from the raw data in table content and the rules in https://confluence.atlassian.com/doc/hierarchical-file-system-attachment-storage-704578486.html