![]() |
![]()
| ![]() |
![]()
RELATIONSHIPSouiReturns 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. nodesReturns 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_nbt" tables include independent "active" fields. See also the "node_sightings" helper routine, below. nodeipsReturns the set of "node_ip" entries associated with this NetBIOS entry. That is, the IP addresses which the same MAC address at the time of discovery.Note that the Active status of the returned IP entries will all be the same as the current NetBIOS entry. 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.
ADDITIONAL COLUMNStime_first_stampFormatted 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_stampFormatted 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_macReturns the "mac" column instantiated into a NetAddr::MAC object.
|