From twelch, 4 Years ago, written in Plain Text.
Embed
  1.     {
  2.         "hostname": "switchtjxlay3a",
  3.         "os": "procurve",
  4.         "ip": "192.168.130.100",
  5.         "group": "default"
  6.     },
  7.  
  8. MariaDB [librenms]> select hostname,sysName from devices where device_id = '387';
  9. +---------------+----------------+
  10. | hostname      | sysName        |
  11. +---------------+----------------+
  12. | 192.168.130.3 | switchteclay3a |
  13. +---------------+----------------+
  14. 1 row in set (0.00 sec)
  15.  
  16. MariaDB [librenms]> select * from devices_attribs where device_id = '387';
  17. +-----------+-----------+---------------------------+--------------+---------------------+
  18. | attrib_id | device_id | attrib_type               | attrib_value | updated             |
  19. +-----------+-----------+---------------------------+--------------+---------------------+
  20. |       856 |       387 | override_Oxidized_disable | true         | 2019-05-07 08:15:26 |
  21. +-----------+-----------+---------------------------+--------------+---------------------+
  22. 1 row in set (0.00 sec)