Find all files in the current directory and its subdirectories, then use awk to print the first field (separated by a colon) of each line, and sort the output alphabetically.
find . -name '*.*' | xargs awk -F':' '{print $1}' | sort -u