1. librenms@librenms:~$ mysql -u librenms -p
2. Enter password:
3. Welcome to the MariaDB monitor.  Commands end with ; or \g.
4. Your MariaDB connection id is 45871
5. Server version: 10.3.25-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04
6.  
7. Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
8.  
9. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
10.  
11. MariaDB [(none)]> use librenms;
12. Reading table information for completion of table and column names
13. You can turn off this feature to get a quicker startup with -A
14.  
15. Database changed
16. MariaDB [librenms]> select * from ports where device_id = 97;
17. +---------+-----------+-----------------+------------------+--------------------+------------------+------------------+---------+--------+----------+---------+----------+--------------+--------------------+-------------------+-------------+------------------+--------------+-------------------+---------------+--------------------+----------+-------+------------------+---------+---------------+------------+--------------+--------+---------+-------+------------+-------------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+---------------+--------------------+---------------------+--------------------+----------------+---------------------+----------------------+---------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+------------+-------------+
18. | port_id | device_id | port_descr_type | port_descr_descr | port_descr_circuit | port_descr_speed | port_descr_notes | ifDescr | ifName | portName | ifIndex | ifSpeed  | ifSpeed_prev | ifConnectorPresent | ifPromiscuousMode | ifHighSpeed | ifHighSpeed_prev | ifOperStatus | ifOperStatus_prev | ifAdminStatus | ifAdminStatus_prev | ifDuplex | ifMtu | ifType           | ifAlias | ifPhysAddress | ifHardType | ifLastChange | ifVlan | ifTrunk | ifVrf | counter_in | counter_out | ignore | disabled | detailed | deleted | pagpOperationMode | pagpPortState | pagpPartnerDeviceId | pagpPartnerLearnMethod | pagpPartnerIfIndex | pagpPartnerGroupIfIndex | pagpPartnerDeviceName | pagpEthcOperationMode | pagpDeviceId | pagpGroupIfIndex | ifInUcastPkts | ifInUcastPkts_prev | ifInUcastPkts_delta | ifInUcastPkts_rate | ifOutUcastPkts | ifOutUcastPkts_prev | ifOutUcastPkts_delta | ifOutUcastPkts_rate | ifInErrors | ifInErrors_prev | ifInErrors_delta | ifInErrors_rate | ifOutErrors | ifOutErrors_prev | ifOutErrors_delta | ifOutErrors_rate | ifInOctets | ifInOctets_prev | ifInOctets_delta | ifInOctets_rate | ifOutOctets | ifOutOctets_prev | ifOutOctets_delta | ifOutOctets_rate | poll_time  | poll_prev  | poll_period |
19. +---------+-----------+-----------------+------------------+--------------------+------------------+------------------+---------+--------+----------+---------+----------+--------------+--------------------+-------------------+-------------+------------------+--------------+-------------------+---------------+--------------------+----------+-------+------------------+---------+---------------+------------+--------------+--------+---------+-------+------------+-------------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+---------------+--------------------+---------------------+--------------------+----------------+---------------------+----------------------+---------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+------------+-------------+
20. |   16588 |        97 | NULL            | NULL             | NULL               | NULL             | NULL             | lo      | lo     | NULL     |       1 | 10000000 |     10000000 | false              | false             |          10 |               10 | up           | up                | up            | up                 | NULL     | 65536 | softwareLoopback | lo      | NULL          | NULL       |            0 |        | NULL    |     0 |       NULL |        NULL |      0 |        0 |        0 |       0 | NULL              | NULL          | NULL                | NULL                   |               NULL |                    NULL | NULL                  | NULL                  | NULL         |             NULL |           100 |                100 |                   0 |                  0 |            100 |                 100 |                    0 |                   0 |          0 |               0 |                0 |               0 |           0 |                0 |                 0 |                0 |       9078 |            9078 |                0 |               0 |        9078 |             9078 |                 0 |                0 | 1604511721 | 1604511653 |          68 |
21. +---------+-----------+-----------------+------------------+--------------------+------------------+------------------+---------+--------+----------+---------+----------+--------------+--------------------+-------------------+-------------+------------------+--------------+-------------------+---------------+--------------------+----------+-------+------------------+---------+---------------+------------+--------------+--------+---------+-------+------------+-------------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+---------------+--------------------+---------------------+--------------------+----------------+---------------------+----------------------+---------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+------------+-------------+
22. 1 row in set (0.001 sec)
23.