PowerShell: Get computer name from SQL Instance name. May 6, 2016 9:29 am \ by John Perry Split a SQL Instance name to get the server name. $Computer = $SQLInstance.Split('\')[0] # or $ServersList | %{ $_.Split('\')[0] } Posted in: PowerShell