This can probably be fairly trivially fixed to work with the current database layout.

If you want to contact Mathieu Poussin and see if he'd release the code to us so we can fix it and include it in the distribution, we can do that.

Thanks, adam. On 11/10/2016 13:01:17, Andy Lemin andy@brandwatch.com wrote: Hi Observium users,

Re; GraphViz.js based maps built using;

https://github.com/kedare/observium_map_generator [https://github.com/kedare/observium_map_generator]

https://gist.github.com/kedare/9806171 [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.

_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium