/product-groups/tridion/tridion-sites/b/techweblog/posts/getting-a-list-of-binaries-and-filesizes-from-the-cm-databaseSometimes you just need to get a report of the number of binaries in the CM database and their file-size, this SQL query will do just that. SELECT IT.PUBLICATION_ID AS PublicationID, IT.ITEM_REFERENCE_ID AS ComponentID, IT.ITEM_TYPE AS ItemType, ITen-USTelligent Community 12 Non-Production