dear i have a question, if i have for example 100 machine and i want to execute a specific query on a specific host and i know only the ip address, can i search the in the fleet connected on the server by ip address?

the simple solution is from the command line I'd type

host 192.168.0.1

and grab a hostname from DNS (assuming it is in your DNS).

Sorry! Wrote in pt_BR before. Maybe a discovery query and so a query you want ? Not sure if it works with fleet.

in fleet when you want run a query you can search by hostname the host that must run the query, but it's impossibile to search by ip or mac address

SELECT * FROM interface_details where mac="<mac address here>";

and

select address from interface_addresses where address = "<ip address here>";

will return host names based on mac address or ip address respectively. Does that answer your question?