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