Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1845 / 1940

Brocade Network Advisor SAN User Manual 1793
53-1003154-01
Views
H
HOST_INVENTORY_REPORT_INFO
CREATE OR REPLACE VIEW host_inventory_report_info AS
select
DEVICE_ENCLOSURE.ID as DEVICE_ENCLOSURE_ID,
DEVICE_ENCLOSURE.NAME as HOST_NAME,
DEVICE_ENCLOSURE.IP_ADDRESS as HOST_IP,
case when (DEVICE_ENCLOSURE.VENDOR is null or DEVICE_ENCLOSURE.VENDOR = '') then
'NA' else
DEVICE_ENCLOSURE.VENDOR end as HOST_VENDOR,
DEVICE_ENCLOSURE.MODEL as HOST_MODEL,
DEVICE_ENCLOSURE.OS as HOST_OS,
DEVICE_ENCLOSURE.LOCATION as HOST_LOCATION,
DEVICE_ENCLOSURE.CONTACT as HOST_CONTACT,
DEVICE_ENCLOSURE.DESCRIPTION as HOST_DESC,
DEVICE_ENCLOSURE.HCM_AGENT_VERSION as AGENT_VERSION,
USER_DEFINED_DEVICE_DETAIL.NAME as ADAPTER_NAME,
HBA.NAME as ADAPTER_NAME_HCM,
HBA.WWN as ADAPTER_WWN,
HBA.OPERATING_STATUS as ADAPTER_STATUS,
HBA.MODEL as ADAPTER_MODEL,
HBA.VENDOR as ADPATER_VENDOR,
HBA.SERIAL_NUMBER as ADAPTER_SERIAL_NO,
HBA.FIRMWARE_VERSION as ADAPTER_FIRMWARE,
HBA.BIOS_VERSION as ADAPTER_BIOS_VERSION,
HBA.DRIVER_VERSION as ADAPTER_DRIVER_VERSION,
case when (ADAPTER_PORT.CNA_PORT_ID is not null or HBA.VPD_OEM_INFO = '') then
'N/A' else
HBA.VPD_OEM_INFO end as ADAPTER_OEM_INFO,
case when ADAPTER_PORT.PCIF_INDEX != '' then ADAPTER_PORT.PCIF_INDEX else
ADAPTER_PORT.PORT_NUMBER :: varchar end as ADAPTER_PORT_ID,
case when ADAPTER_PORT.TYPE = 'IP-Port' then ADAPTER_PORT.ETH_DEV else
DEVICE_PORT_INFO.NAME end as ADAPTER_PORT_NAME,
ADAPTER_PORT.NAME as ADAPTER_PORT_NAME_HCM,
DEVICE_PORT_INFO.SYMBOLIC_NAME as ADAPTER_SYMBOLIC_NAME,
case when ADAPTER_PORT.TYPE != 'IP-Port' then ADAPTER_PORT.PORT_NWWN else
ADAPTER_PORT.MAC_ADDRESS end as ADAPTER_NODE_WWN,
case when ADAPTER_PORT.type != 'IP-Port' then DEVICE_PORT_INFO.WWN else
ADAPTER_PORT.MAC_ADDRESS end as ADAPTER_PORT_WWN,
HBA_PORT_DETAIL.QOS_CONFIGURED_STATE as ADAPTER_PORT_QOS_CONFIGURED_STATE,
HBA_PORT_DETAIL.FRAME_DATA_FIELD_SIZE as ADAPTER_PORT_FRAME_DATA_FIELD_SIZE,
HBA_PORT_DETAIL.MEDIA as ADAPTER_PORT_MEDIA,
HBA_PORT_DETAIL.ALARM_WARNING as ADAPTER_ALARM_WARNING,
DEVICE_PORT_INFO.port_id as adapter_port_FCaadress,
case when ADAPTER_PORT.type = 'FC' then DEVICE_PORT_INFO.type else
ADAPTER_PORT.type
end as adapter_port_type,
HBA_PORT_DETAIL.FABRIC_NAME as ADAPTER_PORT_FABRIC_NAME,
case when (HBA_PORT_DETAIL.FAA_STATUS = 0) then 'NA' else (case when
(HBA_PORT_DETAIL.FAA_STATUS = 1) then 'Disabled' else 'Enabled' end) end as