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()
.
wireless_port
Returns the single wireless_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.
ip4s
Same as ips
but for IPv4 only.
ip6s
Same as ips
but for IPv6 only.
netbios
Returns the node_nbt
entry associated with this Node if one exists. That is, the NetBIOS information of this MAC address at the time of discovery.
wireless
Returns the set of node_wireless
entries associated with this Node. That is, the SSIDs and wireless statistics associated with this MAC address at the time of discovery.
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.
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 NetAddr::MAC object.