PowerShell script to export CSV with netBIOS name

Question

I have a script that collect network information for a list of server in text file and export to CSV. Everything works as expect but I need to get the host NETBIOS name from the the text file IP. The text file contains servers IP address as xxx.xxx.xxx.xxx. I'm really weak when it comes to scripting. Below is the script. I really appreciate for the help from the expert in here.

$InputFile = "C:\servers.txt"
$CsvFile = "C:\results.csv"
$report = @()
ForEach($Computer in (gc -Path $InputFile)){
  If(Test-Connection -ComputerName $Computer -Count 1 -ea 0) {
    $Networks = Get-WmiObject Win32_NetworkAdapterConfiguration -ComputerName $Computer | ? {$_.IPEnabled}
    ForEach($Network in $Networks) {
      $IPAddress = $Network.IpAddress[0]
      $SubnetMask = $Network.IPSubnet[0]
      $DefaultGateway = $Network.DefaultIPGateway
    }
    $MACAddress = $Network.MACAddress
    $OutputObj = New-Object -Type PSObject
    $OutputObj | Add-Member -MemberType NoteProperty -Name ComputerName -Value 
    $Computer.ToUpper()
    $OutputObj | Add-Member -MemberType NoteProperty -Name IPAddress -Value 
    $IPAddress
    $OutputObj | Add-Member -MemberType NoteProperty -Name SubnetMask -Value 
    $SubnetMask
    $OutputObj | Add-Member -MemberType NoteProperty -Name Gateway -Value 
    ($DefaultGateway -join ",")
    $OutputObj | Add-Member -MemberType NoteProperty -Name MACAddress -Value 
    $MACAddress
    $Report += ,$OutputObj
  }
 }
 Write-Output $report

Robbie Courtney · Accepted Answer · 2015-08-27 16:30:06Z

1

Add this to your loop :

$NetBiosName = Get-WmiObject  Win32_ComputerSystem -ComputerName $Computer | select -ExpandProperty name
$OutputObj | Add-Member -MemberType NoteProperty -Name "NetBiosName" -Value 
    $NetBiosName

PowerShell V2.0

    $InputFile = "c:\servers.txt"
    $CsvFile = "c:\results.csv"
    $report = @()
    ForEach($Computer in (gc -Path $InputFile)){
      If(Test-Connection -ComputerName $Computer -Count 1 -ea 0) {
        $Networks = Get-WmiObject Win32_NetworkAdapterConfiguration -ComputerName $Computer | ? {$_.IPEnabled}
        ForEach($Network in $Networks) {
          $IPAddress = $Network.IpAddress[0]
          $SubnetMask = $Network.IPSubnet[0]
          $DefaultGateway = $Network.DefaultIPGateway
        }

        $MACAddress = $Network.MACAddress
        $NetBiosName = Get-WmiObject  Win32_ComputerSystem -ComputerName $Computer | select -ExpandProperty name

        $OutputObj = New-Object -Type PSObject
        $OutputObj | Add-Member -MemberType NoteProperty -Name NetBios -Value $NetBiosName
        $OutputObj | Add-Member -MemberType NoteProperty -Name ComputerName -Value $Computer.ToUpper()
        $OutputObj | Add-Member -MemberType NoteProperty -Name IPAddress -Value $IPAddress
        $OutputObj | Add-Member -MemberType NoteProperty -Name SubnetMask -Value $SubnetMask
        $OutputObj | Add-Member -MemberType NoteProperty -Name Gateway -Value $DefaultGateway
        $OutputObj | Add-Member -MemberType NoteProperty -Name MACAddress -Value $MACAddress
        $Report += ,$OutputObj
      }
     }
     Write-Output $report

Or this, but makes the list of properties in a random order... since PS v2.0 doesn't have the [ordered] thing.

    $InputFile = "c:\servers.txt"
    $CsvFile = "c:\results.csv"
    $report = @()
    ForEach($Computer in (gc -Path $InputFile)){
      If(Test-Connection -ComputerName $Computer -Count 1 -ea 0) {
        $Networks = Get-WmiObject Win32_NetworkAdapterConfiguration -ComputerName $Computer | ? {$_.IPEnabled}
        ForEach($Network in $Networks) {
          $IPAddress = $Network.IpAddress[0]
          $SubnetMask = $Network.IPSubnet[0]
          $DefaultGateway = $Network.DefaultIPGateway
        }

        $MACAddress = $Network.MACAddress
        $NetBiosName = Get-WmiObject  Win32_ComputerSystem -ComputerName $Computer | select -ExpandProperty name

        $Props = @{
                    NETBIOS      = $NetBiosName
                    ComputerName = $Computer.ToUpper()
                    IPAddress    = $IPAddress
                    SubnetMask   = $SubnetMask
                    Gateway      = ($DefaultGateway -join ",")
                    MACAddress   = $MACAddress
                }

        $OutputObj = New-Object -Type PSObject -Property $Props
        $Report += ,$OutputObj
      }
     }
     Write-Output $report

Or best if you have PowerShell v.3.0 or later.

    $InputFile = "c:\servers.txt"
    $CsvFile = "c:\results.csv"
    $report = @()
    ForEach($Computer in (gc -Path $InputFile)){
      If(Test-Connection -ComputerName $Computer -Count 1 -ea 0) {
        $Networks = Get-WmiObject Win32_NetworkAdapterConfiguration -ComputerName $Computer | ? {$_.IPEnabled}
        ForEach($Network in $Networks) {
          $IPAddress = $Network.IpAddress[0]
          $SubnetMask = $Network.IPSubnet[0]
          $DefaultGateway = $Network.DefaultIPGateway
        }

        $MACAddress = $Network.MACAddress
        $NetBiosName = Get-WmiObject  Win32_ComputerSystem -ComputerName $Computer | select -ExpandProperty name

        $Props = [ordered]@{
                    NETBIOS      = $NetBiosName
                    ComputerName = $Computer.ToUpper()
                    IPAddress    = $IPAddress
                    SubnetMask   = $SubnetMask
                    Gateway      = ($DefaultGateway -join ",")
                    MACAddress   = $MACAddress
                }

        $OutputObj = New-Object -Type PSObject -Property $Props
        $Report += ,$OutputObj
      }
     }
     Write-Output $report

edited Aug 27, 2015 at 16:30

answered Aug 27, 2015 at 4:05

Robbie Courtney

813 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

Nguyen Over a year ago

Thank you very much, Robbie. I added Get-WmiObject Win32_ComputerSystem -Computer $Computer | Select -ExpandProperty name as you suggested but it still return with IP not computer NetBIOS name :(

Nguyen Over a year ago

I might have put the code that you suggested in the wrong place. What should I put that line of code to the script? I'm learning and have a hard time. :(

JPBlanc Over a year ago

@Nguyen, this is the solution.

Nguyen Over a year ago

Thanks a lot, JPBlanc. However, when I run the script I got an error:

Nguyen Over a year ago

"Unable to find [ordered]: make sure that the assembly containing this type is loaded. At C:\script_file: 16 char 27 $Prop = [Ordered] <<<< ${ + CategoryInfo : InvalidOperation: (ordering:String) [], RuntimException + FullyQualifiedErrorId: TypeNotFound

|

Collectives™ on Stack Overflow

PowerShell script to export CSV with netBIOS name

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related