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

Please note that documentation and command names may be out of date while we work furiously towards 1.0


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