[Observium] GraphViz Maps

Hi Observium users,

Re; GraphViz.js based maps built using;

https://github.com/kedare/observium_map_generator https://gist.github.com/kedare/9806171

Hi, Their are a couple of graphing tools out there that use the "links" table, which does not seem to exist.

Is there a replacement table that details the connections between devices?

For example this no longer works :(

SELECT UPPER(d.hostname) AS local_hostname, p.port_id AS local_port_id, p.ifName AS local_port, p.ifSpeed/1000000 as local_port_speed, l.remote_port_id AS remote_port_id, rp.ifName AS remote_port, UPPER(l.remote_hostname) AS remote_hostname, d.hardware AS hardware, rd.hardware AS remote_hardware, s.ifInErrors_rate AS local_in_errors_rate, s.ifOutErrors_rate AS local_out_errors_rate, s.ifInOctets_rate*8 AS local_in_octets_rate, s.ifOutOctets_rate*8 AS local_out_octets_rate, s.ifInOctets_perc AS local_in_octets_perc, s.ifOutOctets_perc AS local_out_octets_perc FROM `devices` AS d, `devices` as rd, `ports` AS p, `ports` as rp, `links` AS l, `ports-state` AS s WHERE p.port_id = l.local_port_id AND p.device_id = d.device_id AND rp.port_id = l.remote_port_id AND rp.device_id = rd.device_id AND p.port_id = s.port_id AND UPPER(d.hostname) = UPPER(%s);

Thanks, Andy.