If you want to clean up your SharePoint environment, the first step is to get an overview, what is currently part of your environment. For this purpose I wrote two scripts for SharePoint Online and SharePoint Server.

https://sposcripts.com/get-all-sites-and-subsites/