페이지 이력

CREATE OR REPLACE VIEW view_devices AS
SELECT
    d.device_id,
    INET6_NTOA(d.ip) AS ip,
    d.display,
    d.sysName,
    l.location as sysLocation,
    d.sysContact,
    REPLACE(REPLACE(d.icon, '.svg', ''), '.png', '') as vendor,
    d.hardware,
    d.sysDescr,
    d.os,
    d.version,
    d.bgpLocalAs,
    d.serial
FROM
    devices d
LEFT JOIN
    locations l ON d.location_id = l.id;