I Views

HBA_REMOTE_PORT.SUPPORTED_COS, HBA_REMOTE_PORT.DEVICE_TYPE, HBA_REMOTE_PORT.BIND_TYPE, 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

1630

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1682
Image 1682
Brocade Communications Systems IP250 user manual Healthstatusinfo, Hbaremoteport.Vendor Hbaremoteport.Productid