/ 
App-Netdisco-2.079001
River stage one • 1 direct dependent • 1 total dependent
/ App::Netdisco::DB::Result::NodeIp

RELATIONSHIPS

oui

DEPRECATED: USE MANUFACTURER INSTEAD

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.

manufacturer

Returns the manufacturer 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 Manufacturer table has not been populated.

router

Returns the device table entry matching this Node's router. You can then join on this relation and retrieve the Device DNS name.

The JOIN is of type LEFT, in case there's no recorded router on this record.

node_ips

Returns the set of all node_ip entries which are associated together with this IP. That is, all the IP addresses hosted on the same interface (MAC address) as the current Node IP entry.

Note that the set will include the original Node IP object itself. If you wish to find the other IPs excluding this one, see the ip_aliases helper routine, below.

Remember you can pass a filter to this method to find only active or inactive nodes, but do take into account that both the node and node_ip tables include independent active fields.

nodes

Returns the set of node entries associated with this IP. That is, all the MAC addresses recorded which have ever hosted this IP Address.

Remember you can pass a filter to this method to find only active or inactive nodes, but do take into account that both the node and node_ip tables include independent active fields.

See also the node_sightings helper routine, below.

netbios

Returns the set of node_nbt entries associated with the MAC of this IP. That is, all the NetBIOS entries recorded which shared the same MAC with this IP Address.

ip_aliases( \%cond, \%attrs? )

Returns the set of other node_ip entries hosted on the same interface (MAC address) as the current Node IP, excluding the current IP itself.

Remember you can pass a filter to this method to find only active or inactive nodes, but do take into account that both the node and node_ip tables include independent active fields.

  • Results are ordered by time last seen.

  • Additional columns time_first_stamp and time_last_stamp provide preformatted timestamps of the time_first and time_last fields.

node_sightings( \%cond, \%attrs? )

Returns the set of node entries associated with this IP. That is, all the MAC addresses recorded which have ever hosted this IP Address.

Remember you can pass a filter to this method to find only active or inactive nodes, but do take into account that both the node and node_ip tables include independent active fields.

  • Results are ordered by time last seen.

  • Additional columns time_first_stamp and time_last_stamp provide preformatted timestamps of the time_first and time_last fields.

  • A JOIN is performed on the Device table and the Device DNS column prefetched.

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

router_ip

Returns the router IP that most recently reported this MAC-IP pair.

router_name

Returns the router DNS or SysName that most recently reported this MAC-IP pair.

May be blank if there's no SysName or DNS name, so you have router_ip as well.

net_mac

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