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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.