with_times

This is a modifier for any "search()" (including the helpers below) which will add the following additional synthesized columns to the result set:

search_by_ip( \%cond, \%attrs? )

 my $set = $rs->search_by_ip({ip => '192.0.2.1', active => 1});

Like "search()", this returns a ResultSet of matching rows from the NodeNbt table.

The "cond" parameter must be a hashref containing a key "ip" with the value to search for. Value can either be a simple string of IPv4 or IPv6, or a NetAddr::IP::Lite object in which case all results within the CIDR/Prefix will be retrieved.
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 OUI table and the OUI "company" column prefetched.

To limit results only to active IPs, set "{active => 1}" in "cond".

 my $set = $rs->search_by_name({nbname => 'MYNAME', active => 1});

Like "search()", this returns a ResultSet of matching rows from the NodeNbt table.

The "cond" parameter must be a hashref containing a key "nbname" with the value to search for. The value may optionally include SQL wildcard characters.
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 OUI table and the OUI "company" column prefetched.

To limit results only to active IPs, set "{active => 1}" in "cond".

 my $set = $rs->search_by_mac({mac => '00:11:22:33:44:55', active => 1});

Like "search()", this returns a ResultSet of matching rows from the NodeNbt table.

The "cond" parameter must be a hashref containing a key "mac" with the value to search for.
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 OUI table and the OUI "company" column prefetched.

To limit results only to active IPs, set "{active => 1}" in "cond".