Based Off of Ektron Code Library – http://developer.ektron.com/Templates/CodeLibraryDetail.aspx?id=4294967329&blogid=116
Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
Ektron File Extension Asset Inventory
Following the logic in a previous post, File Extension, this query will list Ektron asset file extensions and count them.
File Extension
If you are working in a database that has asset/file storage and need to get just the extension of the column this query will help save time.