Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1540 Brocade Network Advisor SAN User Manual
53-1002948-01
Views
H
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;
HOST_DISCOVERY_REQUEST_INFO
create or replace view HOST_DISCOVERY_REQUEST_INFO as
select
HOST_DISCOVERY_REQUEST.ID,
HOST_DISCOVERY_REQUEST.HOST_NAME AS REQUEST_HOST_NAME,
HOST_DISCOVERY_REQUEST.DEVICE_ENCLOSURE_ID,
HOST_DISCOVERY_REQUEST.REQUEST_GROUP_ID,
HOST_DISCOVERY_REQUEST.HOST_DISCOVERY_OPTION_ID,
HOST_DISCOVERY_REQUEST.VM_MANAGEMENT_STATE,
HOST_DISCOVERY_REQUEST.JSON_MANAGEMENT_STATE,
HOST_DISCOVERY_REQUEST.CIM_MANAGEMENT_STATE,
HOST_DISCOVERY_REQUEST.MANAGEMENT_STATE,
HOST_DISCOVERY_OPTION.DISCOVER_JSON,
HOST_DISCOVERY_OPTION.JSON_USERNAME,