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

[ilakkuvaselvi manoharan]

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.

[Nic Brough -Adaptavist-]

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

[ilakkuvaselvi manoharan]

Thank you Nic!