Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
MariaDB [keatest]> SELECT host_id, HEX(dhcp_identifier), (SELECT name FROM host_identifier_type WHERE type=dhcp_identifier_type), dhcp4_subnet_id, dhcp6_subnet_id, INET_NTOA(ipv4_address), hostname, dhcp4_client_classes, dhcp6_client_classes from hosts;
+---------+----------------------+-------------------------------------------------------------------------+-----------------+-----------------+-------------------------+----------------------------------+----------------------+----------------------+
| host_id | HEX(dhcp_identifier) | (SELECT name FROM host_identifier_type WHERE type=dhcp_identifier_type) | dhcp4_subnet_id | dhcp6_subnet_id | INET_NTOA(ipv4_address) | hostname | dhcp4_client_classes | dhcp6_client_classes |
+---------+----------------------+-------------------------------------------------------------------------+-----------------+-----------------+-------------------------+----------------------------------+----------------------+----------------------+
| 1 | 000C29D4074D | hw-address | 199 | NULL | 10.14.199.199 | milotest.dallas.charlietango.com | NULL | NULL |
+---------+----------------------+-------------------------------------------------------------------------+-----------------+-----------------+-------------------------+----------------------------------+----------------------+----------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment