Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

ManualsBrandsHP ManualsSoftwareHP B-series Data Center Fabric Manager Enterprise Software

1451

Brocade Network Advisor SAN User Manual 1407

53-1002696-01

Views

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,