Brocade Network Advisor SAN + IP User Manual v12.3.0 - Manual (Page 2608)

2536 Brocade Network Advisor SAN + IP User Manual
53-1003155-01
Views
I
CNA_ETH_PORT.CNA_PORT_ID and CNA_PORT.ID = CNA_ETH_PORT.CNA_PORT_ID and
DEVICE_PORT.NPV_PHYSICAL=0
) as ADAPTER_PORT,
(select HBA_PORT.HBA_ID, count(HBA_PORT.DEVICE_PORT_ID) as PORT_COUNT from
HBA_PORT,
DEVICE_PORT_INFO where HBA_PORT.DEVICE_PORT_ID = DEVICE_PORT_INFO.ID and
DEVICE_PORT_INFO.NPV_PHYSICAL = 0 group by (HBA_PORT.HBA_ID)) as
ADAPTER_PORT_COUNT
where
DEVICE_ENCLOSURE.MANAGED_BY in (2,4)
and DEVICE_ENCLOSURE.ID = HBA.HOST_ID
and ADAPTER_PORT.HBA_ID = HBA.ID
and ADAPTER_PORT.DEVICE_PORT_ID = DEVICE_PORT_INFO.ID
and HBA_PORT_DETAIL.DEVICE_PORT_ID = DEVICE_PORT_INFO.ID
and ADAPTER_PORT_COUNT.HBA_ID = HBA.ID
order by
DEVICE_ENCLOSURE.IP_ADDRESS, HBA.WWN, ADAPTER_PORT.PHYSICAL_PORT_WWN;
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,