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 NodeIp table.
The
cond
parameter must be a hashref containing a keyip
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
andtime_last_stamp
provide preformatted timestamps of thetime_first
andtime_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({dns => 'foo.example.com', active => 1});
Like search()
, this returns a ResultSet of matching rows from the NodeIp table.
The NodeIp table must have a
dns
column for this search to work. Typically this column is the IP's DNS PTR record, cached at the time of Netdisco Arpnip.The
cond
parameter must be a hashref containing a keydns
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
andtime_last_stamp
provide preformatted timestamps of thetime_first
andtime_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 NodeIp table.
The
cond
parameter must be a hashref containing a keymac
with the value to search for.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 OUI table and the OUI
company
column prefetched.
To limit results only to active IPs, set {active => 1}
in cond
.