Brocade Communications Systems IP250 user manual Timeseriesdatainfo, Virtualswitch

Views I

coalesce(SNMP_CREDENTIALS.PORT_NUMBER, (select SNMP_PROFILE.PORT_NUMBER from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_PORT_NUMBER,

coalesce(SNMP_CREDENTIALS.RETRY_COUNT, (select SNMP_PROFILE.RETRY_COUNT from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_RETRY_COUNT,

coalesce(SNMP_CREDENTIALS.TIMEOUT, (select SNMP_PROFILE.TIMEOUT from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_TIMEOUT,

coalesce(SNMP_CREDENTIALS.VERSION, (select SNMP_PROFILE.VERSION from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_VERSION,

coalesce(SNMP_CREDENTIALS.READ_COMMUNITY_STRING, (select SNMP_PROFILE.READ_COMMUNITY_STRING from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_READ_COMMUNITY_STRING,

coalesce(SNMP_CREDENTIALS.WRITE_COMMUNITY_STRING, (select SNMP_PROFILE.WRITE_COMMUNITY_STRING from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_WRITE_COMMUNITY_STRING,

coalesce(SNMP_CREDENTIALS.USER_NAME, (select SNMP_PROFILE.USER_NAME from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_USER_NAME,

coalesce(SNMP_CREDENTIALS.CONTEXT_NAME, (select SNMP_PROFILE.CONTEXT_NAME from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_CONTEXT_NAME,

coalesce(SNMP_CREDENTIALS.AUTH_PROTOCOL, (select SNMP_PROFILE.AUTH_PROTOCOL from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_AUTH_PROTOCOL,

coalesce(SNMP_CREDENTIALS.AUTH_PASSWORD, (select SNMP_PROFILE.AUTH_PASSWORD from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_AUTH_PASSWORD,

coalesce(SNMP_CREDENTIALS.PRIV_PROTOCOL, (select SNMP_PROFILE.PRIV_PROTOCOL from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_PRIV_PROTOCOL,

coalesce(SNMP_CREDENTIALS.PRIV_PASSWORD, (select SNMP_PROFILE.PRIV_PASSWORD from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_PRIV_PASSWORD,

coalesce(SNMP_CREDENTIALS.SNMP_INFORMS_ENABLED, (select SNMP_PROFILE.SNMP_INFORMS_ENABLED from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_INFORMS_ENABLED from

VIRTUAL_SWITCH

left outer join CORE_SWITCH

on VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID left outer join CORE_SWITCH_DETAILS

on CORE_SWITCH.ID = CORE_SWITCH_DETAILS.CORE_SWITCH_ID left outer join FABRIC_MEMBER

on FABRIC_MEMBER.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID left outer join SNMP_CREDENTIALS

on VIRTUAL_SWITCH.ID = SNMP_CREDENTIALS.VIRTUAL_SWITCH_ID;

TIME_SERIES_DATA_INFO

CREATE VIEW time_series_data_info AS

( ( ( ( ( (

select * from TIME_SERIES_DATA_1 union all

select TIME_SERIES_DATA_1_30MIN.TIME_IN_SECONDS, TIME_SERIES_DATA_1_30MIN.TARGET_TYPE, TIME_SERIES_DATA_1_30MIN.MEASURE_ID, TIME_SERIES_DATA_1_30MIN.TARGET_ID, TIME_SERIES_DATA_1_30MIN.COLLECTOR_ID, TIME_SERIES_DATA_1_30MIN.MEASURE_INDEX, TIME_SERIES_DATA_1_30MIN.ME_ID, TIME_SERIES_DATA_1_30MIN.VALUE, TIME_SERIES_DATA_1_30MIN.SUM_VALUE

from TIME_SERIES_DATA_1_30MIN) union all

select TIME_SERIES_DATA_1_2HOUR.TIME_IN_SECONDS, TIME_SERIES_DATA_1_2HOUR.TARGET_TYPE,

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