dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Resolve-DbaNetworkName

Returns information about the network connection of the target computer including NetBIOS name, IP Address, domain name and fully qualified domain name (FQDN).

Screenshots

Examples

To return a custom object displaying InputName, ComputerName, IPAddress, DNSHostName, Domain, FQDN for ServerA

Resolve-DbaNetworkName -ComputerName ServerA

To return a custom object displaying InputName, ComputerName, IPAddress, DNSHostName, Domain, FQDN for the SQL instance sql2016\sqlexpress

Resolve-DbaNetworkName -SqlServer sql2016\sqlexpress

To return a custom object displaying InputName, ComputerName, IPAddress, DNSHostName, Domain, FQDN for the SQL instance sql2016\sqlexpress and sql2014

Resolve-DbaNetworkName -SqlServer sql2016\sqlexpress, sql2014

To return a custom object displaying InputName, ComputerName, IPAddress, DNSHostName, Domain, FQDN for all SQL Servers returned by Get-SqlRegisteredServerName

Get-SqlRegisteredServerName -SqlServer sql2014 | Resolve-DbaNetworkName

Author

This command was created by Klaas Vandenberghe. You can find Klaas on Twitter and his blog.

Get-Help

From PowerShell, execute Get-Help Resolve-DbaNetworkName -Detailed for more information on this function.

Source Code

Want to see the source code? View Resolve-DbaNetworkName.ps1 on GitHub
 

Related commands