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:

time_first_stamp
time_last_stamp

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.

search_by_name( \%cond, \%attrs? )

 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.

search_by_mac( \%cond, \%attrs? )

 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.