Hi Adam, Hope you are well.
Just a quick question about the Observium database schema.
I need to write a simple query that will return a list of device names and the IP addresses which Observium uses for its polling (we don’t need or want any other addresses).
I had a look and found tables ‘devices’ and ‘ipv4_addresses’. And I can see the device_id foreign key etc, so obtaining all the IPs for a device is trivial enough. But I am not sure how to best filter for just the IP which Observium uses for polling.
I recently built a DNS zone for our network team using PowerDNS, and I just need to export all the devices and their management IPs from Observium, so I can inject the records into PowerDNS. So nothing fancy, but we have a couple hundred records..
Kind regards, Andy Lemin
What Mike said! :D
I think I'd like to add an attribute to either supply a fixed polling IP, or maybe a fixed cosmetic hostname.
Originally observium was designed to enforce forward and reverse DNS resolution for devices being discovered/polled, but these days we don't bother with that much.
Adam.
Sent from BlueMail
On 6 Jul 2018, 03:51, at 03:51, Andrew Lemin andrewl@4d-dc.com wrote:
Hi Adam, Hope you are well.
Just a quick question about the Observium database schema.
I need to write a simple query that will return a list of device names and the IP addresses which Observium uses for its polling (we don’t need or want any other addresses).
I had a look and found tables ‘devices’ and ‘ipv4_addresses’. And I can see the device_id foreign key etc, so obtaining all the IPs for a device is trivial enough. But I am not sure how to best filter for just the IP which Observium uses for polling.
I recently built a DNS zone for our network team using PowerDNS, and I just need to export all the devices and their management IPs from Observium, so I can inject the records into PowerDNS. So nothing fancy, but we have a couple hundred records..
Kind regards, Andy Lemin
participants (2)
-
Adam Armstrong -
Andrew Lemin