librenms@librenms:~$ mysql -u librenms -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 45871 Server version: 10.3.25-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use librenms; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [librenms]> select * from ports where device_id = 97; +---------+-----------+-----------------+------------------+--------------------+------------------+------------------+---------+--------+----------+---------+----------+--------------+--------------------+-------------------+-------------+------------------+--------------+-------------------+---------------+--------------------+----------+-------+------------------+---------+---------------+------------+--------------+--------+---------+-------+------------+-------------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+---------------+--------------------+---------------------+--------------------+----------------+---------------------+----------------------+---------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+------------+-------------+ | 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 | +---------+-----------+-----------------+------------------+--------------------+------------------+------------------+---------+--------+----------+---------+----------+--------------+--------------------+-------------------+-------------+------------------+--------------+-------------------+---------------+--------------------+----------+-------+------------------+---------+---------------+------------+--------------+--------+---------+-------+------------+-------------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+---------------+--------------------+---------------------+--------------------+----------------+---------------------+----------------------+---------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+------------+-------------+ | 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 | +---------+-----------+-----------------+------------------+--------------------+------------------+------------------+---------+--------+----------+---------+----------+--------------+--------------------+-------------------+-------------+------------------+--------------+-------------------+---------------+--------------------+----------+-------+------------------+---------+---------------+------------+--------------+--------+---------+-------+------------+-------------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+---------------+--------------------+---------------------+--------------------+----------------+---------------------+----------------------+---------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+------------+-------------+ 1 row in set (0.001 sec)