Skip to content

Instantly share code, notes, and snippets.

@amusarra

amusarra/SizeOfTheLiferayDocumentLibrary.sql

Created March 18, 2014 09:55
Show Gist options
  • Save amusarra/9616956 to your computer and use it in GitHub Desktop.
Save amusarra/9616956 to your computer and use it in GitHub Desktop.
Download ZIP
Size of the Liferay Document Library
Raw
SizeOfTheLiferayDocumentLibrary.sql
SELECT DLFILEENTRY.REPOSITORYID,
(SUM(DLFILEENTRY.SIZE_) / 1048576) SIZE_MBYTE
FROM DLFILEENTRY
GROUP BY DLFILEENTRY.REPOSITORYID
ORDER BY SIZE_MBYTE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment