Hi All, Does anyone know if I can use the Host column as part of a query? Ex: when I run a query like select * from wifi_status I can see the Host column, but if I try to use it in a query I receive an error that Host is not a valid column

you could do a

SELECT computer_name from system_info;

which would give you the same thing. "Hosts" comes for free with all queries 😉

I tried to run a query correlating system_info and wifi_status to have the wifi information with the serial number. @Stefano Bonicatti helped me with this query

SELECT w.*, s.hostname, s.hardware_serial FROM wifi_status as w, system_info as s;

and worked.