Delete Delete

This seems to be what you're aiming for:

# NOTE: If there are multiple NICs that match the wildcarded name in each Get-NetAdapter
#       this will produce unexpected results!
[PSCustomObject]@{
    Serial      = (Get-WmiObject Win32_BIOS).SerialNumber
    "PC Model"  = (Get-WmiObject -Class:Win32_ComputerSystem).Model
    Ethernet    = (Get-NetAdapter -Name Ethernet*).MacAddress
    WiFi        = (Get-NetAdapter -Name Wi-Fi*).MacAddress
    BlueTooth   = (Get-NetAdapter -Name Bluetooth*).MacAddress
} | Export-Csv -Path C:\NICs.csv -notypeinformation

Thanks, I can see your post now. Yeah, it didn't worked well when a system have more than one NIC.

You can use code like this to put all the MAC addresses for NIC using the same transport into one column:

Ethernet    = (Get-NetAdapter -Name Ethernet*).MacAddress -join ';'

Use the Get-NetAdaptor cmdlet.

Get-NetAdapter |Select Name,InterfaceDescription,MACAddress |Export-Csv -Path C:\NICINFO.csv -notypeinformation

Using the Get-NetAdapter, I am getting so many values for the Mobile Broadband, Fibocom in the below figure, is it possible to modify above code to limit /show only the Bluetooth, Wi-Fi and Ethernet(s) adapters only?

Try adding the -Physical switch to the cmdlets' parameters.

Or try it this way:

$wanted = "bluetooth*","Ethernet*","Wi-Fi*","Local Area Connection*"
Get-NetAdapter |
    ForEach-Object{
        foreach ($want in $wanted){
            if ($_.name -like $want){
                $_ | Select-Object Name,InterfaceDescription,MACAddress
            }
        }
    }

This piece of code works better and output is more cleaner now. However, I want to export the results into CSV file, adding the following line generated a csv file but only with Ethernet, and not with WiFi and Bluetooth.
|Export-Csv -Path C:\Temp2.csv -notypeinformation

I don't know how your adaptors are named. Do you? You're probably going to have to inventory your machines and then decide what names are used. If you do that, you should gather more information to complement what you think you need. Maybe add the Caption, Description, and DeviceName.

When you have a working set of data you want to collect adjust the script -- or modify it to look for the stuff you don't want export everything else.

Until you know what your dataset looks like it's not possible to write a script that does what you want because you haven't yet defined what you want (or what you don't want)!

That said, in your screenshot, the adaptor at the top of the list has name of "Bluetooth Network Connection" and "bluetooth*" is in the script I posted. That adaptor should be present in your CSV.

Hi,

I need the Machine Serial Number + MAC Addresses of the Ethernet, WiFi and Bluetooth, and save it as CSV file.
Get-NetAdapter |Select Name,InterfaceDescription,MACAddress |Export-Csv -Path C:\NICINFO.csv -notypeinformation

But problem in the above was Mobile Broadband adapter.... and then you provided a piece of code, which work better .. and issue I encounter with your script is to export it to CSV file. How to export that data into csv file?

Just add this right after the "}" on the last line if the script:

| Export-Csv -Path C:\Temp2.csv -notypeinformation

This usually works to the the machines' serial number:

(Get-WmiObject Win32_BIOS).SerialNumber

And how to generate a csv file /export together with NICs MAC + Serial Number?

Get the serial number before the Get-NetAdaptor and place it in a variable. Then add a calculated property to the Select-Object using that variable.

https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_calculated_properties?view=powershell-5.1

Did it already and I am getting only the MAC addressed not other attributes, Following approach generated output file but lacking serial number /model:

$Serial = (Get-WmiObject Win32_BIOS).SerialNumber
$Model =  (Get-WmiObject -Class:Win32_ComputerSystem).Model
$a = New-object PSobject
$a | Add-Member NoteProperty "Serial" $Serial
$a | Add-Member NoteProperty "PC Model" $Model
#MAC Addresses of Bluetooth, Ethernet, Wi-Fi
$wanted = "bluetooth*","Ethernet*","Wi-Fi*","Local Area Connection*"
Get-NetAdapter |
    ForEach-Object{
        foreach ($want in $wanted){
            if ($_.name -like $want){
                $_ | Select-Object Name,InterfaceDescription,MACAddress
            }
        }
    }| Export-Csv -Path C:\MACAddress.csv -notypeinformation

Deleted comment.

You created a variable named $a, but after adding properties to the contents of the PSOject you did nothing more with it. All you'll find in the "$_" is the output of the Get-NetAdaptor cmdlet.

$Serial = (Get-WmiObject Win32_BIOS).SerialNumber
$Model =  (Get-WmiObject -Class:Win32_ComputerSystem).Model

#MAC Addresses of Bluetooth, Ethernet, Wi-Fi
$wanted = "bluetooth*","Ethernet*","Wi-Fi*","Local Area Connection*"
Get-NetAdapter |
    ForEach-Object{
        foreach ($want in $wanted){
            if ($_.name -like $want){
                $_ | Select-Object  Name,
                                    InterfaceDescription,
                                    MACAddress, 
                                    @{n="Serial";e={$Serial}}, 
                                    @{n="PC Model";e={$Model}}
            }
        }
    }| Export-Csv -Path C:\Junk\MACAddress.csv -notypeinformation

Thanks for your reply and contribution towards my question.

However, the following approach suits best for my scenario, but downside is I am getting this unnecessary string, highlighted in red below: is it possible to get rid of it?

Your "following approach" seems to place all adaptors on a machine in a separate column, but you don't show how you've tried to accomplish this.

It looks like you've created a PSCustomObject for each adaptors' MacAddress and then tried to use the PSCustomObject as if it was a string.

Something must went wrong as in my last post I have entered the following code in the "codes" section, but anyways, here is it :
cls

$Serial = (Get-WmiObject Win32_BIOS).SerialNumber

$Model = (Get-WmiObject -Class:Win32_ComputerSystem).Model

$Ethernet=Get-NetAdapter -Name Ethernet* | select MacAddress

$WiFi=Get-NetAdapter -Name Wi-Fi* | select MacAddress

$Bluetooth=Get-NetAdapter -Name Bluetooth* | select MacAddress

$a = New-object PSobject

$a | Add-Member NoteProperty "Serial" $Serial

$a | Add-Member NoteProperty "PC Model" $Model

$a | Add-Member NoteProperty "Ethernet" $Ethernet

$a | Add-Member NoteProperty "Wi-Fi" $WiFi

$a | Add-Member NoteProperty "Bluetooth" $Bluetooth

$a | Export-Csv -Path C:\NICs.csv

Your problem is your use of the "Select-Object" following each Get-NetAdapter. A Select-Object cmdlet produces a PSCustomObject, not a string. If you want only the contents of the property, use the "-Expand <propertyname>" parameter.

I posted a new answer that doesn't use the Select-Object cmdlet and is also much shorter. But if you encounter a machine that has multiple NICs whose names all match the wildcard name you'll get an array of values, not a single value. You can't export an array to a CSV without additional coding.

I posted a new answer that doesn't use the Select-Object cmdlet and is also much shorter.

Can you post it again, as I can't see your new answer.

It's there. It's a new ANSWER, not a new comment.

Unfortunately, I cannot see your new answer.

---