Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Printing report with MAC adresses of wired and wirless connection only

Jaromir zarczynski

July 18, 2020 09:26

Hey,

I'd like to print a report containing MAC addresses only of Wifi and wired connections cards.

The critera for Wirless adapter:

Name of network adapter connections should not contain values: "Miniport" "TAP"
Network adapter connections contain values: "Wifi"

The critera for Wired adapter:

Name of network adapter connections should not contain values: "Miniport" "TAP"
Network adapter connections contain values: "Ethernet"
Network adapter status "connected"

Is this possible to achieve ? Should i try with SQL report ?

Kind Regards,

JŻ

Comments

1 comment

Lipovsky, Marcel
July 19, 2020 03:58 (Edited July 19, 2020 03:59)

Hi,

you can create a basic report with columns:

Computer Name, Network adapter name, Network adapter MAC address, Network adapter status

then add filter

Network adater > Name > Does not contain = "Minipport"
Network adater > Name > Does not contain = "TAP-Windows"
Network adater > Name > Does not contain = "Virtual"
Network adater > Name > Does not contain = "Bluetooth"

This way you get a list of all the "real" adapters and their status.
You can also group the list by computer name (right mouse click on the column header)

It is possible to change the filter to "contains" and set the custom criteria you want.
I would prefere the above way as you never know all the adapter names.

0