Find your most used sounds in Ableton Live

Step 1: Grab DB Browser for SQLite

Step 2: Find your Ableton data directory. If you're on Windows: press windows key + R, and put in %LOCALAPPDATA%/Ableton then click Run. The stuff you're looking for will be in Live Database.

Step 3: Open one of the Live-files- files with the .db extension in the DB browser from Step 1. It shouldn't matter here, but it's good practice to open as Read Only unless you need to write. You don't here.

Step 4: Go to the Execute SQL tab.

Step 5: Paste this in:

SELECT 
  CHAR(file_type >> 24, (file_type >> 16) & 255, (file_type >> 8) & 255, file_type & 255) as type_str,
  name,
  use_count
FROM files
WHERE use_count > 0
AND (type_str, use_count) IN (
  SELECT 
    CHAR(file_type >> 24, (file_type >> 16) & 255, (file_type >> 8) & 255, file_type & 255),
    MAX(use_count)
  FROM files
  WHERE use_count > 0
  GROUP BY file_type
)
ORDER BY use_count DESC;

Step 6: Click the little play button; the little blue triangle pointing right.

Live seems to create new databases under different circumstances, so you might have multiple, and the stats will vary. Mine is pretty dull since it's almost entirely Analog Lab, EQ 8, and Super Audio Cart.