The VMware Carbon Black Tech Zone is live! Checkout this great resource: Mastering Carbon Black Audit & Remediation.

Sensor Host IP&MAC (auto -dhcp- or manual)

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.


Tags (3)
0 Votes
1 Comment
Carbon Black Employee
Status changed to: Approved

@roromarti  You had a missing "," and an ambiguous column name in your SELECT clause. I fixed them for you. Thanks again for contributing!