Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1844)

1792 Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
HBA_REMOTE_PORT.TARGET_ID,
HBA_REMOTE_PORT.ROLE,
HBA_REMOTE_PORT.VENDOR,
HBA_REMOTE_PORT.PRODUCT_ID,
HBA_REMOTE_PORT.PRODUCT_VERSION,
HBA_REMOTE_PORT.QOS_PRIORITY,
HBA_REMOTE_PORT.QOS_FLOW_ID,
HBA_REMOTE_PORT.CURRENT_SPEED,
HBA_REMOTE_PORT.TRL_ENFORCED,
HBA_REMOTE_PORT.BUS_NO,
HBA_REMOTE_PORT_LUN.FCP_LUN,
HBA_REMOTE_PORT_LUN.CAPACITY,
HBA_REMOTE_PORT_LUN.BLOCK_SIZE,
HBA_REMOTE_PORT_LUN.VENDOR as LUN_VENDOR,
HBA_REMOTE_PORT_LUN.PRODUCT_ID as LUN_PRODUCT_ID,
HBA_REMOTE_PORT_LUN.PRODUCT_VERSION as LUN_PRODUCT_VERSION,
HBA_REMOTE_PORT_LUN.PRODUCT_SERIAL_NO,
HBA_REMOTE_PORT_LUN.TARGET_WWN,
HBA_REMOTE_PORT_LUN.PHYSICAL_LUN,
HBA_REMOTE_PORT_LUN.LUN_ID,
HBA_REMOTE_PORT.FCP_IM_STATE,
HBA_REMOTE_PORT.IO_LATENCY_MIN,
HBA_REMOTE_PORT.IO_LATENCY_MAX,
HBA_REMOTE_PORT.IO_LATENCY_AVERAGE,
HBA_REMOTE_PORT.DATA_RETRANSMISSION_SUPPORT,
HBA_REMOTE_PORT.REC_SUPPORT,
HBA_REMOTE_PORT.TASK_RENTRY_IDENT_SUPPORT,
HBA_REMOTE_PORT.CONFIRMED_COMPLETIONS_SUPPORT
from
HBA_TARGET, HBA_REMOTE_PORT, HBA_REMOTE_PORT_LUN
where
HBA_TARGET.HBA_REMOTE_PORT_LUN_ID = HBA_REMOTE_PORT_LUN.ID and
HBA_REMOTE_PORT.ID = HBA_REMOTE_PORT_LUN.HBA_REMOTE_PORT_ID;
HEALTH_STATUS_INFO
create or replace view HEALTH_STATUS_INFO as
select
DEPLOYMENT_CONFIGURATION.ID as CONFIGURATION_ID,
DEPLOYMENT_CONFIGURATION.NAME,
DEPLOYMENT_STATUS.ID as STATUS_ID,
DEPLOYMENT_STATUS.DEPLOYMENT_TIME,
DEPLOYMENT_STATUS.DEPLOYED_BY,
HEALTH_STATUS.RULE_ID,
HEALTH_STATUS.RULE_DESCRIPTION,
HEALTH_TARGET_STATUS.TARGET_ID,
HEALTH_TARGET_STATUS.TARGET_TYPE,
HEALTH_TARGET_STATUS.STATUS,
HEALTH_TARGET_STATUS.MESSAGE,
HEALTH_TARGET_STATUS.LEGACY_NAME
from
DEPLOYMENT_CONFIGURATION,
DEPLOYMENT_STATUS,
HEALTH_STATUS,
HEALTH_TARGET_STATUS
where
DEPLOYMENT_STATUS.DEPLOYMENT_CONFIGURATION_ID = DEPLOYMENT_CONFIGURATION.ID
and HEALTH_STATUS.DEPLOYMENT_STATUS_ID = DEPLOYMENT_STATUS.ID
and HEALTH_TARGET_STATUS.HEALTH_STATUS_ID = HEALTH_STATUS.ID;