RELATIONSHIPS
device_ips
Returns rows from the device_ip
table which relate to this Device. That is, all the interface IP aliases configured on the Device.
device_ips_by_address_or_name
Returns rows from the device_ip
table which relate to this Device. That is, all the interface IP aliases configured on the Device. However you probably want to use the device_ips_with_address_or_name
ResultSet method instead, so you can pass the MAC address part.
vlans
Returns the device_vlan
entries for this Device. That is, the list of VLANs configured on or known by this Device.
ports
Returns the set of ports on this Device.
ports_by_mac
Returns the set of ports on this Device, filtered by MAC. However you probably want to use the ports_with_mac
ResultSet method instead, so you can pass the MAC address part.
modules
Returns the set chassis modules on this Device.
power_modules
Returns the set of power modules on this Device.
oids
Returns the oids walked on this Device.
port_vlans
Returns the set of VLANs known to be configured on Ports on this Device, either tagged or untagged.
The JOIN is of type "RIGHT" meaning that the results are constrained to VLANs only on Ports on this Device.
port_vlans_filter
A JOIN condition which can be used to filter a set of Devices to those known carrying a given VLAN on its ports. Uses an INNER JOIN to achieve this.
wireless_ports
Returns the set of wireless IDs known to be configured on Ports on this Device.
ssids
Returns the set of SSIDs known to be configured on Ports on this Device.
properties_ports
Returns the set of ports known to have recorded properties
powered_ports
Returns the set of ports known to have PoE capability
community
Returns the row from the community string table, if one exists.
snapshot
Returns the row from the snapshot table, if one exists.
throughput
Returns a sum of speeds on all ports on the device.
ADDITIONAL METHODS
has_layer( $number )
Returns true if the device provided sysServices and supports the given layer.
renumber( $new_ip )
Will update this device and all related database records to use the new IP $new_ip
. Returns undef
if $new_ip seems invalid, otherwise returns the Device row object.
ADDITIONAL COLUMNS
port_count
Returns the number of ports on this device. Enable this column by applying the with_port_count()
modifier to search()
.
uptime_age
Formatted version of the uptime
field.
The format is in "X days/months/years" style, similar to:
1 year 4 months 05:46:00
first_seen_stamp
Formatted version of the creation
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
last_discover_stamp
Formatted version of the last_discover
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
last_macsuck_stamp
Formatted version of the last_macsuck
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
last_arpnip_stamp
Formatted version of the last_arpnip
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
since_last_discover
Number of seconds which have elapsed since the value of last_discover
.
since_last_macsuck
Number of seconds which have elapsed since the value of last_macsuck
.
since_last_arpnip
Number of seconds which have elapsed since the value of last_arpnip
.