Ever wonder how the upgrade is doing?
This script checks the status of all Sharepoint-databases.
Add-PSSnapin microsoft.sharepoint.powershell
$alldatabases = get-spdatabase
write-output "Status for all databases"
$alldatabases |Sort-Object needsupgrade |select name,webapplication, canupgrade,needsupgrade |format-table -autosize
write-output "Databases needs upgrade: $(($alldatabases |where-object {$_.needsupgrade -like "true"}).count)"
write-output "Timestamp: $(get-date -format "yyyy-MM-dd.HH:mm")"
