netdisco-users Digest, Vol 114, Issue 2

[netdisco-users-request]

Send netdisco-users mailing list submissions to
        netdisco-users@lists.sourceforge.net

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
        netdisco-users-requ...@lists.sourceforge.net

You can reach the person managing the list at
        netdisco-users-ow...@lists.sourceforge.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."

Today's Topics:

   1. Re: Macsuck not possible on Cisco 2918 Switch (Sebastian R?sch)
   2. Re: Question about multiple nodes per port report (Steven Xu)
   3. Re: Netdisco ARPNIP and Juniper devices (Vlad Kratsberg)

--- Begin Message ---

Hello Jeroen,

Yes correct, as the device is already discoverd by netdisco and only the 
macwalk doesn´t work I´m thinking the same. Maybe I will find some settings on 
the switch I could change... I will take a look at that, when there time for it.

@ Charles:
Yes there is an accesslist number, but there is no access list present...So the 
acl number can be removed easily....



Best Regards

Sebastian


-----Ursprüngliche Nachricht-----
Von: Jeroen van Ingen [mailto:j.vaningensche...@utwente.nl] 
Gesendet: Freitag, 27. November 2015 16:48
An: Charles Goldsmith <wo...@justfamily.org>; Sebastian Rösch 
<roe...@alcera.de>; netdisco-users@lists.sourceforge.net
Betreff: Re: [Netdisco] Macsuck not possible on Cisco 2918 Switch

Hi Sebastian, Charles,

If the ACL is the cause, I wouldn't expect any snmpwalk output at all... 
So is SNMP working for other objects?

If so, maybe it's a software bug, or perhaps a platform limitation that
2918 doesn't expose forwarding table via SNMP. Both hard to imagine, but I 
don't really know the platform. IOS 12.2(44) train is already pretty old and 
the model number sounds like an older, lower end Cisco.


Regards,

Jeroen van Ingen
ICT Service Centre
University of Twente, P.O.Box 217, 7500 AE Enschede, The Netherlands


On 11/25/2015 03:26 PM, Charles Goldsmith wrote:
> Sebastian, your SNMP community strings have an access-list on them, 10 
> in this case.  Try a 'show access-list 10'
>
> My guess is that your netdisco server IP is not in that access-list.
>
> On Tue, Nov 24, 2015 at 11:15 AM, Sebastian Rösch <roe...@alcera.de 
> <mailto:roe...@alcera.de>> wrote:
>
>     Hello Jeroen,
>
>     sure, here is the output:
>
>     snmp-server community xyz RO 10
>     snmp-server community zyx RW 10
>     snmp-server contact xxx
>     snmp-server enable traps snmp authentication coldstart warmstart
>     snmp-server enable traps config
>     snmp-server enable traps syslog
>     snmp-server host xyz bla
>
>
>     But I can´t see any restrctions here.... it´s a pretty simple config?!
>
>
>
>     Best Regards
>
>     Sebastian Rösch
>
>
>     -----Ursprüngliche Nachricht-----
>     Von: Jeroen van Ingen [mailto:j.vaningensche...@utwente.nl
>     <mailto:j.vaningensche...@utwente.nl>]
>     Gesendet: Montag, 23. November 2015 12:16
>     An: netdisco-users@lists.sourceforge.net
>     <mailto:netdisco-users@lists.sourceforge.net>
>     Betreff: Re: [Netdisco] Macsuck not possible on Cisco 2918 Switch
>
>     Sebastian,
>
>      >> I have a problem to macsuck addresses from a Cisco 2918 Switch
>     (Cisco
>      >> IOS Software, C2918 Software (C2918-LANLITEK9-M), Version
>      >> 12.2(44)SE6, RELEASE SOFTWARE (fc1) ) They won´t be fetched.
>      >>
>      >> When I do a simple snmpwalk the data isn´t also being fetched. What
>      >> should I do now? Do I need a special MIB?
>      >
>      > If the data isn't appearing with snmpwalk then it could be an SNMP
>      > "view" restriction (ACL)?
>      >
>      > You might need to configure the device to permit access to the table
>      > via SNMP. Sadly I can't lay my hands on the command right now but
>      > maybe someone else can help?
>
>     Could you paste the SNMP related configuration from that switch? For
>     example, "show run | inc snmp" ? You may want to find/replace the
>     actual SNMP community values with something bogus.
>
>     This bit of config will show if any SNMP view restrictions are in
>     place, hiding the objects that we need.
>
>
>     Regards,
>
>     Jeroen van Ingen
>     ICT Service Centre
>     University of Twente, P.O.Box 217, 7500 AE Enschede, The 
> Netherlands
>
>
>
>     
> ------------------------------------------------------------------------------
>     Go from Idea to Many App Stores Faster with Intel(R) XDK
>     Give your users amazing mobile app experiences with Intel(R) XDK.
>     Use one codebase in this all-in-one HTML5 development environment.
>     Design, debug & build mobile apps & 2D/3D high-impact games for
>     multiple OSs.
>     http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
>     _______________________________________________
>     Netdisco mailing list
>     netdisco-users@lists.sourceforge.net
>     <mailto:netdisco-users@lists.sourceforge.net>
>     https://lists.sourceforge.net/lists/listinfo/netdisco-users
>
>

--- End Message ---

--- Begin Message --- Hi Sebastian,

I forgot to mention that node_freshness = 0 is the behaviour in Netdisco V1.

I should also add that enabling the Archived Nodes option in Device Ports and Search Nodes can severely impact performance, depending on how long you are keeping nodes (expire_nodes) and the size of your network. For our organization, I'm not sure that the extra performance impact is worth the report, especially since Netdisco seems slow already.

Steven

-----Sebastian Rösch <roe...@alcera.de> wrote: -----

To: Steven Xu <stev...@yorku.ca>
From: Sebastian Rösch <roe...@alcera.de>
Date: 12/01/2015 12:02PM
Cc: "netdisco-users@lists.sourceforge.net" <netdisco-users@lists.sourceforge.net>
Subject: AW: [Netdisco] Question about multiple nodes per port report

Thanks for your quick feedback Steven,

 

I will try now to use another node_freshness value. But as you said, I will tell my colleagues to keep in mind the archive option when searching….

 

 

Best Regards

 

Sebastian

 

Von: Steven Xu [mailto:stev...@yorku.ca]
Gesendet: Dienstag, 1. Dezember 2015 17:33
An: Sebastian Rösch <roe...@alcera.de>
Cc: netdisco-users@lists.sourceforge.net
Betreff: Re: [Netdisco] Question about multiple nodes per port report

 

Hi Sebastian,

This report counts all "active" nodes. Depending on how you configured netdisco (particularly, the node_freshness option), nodes are active for a certain period according to node_freshness. If it's set to 0, nodes are active forever until they change switch port; then the results you get in this report won't be very reliable.

If you set node_freshness to 60 minutes, then the nodes that appear in this report are the ones that the nodes that were seen in the last 60 minutes. However, if you're changing it, you'll need to note that it may affect how your users see results elsewhere in Netdisco.

Currently, this report is not set up to take time ranges. You'd need to hack one up.

Steven

-----Sebastian Rösch < roe...@alcera.de > wrote: -----

To: " netdisco-users@lists.sourceforge.net " < netdisco-users@lists.sourceforge.net >
From: Sebastian Rösch < roe...@alcera.de >
Date: 12/01/2015 11:06AM
Subject: [Netdisco] Question about multiple nodes per port report

Hi all,

 

can somebody tell me how the “multiple nodes per port report” works? For me it seems, that it shows current connected nodes and also nodes that has been seen some time ago (Where is this timerange defined, can I control it?) But for this report, wouldn´t it be better, if it only shows the nodes, that were fetched with the last macsuck? This is a very good function for finding pocketswitches/non managed switches, but it would be good, if it would show the exact count of nodes on a port.

 

 

 

Regards,

 

Sebastian

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140

_______________________________________________
Netdisco mailing list
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users

--- End Message ---

--- Begin Message ---

Hi Jeroen,

Apologies for late response.  The reason i provided a device with low
number of arp entries was to minimize output.

But here is another example, from different device.  Ips are for
regular hosts.


[netdisco@da3-admin002 ~]$ ~netdisco/bin/netdisco-do arpnip -DIQ -d 10.100.124.3
SELECT me.version, me.installed
  FROM dbix_class_schema_versions me
WHERE 1 = 0
SELECT me.version
  FROM dbix_class_schema_versions me
ORDER BY installed DESC
  LIMIT '1'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
  FROM device_ip me
WHERE me.alias = '10.100.124.3' AND me.ip = '10.100.124.3'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.ports, me.mac,
me.serial, me.model, me.ps1_type, me.ps2_type, me.ps1_status,
me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log,
me.snmp_ver, me.snmp_comm, me.snmp_class, me.vtp_domain,
me.last_discover, me.last_macsuck, me.last_arpnip, to_char(
last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( last_discover,
'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD HH24:MI' ),
extract( epoch
      FROM age( now(  ), last_arpnip ) ), extract( epoch
      FROM age( now(  ), last_discover ) ), extract( epoch
      FROM age( now(  ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
  FROM device me
WHERE me.ip = '10.100.124.3'
[4279] 2015-12-01 19:24:47  info arpnip: started at Tue Dec  1 19:24:47 2015
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
  FROM device_ip me
WHERE me.alias = '10.100.124.3' AND me.ip = '10.100.124.3'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.ports, me.mac,
me.serial, me.model, me.ps1_type, me.ps2_type, me.ps1_status,
me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log,
me.snmp_ver, me.snmp_comm, me.snmp_class, me.vtp_domain,
me.last_discover, me.last_macsuck, me.last_arpnip, to_char(
last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( last_discover,
'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD HH24:MI' ),
extract( epoch
      FROM age( now(  ), last_arpnip ) ), extract( epoch
      FROM age( now(  ), last_discover ) ), extract( epoch
      FROM age( now(  ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
  FROM device me
WHERE me.ip = '10.100.124.3'
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag
  FROM community me
WHERE me.ip = '10.100.124.3'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
  FROM device_ip me
WHERE me.alias = '10.100.124.3' AND me.ip = '10.100.124.3'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.ports, me.mac,
me.serial, me.model, me.ps1_type, me.ps2_type, me.ps1_status,
me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log,
me.snmp_ver, me.snmp_comm, me.snmp_class, me.vtp_domain,
me.last_discover, me.last_macsuck, me.last_arpnip, to_char(
last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( last_discover,
'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD HH24:MI' ),
extract( epoch
      FROM age( now(  ), last_arpnip ) ), extract( epoch
      FROM age( now(  ), last_discover ) ), extract( epoch
      FROM age( now(  ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
  FROM device me
WHERE me.ip = '10.100.124.3'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
  FROM device_ip me
WHERE me.alias = '10.100.124.3' AND me.ip = '10.100.124.3'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.ports, me.mac,
me.serial, me.model, me.ps1_type, me.ps2_type, me.ps1_status,
me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log,
me.snmp_ver, me.snmp_comm, me.snmp_class, me.vtp_domain,
me.last_discover, me.last_macsuck, me.last_arpnip, to_char(
last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( last_discover,
'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD HH24:MI' ),
extract( epoch
      FROM age( now(  ), last_arpnip ) ), extract( epoch
      FROM age( now(  ), last_discover ) ), extract( epoch
      FROM age( now(  ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
  FROM device me
WHERE me.ip = '10.100.124.3'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
  FROM device_ip me
WHERE me.alias = '10.100.124.3' AND me.ip = '10.100.124.3'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.ports, me.mac,
me.serial, me.model, me.ps1_type, me.ps2_type, me.ps1_status,
me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log,
me.snmp_ver, me.snmp_comm, me.snmp_class, me.vtp_domain,
me.last_discover, me.last_macsuck, me.last_arpnip, to_char(
last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( last_discover,
'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD HH24:MI' ),
extract( epoch
      FROM age( now(  ), last_arpnip ) ), extract( epoch
      FROM age( now(  ), last_discover ) ), extract( epoch
      FROM age( now(  ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
  FROM device me
WHERE me.ip = '10.100.124.3'
[4279] 2015-12-01 19:24:47 debug [10.100.124.3] try_connect with ver:
2, class: SNMP::Info::Layer3::Juniper, comm: <hidden>
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance :
.1.3.6.1.2.1.1.3.0
SNMP::Info::_global orig_layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_load_attr qb_fw_port : Q-BRIDGE-MIB::dot1qTpFdbPort :
.1.3.6.1.2.1.17.7.1.2.2.1.2
BEGIN WORK
COMMIT
BEGIN WORK
COMMIT
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag
  FROM community me
WHERE me.ip = '10.100.124.3'
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 : .1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.27
SNMP::Info::device_type() layers:00000110 id:2636 sysDescr:"Juniper
Networks, Inc. mx40-t internet router, kernel JUNOS 13.3R6.5, Build
date: 2015-03-26 20:49:06 UTC Copyright (c) 1996-2015 Juniper
Networks, Inc."
SNMP::Info::_load_attr orig_at_paddr : IP-MIB::ipNetToMediaPhysAddress
: .1.3.6.1.2.1.4.22.1.2
SNMP::Info::_load_attr orig_at_netaddr :
IP-MIB::ipNetToMediaNetAddress : .1.3.6.1.2.1.4.22.1.3
[4279] 2015-12-01 19:24:49 debug  resolving 255 ARP entries with max
50 outstanding requests
SNMP::Info::_load_attr ip_n2p_phys_addr :
IP-MIB::ipNetToPhysicalPhysAddress : .1.3.6.1.2.1.4.35.1.4
SNMP::Info::IPv6::ipv6_n2p_mac: data comes from IP-MIB.
SNMP::Info::IPv6::ipv6_n2p_addr: data comes from IP-MIB.
[4279] 2015-12-01 19:24:51 debug  resolving 0 ARP entries with max 50
outstanding requests
SNMP::Info::_load_attr ip_netmask : IP-MIB::ipAdEntNetMask :
.1.3.6.1.2.1.4.20.1.3
[4279] 2015-12-01 19:24:51 debug  [10.100.124.3] arpnip - found subnet
10.11.48.0/30
[4279] 2015-12-01 19:24:51 debug  [10.100.124.3] arpnip - found subnet
10.11.48.8/30
[4279] 2015-12-01 19:24:51 debug  [10.100.124.3] arpnip - found subnet
10.100.124.0/22
[4279] 2015-12-01 19:24:51 debug  [10.100.124.3] arpnip - found subnet
10.11.241.0/24
[4279] 2015-12-01 19:24:51 debug  [10.100.124.3] arpnip - found subnet
10.100.124.0/22
[4279] 2015-12-01 19:24:51 debug  [10.100.124.3] arpnip - found subnet
10.100.15.0/24
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.119'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.119' AND me.mac = 'b8:ca:3a:fb:2c:a5' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.119' AND mac = 'b8:ca:3a:fb:2c:a5'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.75'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.75' AND me.mac = '00:c0:b7:4e:2f:b9' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.75' AND mac = '00:c0:b7:4e:2f:b9'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.112'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.112' AND me.mac = '90:b1:1c:46:b7:8d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.112' AND mac = '90:b1:1c:46:b7:8d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.127'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.127' AND me.mac = 'b8:2a:72:d6:b3:d0' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.127' AND mac = 'b8:2a:72:d6:b3:d0'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.105'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.105' AND me.mac = '00:1e:c9:ab:ed:a9' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.105' AND mac = '00:1e:c9:ab:ed:a9'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.129'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.129' AND me.mac = 'f0:1f:af:ef:a6:98' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.129' AND mac = 'f0:1f:af:ef:a6:98'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.121'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.121' AND me.mac = 'b8:ca:3a:fb:2c:9d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.121' AND mac = 'b8:ca:3a:fb:2c:9d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.96'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.96' AND me.mac = '00:50:56:64:c5:e4' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.96' AND mac = '00:50:56:64:c5:e4'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.102'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.102' AND me.mac = 'bc:30:5b:ef:e5:fe' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.102' AND mac = 'bc:30:5b:ef:e5:fe'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.93'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.93' AND me.mac = '00:c0:b7:4b:4c:38' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.93' AND mac = '00:c0:b7:4b:4c:38'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.119'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.119' AND me.mac = '00:c0:b7:b6:94:f9' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.119' AND mac = '00:c0:b7:b6:94:f9'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.18'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.18' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.18' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.133'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.133' AND me.mac = '18:fb:7b:9a:28:e1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.133' AND mac = '18:fb:7b:9a:28:e1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.107'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.107' AND me.mac = '78:2b:cb:09:5c:a8' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.107' AND mac = '78:2b:cb:09:5c:a8'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.95'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.95' AND me.mac = '00:c0:b7:4e:8e:20' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.95' AND mac = '00:c0:b7:4e:8e:20'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.99'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.99' AND me.mac = '00:c0:b7:4e:8e:95' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.99' AND mac = '00:c0:b7:4e:8e:95'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.103'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.103' AND me.mac = '00:c0:b7:b3:5b:8b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.103' AND mac = '00:c0:b7:b3:5b:8b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.121'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.121' AND me.mac = '00:c0:b7:b5:c5:58' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.121' AND mac = '00:c0:b7:b5:c5:58'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.13'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.13' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.13' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.95'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.95' AND me.mac = '00:50:56:69:6f:9b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.95' AND mac = '00:50:56:69:6f:9b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.126'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.126' AND me.mac = '18:fb:7b:9a:29:8d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.126' AND mac = '18:fb:7b:9a:29:8d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.229'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.229' AND me.mac = '08:9e:01:d8:8e:0a' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.229' AND mac = '08:9e:01:d8:8e:0a'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.23'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.23' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.23' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.11.48.9'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.11.48.9' AND me.mac = '88:e0:f3:78:b8:90' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.11.48.9' AND mac = '88:e0:f3:78:b8:90'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.82'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.82' AND me.mac = '4c:96:14:b8:5b:b1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.82' AND mac = '4c:96:14:b8:5b:b1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.231'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.231' AND me.mac = 'b8:2a:72:fd:b6:3c' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.231' AND mac = 'b8:2a:72:fd:b6:3c'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '198.185.159.47'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '198.185.159.47' AND me.mac = '00:23:e9:8e:00:44' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '198.185.159.47' AND mac = '00:23:e9:8e:00:44'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.12'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.12' AND me.mac = 'f0:1f:af:d9:b8:24' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.12' AND mac = 'f0:1f:af:d9:b8:24'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.234'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.234' AND me.mac = 'b8:2a:72:fd:b4:f0' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.234' AND mac = 'b8:2a:72:fd:b4:f0'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.122'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.122' AND me.mac = '00:c0:b7:b5:d8:a1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.122' AND mac = '00:c0:b7:b5:d8:a1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.132'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.132' AND me.mac = '44:a8:42:2a:1b:36' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.132' AND mac = '44:a8:42:2a:1b:36'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.21'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.21' AND me.mac = '00:01:d7:da:03:c1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.21' AND mac = '00:01:d7:da:03:c1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.70'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.70' AND me.mac = '00:c0:b7:4d:54:28' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.70' AND mac = '00:c0:b7:4d:54:28'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.87'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.87' AND me.mac = '00:c0:b7:4d:54:15' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.87' AND mac = '00:c0:b7:4d:54:15'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.123'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.123' AND me.mac = 'b8:ca:3a:fb:3b:32' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.123' AND mac = 'b8:ca:3a:fb:3b:32'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.63'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.63' AND me.mac = '00:13:c6:01:70:31' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.63' AND mac = '00:13:c6:01:70:31'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '128.0.0.1'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '128.0.0.1' AND me.mac = '02:00:02:00:00:04' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '128.0.0.1' AND mac = '02:00:02:00:00:04'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.125'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.125' AND me.mac = '00:c0:b7:ea:a5:4d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.125' AND mac = '00:c0:b7:ea:a5:4d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.83'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.83' AND me.mac = '00:c0:b7:d8:24:61' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.83' AND mac = '00:c0:b7:d8:24:61'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '128.0.0.1'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '128.0.0.1' AND me.mac = '02:00:00:00:00:04' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '128.0.0.1' AND mac = '02:00:00:00:00:04'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.65'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.65' AND me.mac = '00:c0:b7:4b:49:c4' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.65' AND mac = '00:c0:b7:4b:49:c4'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.6'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.6' AND me.mac = '60:eb:69:d2:67:e4' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.6' AND mac = '60:eb:69:d2:67:e4'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.81'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.81' AND me.mac = '00:c0:b7:d8:97:33' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.81' AND mac = '00:c0:b7:d8:97:33'
COMMIT
BEGIN WORK
UPDATE node_ip
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.115'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.115' AND me.mac = '00:c0:b7:b6:eb:cf' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.115' AND mac = '00:c0:b7:b6:eb:cf'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.88'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.88' AND me.mac = '00:c0:b7:d7:d5:a7' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.88' AND mac = '00:c0:b7:d7:d5:a7'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.75'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.75' AND me.mac = '78:2b:cb:09:a4:33' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.75' AND mac = '78:2b:cb:09:a4:33'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.68'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.68' AND me.mac = '00:c0:b7:4e:30:f5' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.68' AND mac = '00:c0:b7:4e:30:f5'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.45'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.45' AND me.mac = '00:25:90:c6:04:9e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.45' AND mac = '00:25:90:c6:04:9e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.15'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.15' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.15' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.126'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.126' AND me.mac = 'bc:30:5b:f0:d8:e4' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.126' AND mac = 'bc:30:5b:f0:d8:e4'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.15.10'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.15.10' AND me.mac = 'dc:38:e1:f9:96:96' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.15.10' AND mac = 'dc:38:e1:f9:96:96'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.113'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.113' AND me.mac = '00:c0:b7:b6:eb:b5' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.113' AND mac = '00:c0:b7:b6:eb:b5'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.118'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.118' AND me.mac = '00:c0:b7:b6:df:39' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.118' AND mac = '00:c0:b7:b6:df:39'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.65'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.65' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.65' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.245'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.245' AND me.mac = 'f0:1f:af:db:53:a6' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.245' AND mac = 'f0:1f:af:db:53:a6'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.66'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.66' AND me.mac = '00:c0:b7:51:d5:52' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.66' AND mac = '00:c0:b7:51:d5:52'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.104'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.104' AND me.mac = '00:c0:b7:b3:5b:a8' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.104' AND mac = '00:c0:b7:b3:5b:a8'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.98'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.98' AND me.mac = '00:c0:b7:4e:8c:80' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.98' AND mac = '00:c0:b7:4e:8c:80'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.73'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.73' AND me.mac = '00:c0:b7:4e:8e:4e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.73' AND mac = '00:c0:b7:4e:8e:4e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.124'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.124' AND me.mac = '00:c0:b7:eb:29:66' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.124' AND mac = '00:c0:b7:eb:29:66'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.236'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.236' AND me.mac = '74:e6:e2:fd:9c:d8' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.236' AND mac = '74:e6:e2:fd:9c:d8'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.43'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.43' AND me.mac = '00:25:90:ea:a5:e4' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.43' AND mac = '00:25:90:ea:a5:e4'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.46'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.46' AND me.mac = '00:25:90:c6:05:f4' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.46' AND mac = '00:25:90:c6:05:f4'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.105'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.105' AND me.mac = '00:c0:b7:b3:5b:e9' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.105' AND mac = '00:c0:b7:b3:5b:e9'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.191'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.191' AND me.mac = '5c:f9:dd:f2:9d:3e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.191' AND mac = '5c:f9:dd:f2:9d:3e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.27'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.27' AND me.mac = '3c:61:04:6d:76:82' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.27' AND mac = '3c:61:04:6d:76:82'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.118'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.118' AND me.mac = 'c8:1f:66:d0:91:75' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.118' AND mac = 'c8:1f:66:d0:91:75'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.249'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.249' AND me.mac = 'f0:1f:af:db:53:7e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.249' AND mac = 'f0:1f:af:db:53:7e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.248'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.248' AND me.mac = 'f0:1f:af:db:54:32' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.248' AND mac = 'f0:1f:af:db:54:32'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.24'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.24' AND me.mac = '00:23:e9:e3:81:01' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.24' AND mac = '00:23:e9:e3:81:01'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.91'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.91' AND me.mac = '00:50:56:61:f7:db' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.91' AND mac = '00:50:56:61:f7:db'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.211'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.211' AND me.mac = 'cc:e1:7f:85:6c:c2' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.211' AND mac = 'cc:e1:7f:85:6c:c2'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.135'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.135' AND me.mac = '20:47:47:7e:ad:80' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.135' AND mac = '20:47:47:7e:ad:80'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.113'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.113' AND me.mac = '90:b1:1c:46:f9:93' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.113' AND mac = '90:b1:1c:46:f9:93'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.124'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.124' AND me.mac = 'bc:30:5b:ef:e5:78' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.124' AND mac = 'bc:30:5b:ef:e5:78'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.86'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.86' AND me.mac = '00:c0:b7:4d:54:26' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.86' AND mac = '00:c0:b7:4d:54:26'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.247'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.247' AND me.mac = 'f0:1f:af:db:4f:9d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.247' AND mac = 'f0:1f:af:db:4f:9d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.103'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.103' AND me.mac = 'f0:1f:af:ce:a1:ab' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.103' AND mac = 'f0:1f:af:ce:a1:ab'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.101'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.101' AND me.mac = '00:c0:b7:b3:5b:ba' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.101' AND mac = '00:c0:b7:b3:5b:ba'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.97'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.97' AND me.mac = '00:c0:b7:4e:8e:36' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.97' AND mac = '00:c0:b7:4e:8e:36'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.202'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.202' AND me.mac = '88:e0:f3:79:50:ff' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.202' AND mac = '88:e0:f3:79:50:ff'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.53'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.53' AND me.mac = '0c:c4:7a:53:ba:e4' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.53' AND mac = '0c:c4:7a:53:ba:e4'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.64'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.64' AND me.mac = '00:13:c6:01:70:2f' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.64' AND mac = '00:13:c6:01:70:2f'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.117'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.117' AND me.mac = 'c8:1f:66:d0:0c:c8' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.117' AND mac = 'c8:1f:66:d0:0c:c8'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.20'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.20' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.20' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.90'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.90' AND me.mac = '00:c0:b7:4e:8e:11' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.90' AND mac = '00:c0:b7:4e:8e:11'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.228'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.228' AND me.mac = '08:9e:01:d8:8c:96' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.228' AND mac = '08:9e:01:d8:8c:96'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.77'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.77' AND me.mac = '00:c0:b7:4e:8b:33' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.77' AND mac = '00:c0:b7:4e:8b:33'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.76'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.76' AND me.mac = '00:c0:b7:4e:8a:ee' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.76' AND mac = '00:c0:b7:4e:8a:ee'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.111'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.111' AND me.mac = '00:c0:b7:b3:5b:81' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.111' AND mac = '00:c0:b7:b3:5b:81'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.21'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.21' AND me.mac = '4c:96:14:b8:52:8d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.21' AND mac = '4c:96:14:b8:52:8d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.11.48.2'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.11.48.2' AND me.mac = '88:e0:f3:79:c3:c1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.11.48.2' AND mac = '88:e0:f3:79:c3:c1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false

BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.22'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.22' AND me.mac = '00:01:d7:da:0b:01' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.22' AND mac = '00:01:d7:da:0b:01'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.61'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.61' AND me.mac = '00:13:c6:01:57:bd' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.61' AND mac = '00:13:c6:01:57:bd'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.84'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.84' AND me.mac = 'f8:b1:56:76:b1:6f' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.84' AND mac = 'f8:b1:56:76:b1:6f'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.109'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.109' AND me.mac = '00:c0:b7:b3:5c:24' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.109' AND mac = '00:c0:b7:b3:5c:24'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.50'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.50' AND me.mac = '0c:c4:7a:19:5a:02' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.50' AND mac = '0c:c4:7a:19:5a:02'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.12'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.12' AND me.mac = '3c:8a:b0:de:26:82' FOR UPDATE
UPDATE node_ip
  SET active = true, dns = 'ny-tor-sw3.mgt.peer1.squarespace.net',
time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.12' AND mac = '3c:8a:b0:de:26:82'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.72'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.72' AND me.mac = '00:c0:b7:4e:30:ee' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.72' AND mac = '00:c0:b7:4e:30:ee'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.193'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.193' AND me.mac = '5c:f9:dd:f2:98:8a' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.193' AND mac = '5c:f9:dd:f2:98:8a'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.110'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.110' AND me.mac = '00:c0:b7:b3:5b:d1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.110' AND mac = '00:c0:b7:b3:5b:d1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.94'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.94' AND me.mac = '00:50:56:63:83:b3' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.94' AND mac = '00:50:56:63:83:b3'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.122'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.122' AND me.mac = 'b8:ca:3a:fb:3a:41' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.122' AND mac = 'b8:ca:3a:fb:3a:41'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.106'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.106' AND me.mac = 'a4:ba:db:52:20:6c' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.106' AND mac = 'a4:ba:db:52:20:6c'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.3'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.3' AND me.mac = '88:e0:f3:78:b8:7d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.3' AND mac = '88:e0:f3:78:b8:7d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.22'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.22' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.22' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.115'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.115' AND me.mac = 'c8:1f:66:d0:87:ed' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.115' AND mac = 'c8:1f:66:d0:87:ed'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.0.0.1'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.0.0.1' AND me.mac = '02:00:02:00:00:04' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.0.0.1' AND mac = '02:00:02:00:00:04'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.127'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.127' AND me.mac = 'f0:1f:af:ef:a6:80' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.127' AND mac = 'f0:1f:af:ef:a6:80'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.116'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.116' AND me.mac = '00:c0:b7:b6:94:f6' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.116' AND mac = '00:c0:b7:b6:94:f6'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.25'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.25' AND me.mac = '3c:8a:b0:1e:10:02' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.25' AND mac = '3c:8a:b0:1e:10:02'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.11'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.11' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.11' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.190'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.190' AND me.mac = '5c:f9:dd:f2:9e:38' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.190' AND mac = '5c:f9:dd:f2:9e:38'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.17'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.17' AND me.mac = '5c:f9:dd:f9:2f:6a' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.17' AND mac = '5c:f9:dd:f9:2f:6a'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.92'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.92' AND me.mac = '00:c0:b7:4b:4b:6b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.92' AND mac = '00:c0:b7:4b:4b:6b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.195'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.195' AND me.mac = '5c:f9:dd:f3:41:08' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.195' AND mac = '5c:f9:dd:f3:41:08'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.242'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.242' AND me.mac = 'f0:1f:af:db:4e:b1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.242' AND mac = 'f0:1f:af:db:4e:b1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.91'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.91' AND me.mac = '00:c0:b7:4d:2f:2a' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.91' AND mac = '00:c0:b7:4d:2f:2a'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.17'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.17' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.17' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.221'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.221' AND me.mac = 'f0:1f:af:da:e1:b1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.221' AND mac = 'f0:1f:af:da:e1:b1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '198.185.159.34'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '198.185.159.34' AND me.mac = '88:e0:f3:79:50:c1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '198.185.159.34' AND mac = '88:e0:f3:79:50:c1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.90'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.90' AND me.mac = '78:2b:cb:08:e9:8e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.90' AND mac = '78:2b:cb:08:e9:8e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.74'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.74' AND me.mac = '00:c0:b7:4e:2f:a9' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.74' AND mac = '00:c0:b7:4e:2f:a9'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.64'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.64' AND me.mac = '00:c0:b7:4e:8e:18' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.64' AND mac = '00:c0:b7:4e:8e:18'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.232'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.232' AND me.mac = 'b8:2a:72:fd:b4:64' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.232' AND mac = 'b8:2a:72:fd:b4:64'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.131'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.131' AND me.mac = 'b8:2a:72:d6:b4:be' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.131' AND mac = 'b8:2a:72:d6:b4:be'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.134'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.134' AND me.mac = '20:47:47:7e:ae:0e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.134' AND mac = '20:47:47:7e:ae:0e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.84'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.84' AND me.mac = '00:c0:b7:4d:54:0a' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.84' AND mac = '00:c0:b7:4d:54:0a'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.133'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.133' AND me.mac = '44:a8:42:29:ec:b4' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.133' AND mac = '44:a8:42:29:ec:b4'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.44'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.44' AND me.mac = '0c:c4:7a:14:ce:a0' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.44' AND mac = '0c:c4:7a:14:ce:a0'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.19'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.19' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.19' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false

BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.62'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.62' AND me.mac = '00:c0:b7:4e:8c:c5' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.62' AND mac = '00:c0:b7:4e:8c:c5'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.11.48.1'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.11.48.1' AND me.mac = '88:e0:f3:78:b8:c1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.11.48.1' AND mac = '88:e0:f3:78:b8:c1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.212'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.212' AND me.mac = 'f0:1f:af:da:ff:9d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.212' AND mac = 'f0:1f:af:da:ff:9d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.28'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.28' AND me.mac = '3c:61:04:6c:b9:02' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.28' AND mac = '3c:61:04:6c:b9:02'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.80'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.80' AND me.mac = 'd0:43:1e:65:c6:20' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.80' AND mac = 'd0:43:1e:65:c6:20'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.11.241.1'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.11.241.1' AND me.mac = '88:e0:f3:78:b8:f0' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.11.241.1' AND mac = '88:e0:f3:78:b8:f0'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.51'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.51' AND me.mac = '0c:c4:7a:19:5f:90' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.51' AND mac = '0c:c4:7a:19:5f:90'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.79'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.79' AND me.mac = '00:c0:b7:4e:8c:9d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.79' AND mac = '00:c0:b7:4e:8c:9d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.94'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.94' AND me.mac = '00:c0:b7:4e:8c:f3' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.94' AND mac = '00:c0:b7:4e:8c:f3'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.244'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.244' AND me.mac = 'f0:1f:af:da:88:a8' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.244' AND mac = 'f0:1f:af:da:88:a8'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.67'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.67' AND me.mac = '00:c0:b7:4e:8d:72' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.67' AND mac = '00:c0:b7:4e:8d:72'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.192'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.192' AND me.mac = '5c:f9:dd:f2:92:0e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.192' AND mac = '5c:f9:dd:f2:92:0e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.116'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.116' AND me.mac = 'c8:1f:66:d0:21:fa' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.116' AND mac = 'c8:1f:66:d0:21:fa'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.125'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.125' AND me.mac = 'bc:30:5b:f4:64:f0' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.125' AND mac = 'bc:30:5b:f4:64:f0'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.132'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.132' AND me.mac = '18:fb:7b:9a:29:1f' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.132' AND mac = '18:fb:7b:9a:29:1f'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.12'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.12' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.12' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.32'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.32' AND me.mac = '3c:61:04:6c:fd:82' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.32' AND mac = '3c:61:04:6c:fd:82'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.246'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.246' AND me.mac = 'f0:1f:af:da:90:5c' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.246' AND mac = 'f0:1f:af:da:90:5c'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.89'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.89' AND me.mac = '00:c0:b7:4e:8c:03' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.89' AND mac = '00:c0:b7:4e:8c:03'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.108'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.108' AND me.mac = '00:c0:b7:b3:5b:7e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.108' AND mac = '00:c0:b7:b3:5b:7e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.60'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.60' AND me.mac = '00:c0:b7:4e:8e:0f' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.60' AND mac = '00:c0:b7:4e:8e:0f'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.194'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.194' AND me.mac = '5c:f9:dd:f3:41:de' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.194' AND mac = '5c:f9:dd:f3:41:de'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.11.48.10'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.11.48.10' AND me.mac = '88:e0:f3:79:ca:90' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.11.48.10' AND mac = '88:e0:f3:79:ca:90'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.40'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.40' AND me.mac = 'f0:1f:af:dd:2e:fb' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.40' AND mac = 'f0:1f:af:dd:2e:fb'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.30'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.30' AND me.mac = '3c:8a:b0:12:7b:02' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.30' AND mac = '3c:8a:b0:12:7b:02'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.17'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.17' AND me.mac = '60:eb:69:d2:63:45' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.17' AND mac = '60:eb:69:d2:63:45'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.114'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.114' AND me.mac = '00:c0:b7:b7:49:02' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.114' AND mac = '00:c0:b7:b7:49:02'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.117'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.117' AND me.mac = '00:c0:b7:b6:94:c2' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.117' AND mac = '00:c0:b7:b6:94:c2'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.1'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.1' AND me.mac = '88:e0:f3:78:b8:7d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.1' AND mac = '88:e0:f3:78:b8:7d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.83'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.83' AND me.mac = '54:9f:35:21:e8:1e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.83' AND mac = '54:9f:35:21:e8:1e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.71'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.71' AND me.mac = '00:c0:b7:d7:d2:15' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.71' AND mac = '00:c0:b7:d7:d2:15'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false

BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.222'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.222' AND me.mac = 'f0:1f:af:de:1d:ce' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.222' AND mac = 'f0:1f:af:de:1d:ce'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.130'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.130' AND me.mac = 'b8:2a:72:d9:4d:59' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.130' AND mac = 'b8:2a:72:d9:4d:59'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false

BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.128'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.128' AND me.mac = 'b8:2a:72:d9:4f:89' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.128' AND mac = 'b8:2a:72:d9:4f:89'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.41'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.41' AND me.mac = '00:25:90:e5:94:70' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.41' AND mac = '00:25:90:e5:94:70'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.48'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.48' AND me.mac = '00:25:90:c6:04:6e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.48' AND mac = '00:25:90:c6:04:6e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.243'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.243' AND me.mac = 'f0:1f:af:db:53:4a' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.243' AND mac = 'f0:1f:af:db:53:4a'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.123'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.123' AND me.mac = '00:c0:b7:b5:d8:9e' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.123' AND mac = '00:c0:b7:b5:d8:9e'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.40'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.40' AND me.mac = '0c:c4:7a:16:c8:3c' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.40' AND mac = '0c:c4:7a:16:c8:3c'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.227'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.227' AND me.mac = 'f0:1f:af:da:e0:a1' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.227' AND mac = 'f0:1f:af:da:e0:a1'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.14'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.14' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.14' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.15.1'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.15.1' AND me.mac = '88:e0:f3:78:b8:01' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.15.1' AND mac = '88:e0:f3:78:b8:01'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.42'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.42' AND me.mac = 'f0:1f:af:dd:30:c0' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.42' AND mac = 'f0:1f:af:dd:30:c0'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.100'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.100' AND me.mac = '00:0b:86:b7:36:4f' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.100' AND mac = '00:0b:86:b7:36:4f'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.69'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.69' AND me.mac = '00:c0:b7:4e:8d:0b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.69' AND mac = '00:c0:b7:4e:8d:0b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.101'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.101' AND me.mac = 'bc:30:5b:ef:e9:ae' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.101' AND mac = 'bc:30:5b:ef:e9:ae'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.235'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.235' AND me.mac = '74:e6:e2:fd:9c:70' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.235' AND mac = '74:e6:e2:fd:9c:70'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.111'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.111' AND me.mac = '90:b1:1c:46:d6:1c' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.111' AND mac = '90:b1:1c:46:d6:1c'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.85'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.85' AND me.mac = 'f8:b1:56:76:b6:33' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.85' AND mac = 'f8:b1:56:76:b6:33'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.80'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.80' AND me.mac = '00:c0:b7:4e:8d:cb' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.80' AND mac = '00:c0:b7:4e:8d:cb'
COMMIT
BEGIN WORK
UPDATE node_ip

BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.120'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.120' AND me.mac = 'b8:ca:3a:fb:3b:d3' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.120' AND mac = 'b8:ca:3a:fb:3b:d3'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.18'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.18' AND me.mac = '5c:f9:dd:f9:30:98' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.18' AND mac = '5c:f9:dd:f9:30:98'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.21'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.21' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.21' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.82'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.82' AND me.mac = '00:c0:b7:d7:d3:4f' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.82' AND mac = '00:c0:b7:d7:d3:4f'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.16'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.16' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.16' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.2'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.2' AND me.mac = '88:e0:f3:79:c3:7d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.2' AND mac = '88:e0:f3:79:c3:7d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.92'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.92' AND me.mac = '00:50:56:66:8b:a2' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.92' AND mac = '00:50:56:66:8b:a2'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.23'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.23' AND me.mac = '00:23:e9:8e:00:41' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.23' AND mac = '00:23:e9:8e:00:41'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.126.10'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.126.10' AND me.mac = '00:13:c6:01:88:3b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.126.10' AND mac = '00:13:c6:01:88:3b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.41'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.41' AND me.mac = 'f0:1f:af:dd:2f:d0' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.41' AND mac = 'f0:1f:af:dd:2f:d0'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '128.0.0.4'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '128.0.0.4' AND me.mac = '02:00:00:00:00:04' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '128.0.0.4' AND mac = '02:00:00:00:00:04'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.0.0.4'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.0.0.4' AND me.mac = '02:00:00:00:00:04' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.0.0.4' AND mac = '02:00:00:00:00:04'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '198.185.159.54'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '198.185.159.54' AND me.mac = '00:23:e9:8e:00:44' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '198.185.159.54' AND mac = '00:23:e9:8e:00:44'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.81'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.81' AND me.mac = 'd0:43:1e:65:c6:f0' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.81' AND mac = 'd0:43:1e:65:c6:f0'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false

BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '128.0.0.50'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '128.0.0.50' AND me.mac = '02:00:00:00:00:10' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '128.0.0.50' AND mac = '02:00:00:00:00:10'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.104'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.104' AND me.mac = 'f0:1f:af:ce:a0:fb' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.104' AND mac = 'f0:1f:af:ce:a0:fb'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.75'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.75' AND me.mac = '04:7d:7b:a5:ef:2b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.75' AND mac = '04:7d:7b:a5:ef:2b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.201'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.201' AND me.mac = '88:e0:f3:79:80:ff' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.201' AND mac = '88:e0:f3:79:80:ff'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.220'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.220' AND me.mac = 'f0:1f:af:de:1e:00' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.220' AND mac = 'f0:1f:af:de:1e:00'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.114'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.114' AND me.mac = 'c8:1f:66:d0:75:8d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.114' AND mac = 'c8:1f:66:d0:75:8d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.130'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.130' AND me.mac = 'f0:1f:af:ef:a5:f2' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.130' AND mac = 'f0:1f:af:ef:a5:f2'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.106'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.106' AND me.mac = '00:c0:b7:b3:58:ab' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.106' AND mac = '00:c0:b7:b3:58:ab'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.42'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.42' AND me.mac = '00:25:90:ea:a5:e2' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.42' AND mac = '00:25:90:ea:a5:e2'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.5'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.5' AND me.mac = '60:eb:69:d2:70:53' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.5' AND mac = '60:eb:69:d2:70:53'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.60'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.60' AND me.mac = '00:13:c6:01:57:b9' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.60' AND mac = '00:13:c6:01:57:b9'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.131'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.131' AND me.mac = 'f0:1f:af:ef:a6:ad' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.131' AND mac = 'f0:1f:af:ef:a6:ad'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.26'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.26' AND me.mac = '3c:8a:b0:10:0e:82' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.26' AND mac = '3c:8a:b0:10:0e:82'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false

BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.62'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.62' AND me.mac = '00:13:c6:01:70:55' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.62' AND mac = '00:13:c6:01:70:55'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.100'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.100' AND me.mac = '00:c0:b7:b3:5b:84' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.100' AND mac = '00:c0:b7:b3:5b:84'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.112'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.112' AND me.mac = '00:c0:b7:b6:eb:d5' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.112' AND mac = '00:c0:b7:b6:eb:d5'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.93'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.93' AND me.mac = '00:50:56:6e:55:df' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.93' AND mac = '00:50:56:6e:55:df'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.250'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.250' AND me.mac = 'f0:1f:af:da:93:9c' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.250' AND mac = 'f0:1f:af:da:93:9c'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.55'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.55' AND me.mac = '00:e0:81:63:d0:37' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.55' AND mac = '00:e0:81:63:d0:37'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.129'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.129' AND me.mac = 'b8:2a:72:d9:4f:c9' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.129' AND mac = 'b8:2a:72:d9:4f:c9'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.85'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.85' AND me.mac = '00:c0:b7:4e:8d:ce' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.85' AND mac = '00:c0:b7:4e:8d:ce'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.1'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.1' AND me.mac = '3c:8a:b0:9c:a9:01' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.1' AND mac = '3c:8a:b0:9c:a9:01'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false

BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.230'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.230' AND me.mac = '08:9e:01:d8:8d:c2' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.230' AND mac = '08:9e:01:d8:8d:c2'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.128'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.128' AND me.mac = 'f0:1f:af:ef:a6:d5' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.128' AND mac = 'f0:1f:af:ef:a6:d5'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.16'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.16' AND me.mac = '5c:f9:dd:f9:27:e0' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.16' AND mac = '5c:f9:dd:f9:27:e0'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.47'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.47' AND me.mac = '00:25:90:c6:9e:f2' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.47' AND mac = '00:25:90:c6:9e:f2'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.11.241.10'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.11.241.10' AND me.mac = '00:10:db:ff:10:06' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.11.241.10' AND mac = '00:10:db:ff:10:06'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.31'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.31' AND me.mac = '08:81:f4:a9:5b:ff' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.31' AND mac = '08:81:f4:a9:5b:ff'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.52'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.52' AND me.mac = '0c:c4:7a:53:b9:84' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.52' AND mac = '0c:c4:7a:53:b9:84'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.241'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.241' AND me.mac = 'f0:1f:af:da:85:84' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.241' AND mac = 'f0:1f:af:da:85:84'
COMMIT
BEGIN WORK
UPDATE node_ip

BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.102'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.102' AND me.mac = '00:c0:b7:9a:74:a5' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.102' AND mac = '00:c0:b7:9a:74:a5'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.96'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.96' AND me.mac = '00:c0:b7:4e:8d:b2' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.96' AND mac = '00:c0:b7:4e:8d:b2'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.90'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.90' AND me.mac = '00:50:56:6c:5e:45' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.90' AND mac = '00:50:56:6c:5e:45'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.100'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.100' AND me.mac = 'f0:1f:af:db:4e:af' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.100' AND mac = 'f0:1f:af:db:4e:af'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.61'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.61' AND me.mac = '00:c0:b7:4e:8d:fc' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.61' AND mac = '00:c0:b7:4e:8d:fc'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.99'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.99' AND me.mac = '00:18:7d:2b:e9:26' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.99' AND mac = '00:18:7d:2b:e9:26'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.86'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.86' AND me.mac = 'cc:e1:7f:85:7c:42' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.86' AND mac = 'cc:e1:7f:85:7c:42'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.219'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.219' AND me.mac = 'f0:1f:af:da:e1:10' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.219' AND mac = 'f0:1f:af:da:e1:10'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.107'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.107' AND me.mac = '00:c0:b7:b3:5b:9d' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.107' AND mac = '00:c0:b7:b3:5b:9d'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.110'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.110' AND me.mac = '78:2b:cb:09:6d:65' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.110' AND mac = '78:2b:cb:09:6d:65'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.91'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.91' AND me.mac = 'a4:ba:db:52:1e:1b' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.91' AND mac = 'a4:ba:db:52:1e:1b'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.43'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.43' AND me.mac = 'f0:1f:af:dd:33:8a' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.43' AND mac = 'f0:1f:af:dd:33:8a'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.100'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.100' AND me.mac = 'bc:30:5b:ef:e6:12' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.100' AND mac = 'bc:30:5b:ef:e6:12'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.124.49'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.124.49' AND me.mac = '00:25:90:c1:71:d0' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.49' AND mac = '00:25:90:c1:71:d0'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.125.11'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.125.11' AND me.mac = 'f0:1f:af:d9:b7:a9' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.125.11' AND mac = 'f0:1f:af:d9:b7:a9'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.120'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.120' AND me.mac = '00:c0:b7:b5:c4:af' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.120' AND mac = '00:c0:b7:b5:c4:af'
COMMIT
BEGIN WORK
UPDATE node_ip
  SET active = false
WHERE active AND ip = '10.100.127.78'
SELECT me.mac, me.ip, me.dns, me.active, me.time_first, me.time_last
  FROM node_ip me
WHERE me.ip = '10.100.127.78' AND me.mac = '00:c0:b7:4e:8c:d3' FOR UPDATE
UPDATE node_ip
  SET active = true, time_last = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.127.78' AND mac = '00:c0:b7:4e:8c:d3'
COMMIT
[4279] 2015-12-01 19:24:55 debug  [10.100.124.3] arpnip - processed
255 ARP Cache entries
[4279] 2015-12-01 19:24:55 debug  [10.100.124.3] arpnip - processed 0
IPv6 Neighbor Cache entries
BEGIN WORK
SELECT me.net, me.creation, me.last_discover
  FROM subnets me
WHERE me.net = '10.11.48.0/30' FOR UPDATE
UPDATE subnets
  SET last_discover = to_timestamp( 1448997891.835463 )
WHERE net = '10.11.48.0/30'
COMMIT
BEGIN WORK
SELECT me.net, me.creation, me.last_discover
  FROM subnets me
WHERE me.net = '198.185.159.4/30' FOR UPDATE
UPDATE subnets
  SET last_discover = to_timestamp( 1448997891.835463 )
WHERE net = '198.185.159.4/30'
COMMIT
BEGIN WORK
SELECT me.net, me.creation, me.last_discover
  FROM subnets me
WHERE me.net = '10.11.48.8/30' FOR UPDATE
UPDATE subnets
  SET last_discover = to_timestamp( 1448997891.835463 )
WHERE net = '10.11.48.8/30'
COMMIT
BEGIN WORK
SELECT me.net, me.creation, me.last_discover
  FROM subnets me
WHERE me.net = '10.100.124.0/22' FOR UPDATE
UPDATE subnets
  SET last_discover = to_timestamp( 1448997891.835463 )
WHERE net = '10.100.124.0/22'
COMMIT
BEGIN WORK
SELECT me.net, me.creation, me.last_discover
  FROM subnets me
WHERE me.net = '10.11.241.0/24' FOR UPDATE
UPDATE subnets
  SET last_discover = to_timestamp( 1448997891.835463 )
WHERE net = '10.11.241.0/24'
COMMIT
BEGIN WORK
SELECT me.net, me.creation, me.last_discover
  FROM subnets me
WHERE me.net = '10.100.124.0/22' FOR UPDATE
UPDATE subnets
  SET last_discover = to_timestamp( 1448997891.835463 )
WHERE net = '10.100.124.0/22'
COMMIT
BEGIN WORK
SELECT me.net, me.creation, me.last_discover
  FROM subnets me

BEGIN WORK
SELECT me.net, me.creation, me.last_discover
  FROM subnets me
WHERE me.net = '10.100.15.0/24' FOR UPDATE
UPDATE subnets
  SET last_discover = to_timestamp( 1448997891.835463 )
WHERE net = '10.100.15.0/24'
COMMIT
[4279] 2015-12-01 19:24:55 debug  [10.100.124.3] arpnip - processed 9
Subnet entries
BEGIN WORK
UPDATE device
  SET last_arpnip = to_timestamp( 1448997891.835463 )
WHERE ip = '10.100.124.3'
COMMIT
[4279] 2015-12-01 19:24:55  info arpnip: finished at Tue Dec  1 19:24:55 2015
[4279] 2015-12-01 19:24:55  info arpnip: status done: Ended arpnip for
10.100.124.3

> On Nov 17, 2015, at 5:19 AM, Jeroen van Ingen <j.vaningensche...@utwente.nl> 
> wrote:
>
> Hi Vlad,
>
> OK, Netdisco web interface doesn't show any of these IPs. Just making sure: 
> are these IPs for regular hosts on your network, or are they for other 
> devices (switches/routers etc)?
>
> And is 6 ARP entries really what you'd expect from this particular device? 
> It's a *very* low number...
>
> Could you run the arpnip again, now including SNMP::Info and SQL debug 
> output? That's:
>
> ~netdisco/bin/netdisco-do arpnip -DIQ  -d 10.1.10.1
>
>
> Regards,
>
> Jeroen van Ingen
> ICT Service Centre
> University of Twente, P.O.Box 217, 7500 AE Enschede, The Netherlands
>
>
>> On 10/27/2015 08:02 PM, Vlad Kratsberg wrote:
>> Hi Jeroen,
>>
>> Gui doesn't display discovered arp entries.
>>
>> Thanks for the tip regarding Lldp.
>>
>> Sent from my iPhone
>>
>>> On Oct 27, 2015, at 4:19 AM, Jeroen van Ingen 
>>> <j.vaningensche...@utwente.nl> wrote:
>>>
>>> Hi Vlad,
>>>
>>> Okay, so arpnipping your device 10.1.10.1 shows that we find 4 subnets and 
>>> 6 ARP entries (all for IPv6, no IPv6).
>>>
>>> - Are those numbers what you'd expect?
>>>
>>> - After you've run this arpnip, what happens when you search for these six 
>>> IPs in the web interface? For example, can you find 10.1.253.11?
>>>
>>>
>>> Regarding LLDP on Juniper: we've had a few threads about tha in the past, 
>>> looks like this one had a working solution:
>>> https://sourceforge.net/p/netdisco/mailman/message/34118835/
>>>
>>>
>>> Regards,
>>>
>>> Jeroen van Ingen
>>> ICT Service Centre
>>> University of Twente, P.O.Box 217, 7500 AE Enschede, The Netherlands
>>>
>>>
>>>> On 10/26/2015 04:11 PM, Vlad Kratsberg wrote:
>>>> I would like to add the following output.
>>>>
>>>> [XXXXXX]$ ~netdisco/bin/netdisco-do show
>>>> -d 10.1.10.1 -e ipNetToMediaNetAddress
>>>> [24554] 2015-10-26 15:08:21  info show: started at Mon Oct 26 15:08:21 2015
>>>> \ {
>>>>     535.10.1.255.1      "10.1.255.1",
>>>>     535.10.1.255.2      "10.1.255.2",
>>>>     536.10.1.253.1      "10.1.253.1",
>>>>     536.10.1.253.11     "10.1.253.11",
>>>>     534.108.60.138.41   "108.60.138.41",
>>>>     534.108.60.138.42   "108.60.138.42"
>>>> }
>>>> [24554] 2015-10-26 15:08:27  info show: finished at Mon Oct 26 15:08:27 
>>>> 2015
>>>> [24554] 2015-10-26 15:08:27  info show: status done: Showed
>>>> ipNetToMediaNetAddress response from 10.1.10.1.
>>>>
>>>> On Mon, Oct 26, 2015 at 10:49 AM, Vlad Kratsberg <vkratsb...@gmail.com
>>>> <mailto:vkratsb...@gmail.com>> wrote:
>>>>
>>>>    Hi,
>>>>
>>>>    I m having an issue with discovering arp table on juniper devices.
>>>>    The problem is that it looks like netdisco does discover arp table
>>>>    properly when in debug mode, but doesn't populate the database.
>>>>    Netdisco gui doesn't display any arp entry for most of the juniper
>>>>    devices.
>>>>
>>>>    It works very well for other vendors, like aruba, dell, etc.
>>>>
>>>>    [XXXXXX]$ ~netdisco/bin/netdisco-do arpnip -D  -d 10.1.10.1
>>>>    [1723] 2015-10-26 14:41:44  info arpnip: started at Mon Oct 26
>>>>    14:41:44 2015
>>>>    [1723] 2015-10-26 14:41:44 debug [10.1.10.1] try_connect with ver:
>>>>    2, class: SNMP::Info::Layer3::Juniper, comm: <hidden>
>>>>    [1723] 2015-10-26 14:41:47 debug  resolving 6 ARP entries with max
>>>>    50 outstanding requests
>>>>    [1723] 2015-10-26 14:41:48 debug  resolving 0 ARP entries with max
>>>>    50 outstanding requests
>>>>    [1723] 2015-10-26 14:41:48 debug  [10.1.10.1] arpnip - found subnet
>>>>    10.1.255.0/24 <http://10.1.255.0/24>
>>>>    [1723] 2015-10-26 14:41:48 debug  [10.1.10.1] arpnip - found subnet
>>>>    108.60.138.40/29 <http://108.60.138.40/29>
>>>>    [1723] 2015-10-26 14:41:48 debug  [10.1.10.1] arpnip - found subnet
>>>>    10.1.253.0/24 <http://10.1.253.0/24>
>>>>    [1723] 2015-10-26 14:41:48 debug  [10.1.10.1] arpnip - found subnet
>>>>    10.255.5.0/24 <http://10.255.5.0/24>
>>>>    [1723] 2015-10-26 14:41:48 debug  [10.1.10.1] arpnip - processed 6
>>>>    ARP Cache entries
>>>>    [1723] 2015-10-26 14:41:48 debug  [10.1.10.1] arpnip - processed 0
>>>>    IPv6 Neighbor Cache entries
>>>>    [1723] 2015-10-26 14:41:49 debug  [10.1.10.1] arpnip - processed 4
>>>>    Subnet entries
>>>>    [1723] 2015-10-26 14:41:49  info arpnip: finished at Mon Oct 26
>>>>    14:41:49 2015
>>>>    [1723] 2015-10-26 14:41:49  info arpnip: status done: Ended arpnip
>>>>    for 10.1.10.1
>>>>
>>>>    On a side note, Netdisco doesn't autodraw network topology for
>>>>    juniper devices ( LLDP).
>>>>
>>>>    P.S:  I didn't upgrade postgres.  Should i ?
>>>>
>>>>    Any advice would be helpful.
>>>>
>>>>    Thank you
>>>>    Vlad
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Netdisco mailing list
>>>> netdisco-users@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/netdisco-users
>>>>
>>>
>>>
>>>
>
>
>

--- End Message ---

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users