Testing all Linked Servers in all SQL SERVER servers with Powershell

--Create table repository SQL SERVER 
Create table tb_LinkedServersError
(server varchar(50),
dated datetime,
NameLinkedServer varchar(100),
ErrorMSG varchar(500)
) 

 
 

 

--Script PS 



[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | out-null 

$datas = [datetime] get-date -format "yyyy-MM-dd hh:mm:ss" 

##########################################################
#Dabatase and Server repository
########################################################## 

$ServidorCentral = "SERVER1\MSSQLSERVER_1"
$DatabaseCentral = "DBA" 

$sql = "truncate table tb_LinkeDServersError"
Invoke-Sqlcmd -ServerInstance $ServidorCentral -Database $DatabaseCentral -Query $sql 

foreach ($svr in get-content "C:\dadosps\servers.txt" )
{ 

 $Servidor=New-Object "Microsoft.SqlServer.Management.Smo.Server" "$svr"
 $data = $Servidor.linkedservers| where-object {$_.State -eq "Existing"} | foreach {
 trap [Exception] { 
 $erro = $_.Exception.Message
 $sql1 = "insert into tb_LinkedServersError(server,dated,NameLinkedServer,ErrorMSG) values ('$svr','$datas','$NomeLinkedServer','$erro')"
 Invoke-Sqlcmd -ServerInstance $ServidorCentral -Database $DatabaseCentral -Query $sql1
 continue; 
 }
 $NomeLInkedServer = $_.name
 $_.testconnection() 

 } 

}