Collect SharePoint sites & site collections using Powershell
We’ve recently added a new script to the Microsoft Scripting Centre that will allow you to output a full list of your SharePoint Sites & Site Collections through Powershell.
In order for this to correctly work you will need to install a couple of Pre-requisites.
Firstly you’ll need to install the SharePoint Online Management Shell, you can download this from here.
You will then need the SharePoint Foundation Client Object Model, this can be downloaded and installed from here
Once installed, run the script which you can get from the Script Centre
Enter your credentials and your SharePoint Admin url
Allow the script to complete and the output will be published in a Powershell Gridview.