Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1455 / 1505

Brocade Network Advisor SAN User Manual 1407
53-1002696-01
Views
H
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 or replace 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
from TIME_SERIES_DATA_1_30MIN)
union all
select TIME_SERIES_DATA_1_2HOUR.TIME_IN_SECONDS,
TIME_SERIES_DATA_1_2HOUR.TARGET_TYPE,
TIME_SERIES_DATA_1_2HOUR.MEASURE_ID,
TIME_SERIES_DATA_1_2HOUR.TARGET_ID,
TIME_SERIES_DATA_1_2HOUR.COLLECTOR_ID,
TIME_SERIES_DATA_1_2HOUR.MEASURE_INDEX,
TIME_SERIES_DATA_1_2HOUR.ME_ID,
TIME_SERIES_DATA_1_2HOUR.VALUE
from TIME_SERIES_DATA_1_2HOUR)
union all
select TIME_SERIES_DATA_1_1DAY.TIME_IN_SECONDS,
TIME_SERIES_DATA_1_1DAY.TARGET_TYPE,
TIME_SERIES_DATA_1_1DAY.MEASURE_ID,
TIME_SERIES_DATA_1_1DAY.TARGET_ID,
TIME_SERIES_DATA_1_1DAY.COLLECTOR_ID,
TIME_SERIES_DATA_1_1DAY.MEASURE_INDEX,
TIME_SERIES_DATA_1_1DAY.ME_ID,
TIME_SERIES_DATA_1_1DAY.VALUE
from TIME_SERIES_DATA_1_1DAY)
union all
select * from TIME_SERIES_DATA_2)
union all
select TIME_SERIES_DATA_2_30MIN.TIME_IN_SECONDS,
TIME_SERIES_DATA_2_30MIN.TARGET_TYPE,
TIME_SERIES_DATA_2_30MIN.MEASURE_ID,
TIME_SERIES_DATA_2_30MIN.TARGET_ID,
TIME_SERIES_DATA_2_30MIN.COLLECTOR_ID,