Issue

Some users may have difficulties in finding the Source and Target SharePoint URLs for their migration.

Solution

This can be achieved in PowerShell using the script below.
#Config Parameters
$AdminSiteURL="https://<sharepointtenant>-admin.sharepoint.com"
$ReportOutput="D:\Temp\SPOStorage.csv"
#Get Credentials to connect to SharePoint Admin Center
$Cred = Get-Credential
#Connect to SharePoint Online Admin Center
Connect-SPOService -Url $AdminSiteURL –Credential $Cred
#Get all Site collections
$SiteCollections = Get-SPOSite -Limit All
#Array to store Result
$ResultSet = @()
Foreach($Site in $SiteCollections)
{

#Send the Result to CSV
$Result = new-object PSObject
$Result| add-member -membertype NoteProperty -name "SiteURL" -Value $Site.URL
$Result | add-member -membertype NoteProperty -name "Allocated" -Value $Site.StorageQuota
$Result | add-member -membertype NoteProperty -name "Used" -Value $Site.StorageUsageCurrent
$Result | add-member -membertype NoteProperty -name "Warning Level" -Value $site.StorageQuotaWarningLevel
$ResultSet += $Result

}
#Export Result to csv file
$ResultSet | Export-Csv $ReportOutput -notypeinformation

Print Friendly, PDF & Email