Brocade Network Advisor SAN User Manual
1399
53-1002696-01
Views
H
DEST_PORT.DOMAIN_ID as DEST_SWITCH_DOMAIN_ID
from
DEVICE_PORT as SOURCE_PORT,
DEVICE_PORT as DEST_PORT,
DEVICE_NODE as DEST_NODE,
DEVICE_NODE as SOURCE_NODE,
EE_MONITOR,
EE_MONITOR_STATS
where
SOURCE_PORT.ID = EE_MONITOR.SOURCE_PORT_ID
and EE_MONITOR.ID = EE_MONITOR_STATS.EE_MONITOR_ID
and SOURCE_PORT.NODE_ID = SOURCE_NODE.ID
and DEST_PORT.ID = EE_MONITOR.DEST_PORT_ID
and DEST_PORT.NODE_ID = DEST_NODE.ID
and EE_MONITOR_STATS.CREATION_TIME in (
select MAX(CREATION_TIME)
from EE_MONITOR_STATS
group by EE_MONITOR_ID);
SENSOR_INFO
create or replace view SENSOR_INFO as
select
SENSOR.ID,
SENSOR.CORE_SWITCH_ID,
SENSOR.SENSOR_ID,
SENSOR.CURRENT_READING,
SENSOR.TYPE,
SENSOR.SUB_TYPE,
SENSOR.DESCRIPTION,
SENSOR.STATUS,
SENSOR.OPERATIONAL_STATUS,
SENSOR.PART_NUMBER,
SENSOR.SERIAL_NUMBER,
SENSOR.VERSION,
SENSOR.CREATION_TIME,
SENSOR.LAST_UPDATE_TIME,
SENSOR.FRU_TYPE,
SENSOR.UNIT_NUMBER,
SENSOR.STATE,
CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN,
VIRTUAL_SWITCH.SWITCH_MODE as VIRTUAL_SWITCH_MODE,
VIRTUAL_SWITCH.MANAGEMENT_STATE,
VIRTUAL_SWITCH.MONITORED
from
SENSOR,
CORE_SWITCH,
VIRTUAL_SWITCH
where
SENSOR.CORE_SWITCH_ID = CORE_SWITCH.ID and
SENSOR.CORE_SWITCH_ID = VIRTUAL_SWITCH.CORE_SWITCH_ID;
SMART_CARD_USAGE_INFO
create or replace view SMART_CARD_USAGE_INFO as
select
SC.ID SMART_CARD_ID,
SC.CARD_TYPE,
Summary of Contents for Network Advisor 12.0.0
Page 36: ...xxxvi Brocade Network Advisor SAN User Manual 53 1002696 01...
Page 82: ...34 Brocade Network Advisor SAN User Manual 53 1002696 01 License downgrade 2...
Page 86: ...38 Brocade Network Advisor SAN User Manual 53 1002696 01 Uninstalling a patch 3...
Page 122: ...74 Brocade Network Advisor SAN User Manual 53 1002696 01 VM Manager discovery 4...
Page 184: ...136 Brocade Network Advisor SAN User Manual 53 1002696 01 Fabric tracking 5...
Page 214: ...166 Brocade Network Advisor SAN User Manual 53 1002696 01 User profiles 6...
Page 284: ...236 Brocade Network Advisor SAN User Manual 53 1002696 01 User defined performance monitors 8...
Page 320: ...272 Brocade Network Advisor SAN User Manual 53 1002696 01 Grouping on the topology 9...
Page 434: ...386 Brocade Network Advisor SAN User Manual 53 1002696 01 Port Auto Disable 12...
Page 442: ...394 Brocade Network Advisor SAN User Manual 53 1002696 01 Exporting Host port mapping 13...
Page 450: ...402 Brocade Network Advisor SAN User Manual 53 1002696 01 Exporting storage port mapping 14...
Page 536: ...488 Brocade Network Advisor SAN User Manual 53 1002696 01 Virtual FCoE port configuration 16...
Page 552: ...504 Brocade Network Advisor SAN User Manual 53 1002696 01 Security configuration deployment 17...
Page 878: ...830 Brocade Network Advisor SAN User Manual 53 1002696 01 Removing thresholds 24...
Page 922: ...874 Brocade Network Advisor SAN User Manual 53 1002696 01 VLAN routing 26...
Page 990: ...942 Brocade Network Advisor SAN User Manual 53 1002696 01 SAN Connection utilization 29...
Page 1138: ...1090 Brocade Network Advisor SAN User Manual 53 1002696 01 Call Home Event Tables B...
Page 1144: ...1096 Brocade Network Advisor SAN User Manual 53 1002696 01 IP Performance monitoring events C...
Page 1186: ...1138 Brocade Network Advisor SAN User Manual 53 1002696 01 Regular Expressions F...
Page 1486: ...1438 Brocade Network Advisor SAN User Manual 53 1002696 01 Views H...