Sort Windows Network Adapter by PCI Slot via PowerShell

4 Replies to “Sort Windows Network Adapter by PCI Slot via PowerShell”

1. David says:

   February 10, 2015 at 10:33 pm

   Hi,

   This is great stuff but I was wondering if you could help me with something. I’ve been trying with no luck to figure out how to take a csv or txt file with a list of computer names in it and passing it through the Get-NetAdapter cmdlet to give me back InterfaceDescription,DeviceName,DriverVersion,DriverDate,Signer and all I’ve been able to achieve is pulling the information from my local machine or on another attempt getting the script to pull the computer list but no network information comes back. Do you know how one could accomplish this?
   My script goes something like this:

   $arrComputers = Import-Csv C:\users\dcook\documents\computers.csv
   $Interface = Get-WmiObject Win32_NetworkAdapter
   #$Interface | foreach {$friendlyname = $_ | Select-Object -ExpandProperty NetConnectionID}
   Get-NetAdapter | Select-Object InterfaceDescription,DeviceName,DriverVersion,Signer
   “$friendlyname is $Name

   foreach ($Interface in $arrComputers){gwmi -Class win32_PnPSignedDriver -Filter | {Where $._devicename=’$Interface'” | select name, DeviceName, DriverVersion, Signer

   write-output $objItem

   My output looks like this and what I’m really hoping to do is Export-csv the results. I’m doing this for 500 computers.

   PS C:\WINDOWS\system32> C:\Users\dcook\Documents\Sccm_Reports\SCCM_Reports\TestNow.ps1

   InterfaceDescription DeviceName DriverVersion Signer
   ——————– ———- ————- ——
   Intel(R) 82574L Gigabit Network Connection \Device\{A8526C61-D366-4F3D-9152-5A505F825948} 12.12.50.4

   PS C:\WINDOWS\system32>

   It never seems to even look at the csv file or create one either. Another alternate way I’ve done this is here. It doesn’t seem to process the import the file either.

   $csvFile = “C:\users\dcook\documents\computers.csv”
   $Path = “C:\users\dcook\documents\Computers.xlxs”

   $Computers = “Import-Csv -Path $csvFile”
   $Excel = New-Object -ComObject excel.application
   $Excel.Visible =$True
   $Workbook = $Excel.workbook.add()
   $Driverswksht = $workbook.worksheets.Item(1)

   $driverswksht.Name = ‘Drivers’
   $Excel.cells.item(1,2) = “Interface Description”
   $Excel.cells.item(1.3) = “Driver Name”
   $Excel.cells.item(1.4) = “Driver Version”
   $Excel.cells.item(1.5) = “Driver Information”
   $i = 2

   #$Adapter = Get-NetAdapter -InterfaceDescription “Advanced*”, “Centrino*”, “Dual Band*”, “WiFi*”, “WiMax*” | Select Name, drivername, driverversion, driverinformation, signer
   #foreach($Computer in $Computers)
   #{
   #$Excel.cells.item($i,2) = $Computers.InterfaceDescription
   #$Excel.cells.item($i,3) = $Computers.DriverName
   #$Excel.cells.item($i,4) = $Computers.DriverVersion
   #$Excel.cells.item($i,5) = $Computers.DriverInformation
   #$i++
   #}
   #$usedrange = $Excel.Used.Range
   #$UsedRange.EntireColumn.AutoFit()

   #$workbook.saveas(“C:\users\dcook\documents\sccm_reports\drivers.xlsx”)

   Any help would be greatly appreciated.

   David

   Reply
2. David says:

   February 10, 2015 at 10:36 pm

   Oh, I forgot to put the output from the last script above.

   PS C:\WINDOWS\system32> C:\Users\dcook\Documents\Drivers.ps1
   You cannot call a method on a null-valued expression.
   At C:\Users\dcook\Documents\Drivers.ps1:8 char:1
   + $Workbook = $Excel.workbook.add()
   + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   + CategoryInfo : InvalidOperation: (:) [], RuntimeException
   + FullyQualifiedErrorId : InvokeMethodOnNull

   You cannot call a method on a null-valued expression.
   At C:\Users\dcook\Documents\Drivers.ps1:9 char:1
   + $Driverswksht = $workbook.worksheets.Item(1)
   + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   + CategoryInfo : InvalidOperation: (:) [], RuntimeException
   + FullyQualifiedErrorId : InvokeMethodOnNull

   The property ‘Name’ cannot be found on this object. Verify that the property exists and can be set.
   At C:\Users\dcook\Documents\Drivers.ps1:11 char:1
   + $driverswksht.Name = ‘Drivers’
   + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   + CategoryInfo : InvalidOperation: (:) [], RuntimeException
   + FullyQualifiedErrorId : PropertyNotFound

   You cannot call a method on a null-valued expression.
   At C:\Users\dcook\Documents\Drivers.ps1:12 char:1
   + $Excel.cells.item(1,2) = “Interface Description”
   + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   + CategoryInfo : InvalidOperation: (:) [], RuntimeException
   + FullyQualifiedErrorId : InvokeMethodOnNull

   You cannot call a method on a null-valued expression.
   At C:\Users\dcook\Documents\Drivers.ps1:13 char:1
   + $Excel.cells.item(1.3) = “Driver Name”
   + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   + CategoryInfo : InvalidOperation: (:) [], RuntimeException
   + FullyQualifiedErrorId : InvokeMethodOnNull

   You cannot call a method on a null-valued expression.
   At C:\Users\dcook\Documents\Drivers.ps1:14 char:1
   + $Excel.cells.item(1.4) = “Driver Version”
   + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   + CategoryInfo : InvalidOperation: (:) [], RuntimeException
   + FullyQualifiedErrorId : InvokeMethodOnNull

   You cannot call a method on a null-valued expression.
   At C:\Users\dcook\Documents\Drivers.ps1:15 char:1
   + $Excel.cells.item(1.5) = “Driver Information”
   + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   + CategoryInfo : InvalidOperation: (:) [], RuntimeException
   + FullyQualifiedErrorId : InvokeMethodOnNull

   PS C:\WINDOWS\system32>

   Thanks again,
   David

   Reply
3. Rawad says:

   November 15, 2017 at 1:31 pm

   this is great, thank you!

   Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.