teoseller10/01/2018, 3:26 PM
stefanmaerz10/01/2018, 4:09 PM
and grab a hostname from DNS (assuming it is in your DNS).
spookerlabs10/01/2018, 6:56 PM
teoseller10/02/2018, 7:40 AM
stefanmaerz10/02/2018, 3:48 PM
SELECT * FROM interface_details where mac="<mac address here>";
will return host names based on mac address or ip address respectively. Does that answer your question?
select address from interface_addresses where address = "<ip address here>";