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

[LASER]

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 solution]

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

[LASER]

Worked perfectly, thank-you!