Analyse filetypes and file duplicates

Hi community is there a way to check all files located in sharepoint? - File extensions - duplicates -  ... Reason: we have stored about 3.1 milion files with a total amout of 10TB I will reduc...