Hi.

Ah, I thought that was only done once when adding a new device, and the IP was saved somewhere.

Ok, I’ll just export the device names, and script the ‘host’ query.

Thank you kind sir 😊 Andy.

From: Mike Stupalov <mike@observium.org>
Date: Friday, 6 July 2018 at 11:20
To: Observium <observium@observium.org>, Andrew Lemin <AndrewL@4d-dc.com>
Cc: Adam Armstrong <adama@observium.org>
Subject: Re: [Observium] SQL Query

Hi,

 devices polling not use tables with *_addresses, only hostnames.

Hostnames resolve IP during polling by DNS query (or system hosts file).

Andrew Lemin

6 July 2018 at 12:36

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

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

--
Mike Stupalov
Observium Limited, http://observium.org