Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2310)

Brocade Network Advisor SAN + IP User Manual 2273
53-1002949-01
Views
I
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,
HOST_DISCOVERY_OPTION.JSON_PASSWD,
HOST_DISCOVERY_OPTION.DISCOVER_CIM,
HOST_DISCOVERY_OPTION.CIM_IMPL,
HOST_DISCOVERY_OPTION.CIM_USERNAME,
HOST_DISCOVERY_OPTION.CIM_PASSWORD,
HOST_DISCOVERY_OPTION.CIM_NAMESPACE,
HOST_DISCOVERY_OPTION.CIM_PORT,
HOST_DISCOVERY_OPTION.DISCOVER_VM,
HOST_DISCOVERY_OPTION.VM_USERNAME,
HOST_DISCOVERY_OPTION.VM_PASSWORD,
HOST_DISCOVERY_OPTION.JSON_PORT,
HOST_DISCOVERY_OPTION.VM_PORT,
HOST_DISCOVERY_OPTION.
Application_Name_USER_NAME,
HOST_DISCOVERY_OPTION.
Application_Name_SERVER_ADDRESS,
DEVICE_ENCLOSURE.NAME,
DEVICE_ENCLOSURE.TYPE,
DEVICE_ENCLOSURE.ICON,
DEVICE_ENCLOSURE.OS,
DEVICE_ENCLOSURE.APPLICATIONS,
DEVICE_ENCLOSURE.DEPARTMENT,
DEVICE_ENCLOSURE.CONTACT,
DEVICE_ENCLOSURE.LOCATION,
DEVICE_ENCLOSURE.DESCRIPTION,
DEVICE_ENCLOSURE.COMMENT_,
DEVICE_ENCLOSURE.IP_ADDRESS,
DEVICE_ENCLOSURE.VENDOR,
DEVICE_ENCLOSURE.MODEL,
DEVICE_ENCLOSURE.SERIAL_NUMBER,
DEVICE_ENCLOSURE.FIRMWARE,
DEVICE_ENCLOSURE.USER_DEFINED_VALUE1,
DEVICE_ENCLOSURE.USER_DEFINED_VALUE2,
DEVICE_ENCLOSURE.USER_DEFINED_VALUE3,
DEVICE_ENCLOSURE.HCM_AGENT_VERSION,
DEVICE_ENCLOSURE.OS_VERSION,
DEVICE_ENCLOSURE.CREATED_BY,
DEVICE_ENCLOSURE.TRACK_CHANGES,