Storage Viewer for SAN Fabrics Database Views > aps_v_swi_switch
  
Version 10.0.01
aps_v_swi_switch
Switch corresponds to the logical aspects of a single Switch instance.
Table 5.26 aps_v_swi_switch
Column Name
Data Type
Description
banner
STRING
A message (specified by the administrator) that is displayed whenever a user logs in to a switch
caption
STRING
The Caption property is a short textual description (one-line string) of the object.
chassis_id
NUMBER
Foreign key to the aps_v_swi_chassis view
confirm_domain_id
STRING
Domain IDs are assigned by the principal switch at the time of fabric configuration. Domain ID Confirmed indicates whether the switch currently has a valid domain ID.
creation_class_name
STRING
This field indicates the name of the class or the subclass used in the creation of an instance.
creation_date
DATE
Date and time the switch was added to the database
dedicated
STRING
Indicates that the computer system is a switch or extender.
description
STRING
The Description property provides a textual description of the object.
domain_id
NUMBER
Domain IDs are assigned by the principal switch at the time of fabric configuration
element_name
STRING
Switch symbolic name.
enabled_state
STRING
EnabledState is an integer enumeration that indicates the enabled and disabled states of the switch. It can also indicate the transitions between these requested states.
fabric_domain_id
STRING
The domain ID is a fabric-assigned identifier that uniquely identifies a switch in the fabric.
fabric_id
NUMBER
Foreign key to the aps_v_swi_fabric view
inter_op_mode
STRING
Fabric is in interop mode or not
is_deleted
STRING
This property tells whether the switch has been deleted or not
is_virtual
STRING
This property tells whether the switch is a real switch or a virtual switch.
last_config_change_date
DATE
The period of time that has elapsed since the last configuration change.
last_switch_port_change_date
NUMBER
Timestamp when the fabric was last modified due to switch port joining or leaving the fabric or due to switch port status change.
last_updated
DATE
Date and time last updated
name_format
STRING
The Name Format property identifies how Computer System Name is generated. The Name Format Value Map qualifier defines the various mechanisms for assigning the name.
object_id
STRING
Unique key to identify the object
operational_status
STRING
Indicates the current status of the switch.
physical_switch_id
NUMBER
Foreign key to the aps_v_swi_physical_switch view
reboot_reason
STRING
The reason for most recent switch reboot.
san_id
NUMBER
Foreign key to the aps_v_swi_san view
status_reason
STRING
A description of the reason for switch operational status
switch_date
DATE
The switch's notion of time-of-day (number of seconds since midnight, January 1, 1970).
switch_domain_name
STRING
DNS-assigned name for the switch.
switch_id
NUMBER
Switch embedded port destination identifier. Primary key in this view
switch_identifier
STRING
Switch embedded port destination identifier
switch_name
STRING
The switch WWN, which is a unique numeric identifier for the switch. The WWN is factory-assigned and is typically used in license keys and digital certificates.
switch_role
STRING
The current role of the switch. As part of the fabric coming up, one switch in the fabric assumes the role of a principal switch, every other switch assumes a subordinate role unless the principal switch is disabled.
switch_time_zone
STRING
The time zone offset (hours and minutes).
switch_up_time
DATE
The period of time that has elapsed since last reboot.
system_location
STRING
Description of location