$computer = "LocalHost" $namespace = "root\Microsoft\SqlServer\ComputerManagement10" Get-WmiObject -class SqlServerAlias -computername $computer -namespace $namespace