dbatools

0.8.901

internal/Resolve-SqlIpAddress.ps1

                                Function Resolve-SqlIpAddress

{

    [CmdletBinding()]

    param (

        [Parameter(Mandatory = $true)]

        [Alias("ServerInstance", "SqlInstance")]

        [object]$SqlServer,

        [System.Management.Automation.PSCredential]$SqlCredential

    )

    $server = Connect-SqlServer -SqlServer $SqlServer -SqlCredential $SqlCredential

    $servernetbios = $server.ComputerNamePhysicalNetBIOS

    $ipaddr = (Test-Connection $servernetbios -count 1).Ipv4Address

    return $ipaddr

}