Host_discovery_requests_info – Brocade Network Advisor IP User Manual v12.3.0 User Manual
Page 1843
Brocade Network Advisor IP User Manual
1791
53-1003153-01
Views
I
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,
DEVICE_ENCLOSURE.LAST_UPDATE_TIME,
DEVICE_ENCLOSURE.LAST_UPDATE_MODULE,
DEVICE_ENCLOSURE.TRUSTED,
DEVICE_ENCLOSURE.CREATION_TIME,
DEVICE_ENCLOSURE.MISSING,
DEVICE_ENCLOSURE.MISSING_TIME,
DEVICE_ENCLOSURE.HOST_NAME,
DEVICE_ENCLOSURE.SYSLOG_REGISTERED,
DEVICE_ENCLOSURE.VIRTUALIZATION,
DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID,
HOST_DISCOVERY_REQUEST.MANAGEMENT_STATE_DETAILS
from
HOST_DISCOVERY_REQUEST
join HOST_DISCOVERY_OPTION on
HOST_DISCOVERY_REQUEST.HOST_DISCOVERY_OPTION_ID = HOST_DISCOVERY_OPTION.ID
left outer join DEVICE_ENCLOSURE on
HOST_DISCOVERY_REQUEST.DEVICE_ENCLOSURE_ID = DEVICE_ENCLOSURE.ID;
HOST_DISCOVERY_REQUESTS_INFO
create or replace view HOST_DISCOVERY_REQUESTS_INFO as
select HOST_DISCOVERY_REQUESTS.ID,
HOST_DISCOVERY_REQUESTS.HOST_NAME as REQUEST_HOST_NAME,
HOST_DISCOVERY_REQUESTS.DEVICE_ENCLOSURE_ID,
HOST_DISCOVERY_REQUESTS.HOST_DISCOVERY_REQ_GROUP_ID,
HOST_DISCOVERY_REQUESTS.HOST_DISCOVERY_OPTIONS_ID,
HOST_DISCOVERY_REQUESTS.DISCOVERY_STATE,
HOST_DISCOVERY_REQUESTS.REQUEST_STATE,
HOST_DISCOVERY_REQUESTS.REQUEST_STATE_DETAILS,
HOST_DISCOVERY_OPTIONS.DISCOVERY_TYPE,
HOST_DISCOVERY_OPTIONS.USERNAME,
HOST_DISCOVERY_OPTIONS.PASSWORD,
HOST_DISCOVERY_OPTIONS.PORT,
HOST_DISCOVERY_OPTIONS.SSL_ENABLED,
HOST_DISCOVERY_OPTIONS.NAMESPACE,
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,