DB 뷰 생성
LibreNMS
CREATE OR REPLACE VIEW view_ports AS
SELECT
d.device_id,
INET6_NTOA(d.ip) AS ip,
d.sysName,
d.display,
p.port_id,
p.ifIndex,
p.ifName,
p.ifAlias,
p.ifDescr,
p.ifAdminStatus,
p.ifConnectorPresent,
p.ifOperStatus,
p.ifMtu
FROM
devices d
JOIN
ports p ON d.device_id = p.device_id;
NocoDB 조회
