RELATIONSHIPS
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.
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
andtime_last_stamp
provide preformatted timestamps of thetime_first
andtime_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
andtime_last_stamp
provide preformatted timestamps of thetime_first
andtime_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
net_mac
Returns the mac
column instantiated into a Net::MAC object.