/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


MAC Address Inventory Report

03/28/2016 1705 views
Is there a way to get a report that shows all WiFi network adapters and their associated MAC addresses?
Or is there a way to dump all of the Network interfaces on all devices into one spreadsheet where I can filter it manually?
0 Comments   [ + ] Show comments

Comments


All Answers

0
The wizard should be able to get that information for you. You can also try this.

SELECT MACHINE_NICS.MAC AS NIC_MAC, DHCP_ENABLED, NIC, MACHINE.IP AS MACHINE_IP, MACHINE.MAC AS MACHINE_MAC, MACHINE.NAME AS SYSTEM_NAME  FROM MACHINE_NICS  JOIN MACHINE ON (MACHINE.ID = MACHINE_NICS.ID) WHERE ((NIC like '%wireless%'))  ORDER BY NIC_MAC
Answered 03/28/2016 by: nshah
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ