Brocade Communications Systems IP250 user manual Deviceconnectioninfo

I Views

DEPLOYMENT_CONFIGURATION.SCHEDULE_ENABLED,

DEPLOYMENT_CONFIGURATION.SNAPSHOT_ENABLED,

DEPLOYMENT_CONFIGURATION.MANAGEMENT_FLAG, DEPLOYMENT_HANDLER.PRIVILEGE_ID, DEPLOYMENT_HANDLER.HANDLER_CLASS, DEPLOYMENT_HANDLER.CLIENT_ACTION_HANDLER_CLASS, DEPLOYMENT_STATUS.ID as STATUS_ID,

DEPLOYMENT_HANDLER.MODULE_DISPLAYNAME,

DEPLOYMENT_STATUS.TRIGGER_SOURCE as TRIGGER_SOURCE, DEPLOYMENT_REPORT_TEMPLATE.HEADER, DEPLOYMENT_REPORT_TEMPLATE.FOOTER

from

DEPLOYMENT_CONFIGURATION

inner join DEPLOYMENT_HANDLER

on DEPLOYMENT_CONFIGURATION.DEPLOYMENT_HANDLER_ID =

DEPLOYMENT_HANDLER.ID

inner join DEPLOYMENT_STATUS

on DEPLOYMENT_CONFIGURATION.ID =

DEPLOYMENT_STATUS.DEPLOYMENT_CONFIGURATION_ID

left outer join DEPLOYMENT_REPORT_TEMPLATE on

DEPLOYMENT_REPORT_TEMPLATE.DEPLOYMENT_HANDLER_ID = DEPLOYMENT_HANDLER.ID;

DEVICE_CONNECTION_INFO

CREATE VIEW device_connection_info AS select

DEVICE_CONNECTION.ID,

DEVICE_CONNECTION.FABRIC_ID, DEVICE_CONNECTION.DEVICE_PORT_ID, DEVICE_CONNECTION.SWITCH_PORT_ID, DEVICE_CONNECTION.AG_PORT_ID, COALESCE(DEVICE_ENCLOSURE_MEMBER.ENCLOSURE_ID, HBA.HOST_ID) as

DEVICE_ENCLOSURE_ID, DEVICE_CONNECTION.CREATION_TIME, DEVICE_CONNECTION.LAST_UPDATED_TIME, DEVICE_PORT.NODE_ID,

DEVICE_CONNECTION.MISSING, DEVICE_CONNECTION.MISSING_TIME, SWPORT.VIRTUAL_SWITCH_ID, DEVICE_CONNECTION.TRUSTED, AGPORT.VIRTUAL_SWITCH_ID as AG_SWITCH_ID, DEVICE_PORT.WWN as DEVICE_PORT_WWN, COALESCE(USERDEFINEDDETAILS.TYPE, DN.TYPE) as DEVICE_TYPE

from DEVICE_CONNECTION

left join DEVICE_PORT on DEVICE_CONNECTION.DEVICE_PORT_ID = DEVICE_PORT.ID left join SWITCH_PORT SWPORT on DEVICE_CONNECTION.SWITCH_PORT_ID = SWPORT.ID left join SWITCH_PORT AGPORT on DEVICE_CONNECTION.AG_PORT_ID = AGPORT.ID left join HBA_PORT_DEVICE_PORT_MAP on DEVICE_PORT.ID =

HBA_PORT_DEVICE_PORT_MAP.DEVICE_PORT_ID

left join HBA_PORT on HBA_PORT_DEVICE_PORT_MAP.HBA_PORT_ID =

HBA_PORT.DEVICE_PORT_ID

left join HBA on HBA_PORT.HBA_ID = HBA.ID

left join DEVICE_ENCLOSURE_MEMBER on DEVICE_PORT.ID =

DEVICE_ENCLOSURE_MEMBER.DEVICE_PORT_ID

left join DEVICE_NODE DN on DEVICE_PORT.NODE_ID = DN.ID

left join USER_DEFINED_DEVICE_DETAIL USERDEFINEDDETAILS on DN.WWN =

USERDEFINEDDETAILS.WWN;

1608	Brocade Network Advisor IP User Manual
	53-1003056-01