powershellImportServerNames.ps1#blog

篇首语：本文由编程笔记#小编为大家整理，主要介绍了powershell Import-ServerNames.ps1 #blog相关的知识，希望对你有一定的参考价值。

$servers = @()
$regservers = Invoke-sqlcmd -ServerInstance GSVSQL33\SQL21 -Query "SELECT server_name FROM msdb.dbo.sysmanagement_shared_registered_servers_internal"
$regservers |
ForEach-Object {
$servnameparts = $_.server_name.Split(@("\"),[System.StringSplitOptions]::None)
$serverName = $servnameparts[0]
if(Test-Connection -ComputerName $serverName -Quiet -Count 1){
try {
Invoke-Sqlcmd -ServerInstance $_.server_name -Query "SELECT SERVERPROPERTY(&＃39;computernamephysicalnetbios&＃39;) AS servername" |
ForEach-Object {
if(-not $servers.Contains($_.servername)){
$servers += $_.servername
}
}
}
catch {
Write-Verbose "Server $serverName is unreachable"
}
}
}
$servers | Out-File .\servers.txt