Storage Viewer for SAN Fabrics Database Views > aps_v_swi_topology
  
Version 10.0.01
aps_v_swi_topology
Stores a connection between two FC ports.
Table 5.35 aps_v_swi_topology
Column Name
Data Type
Description
fabric_id
NUMBER
Foreign key to the aps_v_swi_fabric view
last_updated
DATE
Date and time last updated
operational_status
STRING
operational_status from the aps_v_swi_switch_fc_port view
source_host_id
NUMBER
Foreign key to the apt_host view
source_node_fc_port_id
NUMBER
Foreign key to the aps_v_swi_node_fc_port view
source_port_wwn_id
NUMBER
port_wwn_id from either the aps_v_swi_switch_fc_port or aps_v_swi_node_fc_port view
source_storage_array_id
NUMBER
Foreign key to the aps_storage_array view
source_switch_fc_port_id
NUMBER
Foreign key to the aps_v_swi_switch_fc_port view
source_switch_id
NUMBER
Foreign key to the aps_v_swi_switch view
source_type
STRING
H - Host, S - Switch, D - Director Switch, A - Array
source_zone_id
NUMBER
Foreign key to the aps_v_swi_zone view
target_host_id
NUMBER
Foreign key to the apt_host view
target_node_fc_port_id
NUMBER
Foreign key to the aps_v_swi_node_fc_port view
target_port_wwn_id
NUMBER
port_wwn_id from either the aps_v_swi_switch_fc_port or aps_v_swi_node_fc_port view
target_storage_array_id
NUMBER
Foreign key to the aps_storage_array view
target_switch_fc_port_id
NUMBER
Foreign key to the aps_v_swi_switch_fc_port view
target_switch_id
NUMBER
Foreign key to the aps_v_swi_switch view
target_type
STRING
H - Host, S - Switch, D - Director Switch, A - Array
target_zone_id
NUMBER
Foreign key to the aps_v_swi_zone view