SQL to find the highest number of attachment revisions in Confluence?

Question

Is there any SQL (MySQL preferably) that one can run to find the attachments that have the highest number of revisions in Confluence? (I'm using 4.2 currently)

FelipeA · Accepted Answer

Hi Ed,

I believe this is what you're looking for:

SELECT *,
       MAX(ATTVERSION)
FROM ATTACHMENTS
GROUP BY TITLE
ORDER BY ATTVERSION DESC;

Please let me know if this works for you.

Best regards,

Felipe Alencastro