How to Generate a Detailed Content Type Breakdown Report of the AEM Repository

1) Download oak-run from here

2) Generate a report against your AEM repository (AEM should be shut down, otherwise, this will just hang):

Example for 6.3
java -jar oak-run-1.6.1.jar tika --fds-path G:\AEM_6.3\author\crx-quickstart\repository\datastore --nodestore G:\AEM_6.3\author\crx-quickstart\repository\segmentstore --data-file content-dump.csv generate

Example for 6.2
java -jar oak-run-1.6.1.jar tika --segment --fds-path G:\AEM_6.3\author\crx-quickstart\repository\datastore --nodestore G:\AEM_6.3\author\crx-quickstart\repository\segmentstore --data-file content-dump.csv generate

3) Analyse the report with:
java -jar oak-run-1.6.1.jar tika --data-file content-dump.csv report

More details here.