The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

RELATIONSHIPS

device

Returns the single device to which this Node entry was associated at the time of discovery.

The JOIN is of type LEFT, in case the device is no longer present in the database but the relation is being used in search().

device_port

Returns the single device_port to which this Node entry was associated at the time of discovery.

The JOIN is of type LEFT, in case the device is no longer present in the database but the relation is being used in search().

ips

Returns the set of node_ip entries associated with this Node. That is, the IP addresses which this MAC address was hosting at the time of discovery.

Note that the Active status of the returned IP entries will all be the same as the current Node's.

oui

Returns the oui table entry matching this Node. You can then join on this relation and retrieve the Company name from the related table.

The JOIN is of type LEFT, in case the OUI table has not been populated.

ADDITIONAL COLUMNS

time_first_stamp

Formatted version of the time_first field, accurate to the minute.

The format is somewhat like ISO 8601 or RFC3339 but without the middle T between the date stamp and time stamp. That is:

 2012-02-06 12:49

time_last_stamp

Formatted version of the time_last field, accurate to the minute.

The format is somewhat like ISO 8601 or RFC3339 but without the middle T between the date stamp and time stamp. That is:

 2012-02-06 12:49

net_mac

Returns the mac column instantiated into a Net::MAC object.