Greetings,
Please try this power shell script:
$colItems = Get-WmiObject Win32_NetworkAdapterConfiguration -Namespace "root\CIMV2" | where{$_.IPEnabled -eq "True"} Write-Host "# --------------------------------------"Write-Host "# Local IP address information"Write-Host "# --------------------------------------"foreach($objItem in $colItems) { Write-Host "Adapter:" $objItem.Description Write-Host " DNS Domain:" $objItem.DNSDomain Write-Host " IPv4 Address:" $objItem.IPAddress[0] Write-Host " IPv6 Address:" $objItem.IPAddress[1] Write-Host " " }
I located it in the Web site:
https://www.mssqltips.com/sqlservertip/3127/sql-server-database-connectivity-testing-using-powershell/
Regards
DBASupport