Pasted

Add-PSSnapin microsoft.sharepoint.powershell
 
$farm = Get-SPFarm
foreach ($server in $farm.Servers)
{
    foreach ($svc in $server.ServiceInstances)
    {
        if($svc -is [Microsoft.SharePoint.Administration.SPDatabaseServiceInstance])
        {
            $s = [Microsoft.SharePoint.Administration.SPDatabaseServiceInstance]$svc;
            $s.DisplayName
            $s.Parent.DisplayName
            $s.Databases|? { $_.Type -eq "Microsoft.SharePoint.Administration.SPUsageDatabase" }|% { $_.DatabaseConnectionString }
            $s.Databases|? { $_.Type -eq "Microsoft.SharePoint.Administration.SPUsageDatabase" }|Format-List
        }
    }
}