Built off the open source project Osquery
Description: Show a list of host sensor's IP and MAC address autoassigned by <dhcp> or manualy assigned labeled <manual> with its Interfaces
What The Data Shows: Let know sensor's IP anb MAC so you can search and compare other inventory to cross information
SQL: SELECT iadd.interface, iadd.address, idet.mac, idet.type FROM interface_addresses as iadd, interface_details as idet
WHERE (iadd.type = 'manual' OR iadd.type ='dhcp') and (iadd.interface = idet.interface)
> Requirement: Please test all submissions using Live Query or Osquery before posting.
Copyright © 2005-2023 Broadcom. All Rights Reserved. The term “Broadcom” refers to Broadcom Inc. and/or its subsidiaries.