HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 269

Managed_element_info, Snmp_data_info

Get HP Brocade 8/12c PDF manuals and user guides View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals

Page 269 highlights

Views E radio_interface.beacon_rate, radio_interface.dtim, radio_interface.rts_threshold, radio_interface.is_turbo_mode, radio_interface.radio_g_mode, radio_interface.max_associated_clients FROM radio_interface) wireless ON ((l2.interface_id = wireless.radioif_id))); -- Name: wpa; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE wpa ( authentication_encryption_id integer NOT NULL, cipher_mode numeric(2,0), wpa_mode numeric(2,0) ); -- Name: wpa_psk; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE wpa_psk ( authentication_encryption_id integer NOT NULL, key_type numeric(2,0), key_value character varying(128) ); MANAGED_ELEMENT_INFO Common managed element data used by custom DTO methods to identify the managed element type, and provide a link to the details table for the managed element. Some common managed element fields are included in this view so Fault Management can use this view to identify the managed element ID for an event source. create or replace view MANAGED_ELEMENT_INFO as select MANAGED_ELEMENT.ID as MANAGED_ELEMENT_ID, DEVICE.DEVICE_ID as IP_DEVICE_ID, coalesce(CS_ME.ID, CS_VS.ID) as CORE_SWITCH_ID, VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID, DEVICE_ENCLOSURE.ID as DEVICE_ENCLOSURE_ID, DEVICE.IP_ADDRESS as LAN_IP_ADDRESS, coalesce (CS_VS.IP_ADDRESS, CS_ME.IP_ADDRESS, DEVICE_ENCLOSURE.IP_ADDRESS) as SAN_IP_ADDRESS, VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID, coalesce (VIRTUAL_SWITCH.WWN, CS_ME.WWN, DEVICE.NODE_WWN) as NODE_WWN from MANAGED_ELEMENT left outer join VIRTUAL_SWITCH on MANAGED_ELEMENT.ID = VIRTUAL_SWITCH.MANAGED_ELEMENT_ID left outer join CORE_SWITCH CS_ME on (MANAGED_ELEMENT.ID = CS_ME.MANAGED_ELEMENT_ID) left outer join CORE_SWITCH CS_VS on (CS_VS.ID = VIRTUAL_SWITCH.CORE_SWITCH_ID) left outer join DEVICE on MANAGED_ELEMENT.ID = DEVICE.MANAGED_ELEMENT_ID left outer join DEVICE_ENCLOSURE on MANAGED_ELEMENT.ID = DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID; SNMP_DATA_INFO create or replace view SNMP_DATA_INFO as select * from SNMP_DATA union all select * from SNMP_DATA_30MIN union all Brocade Network Advisor Documentation Updates 261 53-1002363-02

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
Brocade Network Advisor Documentation Updates
261
53-1002363-02
Views
E
radio_interface.beacon_rate, radio_interface.dtim, radio_interface.rts_threshold,
radio_interface.is_turbo_mode, radio_interface.radio_g_mode,
radio_interface.max_associated_clients FROM radio_interface) wireless ON
((l2.interface_id = wireless.radioif_id)));
-- Name: wpa; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE wpa (
authentication_encryption_id integer NOT NULL,
cipher_mode numeric(2,0),
wpa_mode numeric(2,0)
);
-- Name: wpa_psk; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE wpa_psk (
authentication_encryption_id integer NOT NULL,
key_type numeric(2,0),
key_value character varying(128)
);
MANAGED_ELEMENT_INFO
Common managed element data used by custom DTO methods to identify the managed element
type, and provide a link to the details table for the managed element.
Some common managed
element fields are included in this view so Fault Management can use this view to identify the
managed element ID for an event source.
create or replace view MANAGED_ELEMENT_INFO as
select
MANAGED_ELEMENT.ID as MANAGED_ELEMENT_ID,
DEVICE.DEVICE_ID as IP_DEVICE_ID,
coalesce(CS_ME.ID, CS_VS.ID) as CORE_SWITCH_ID,
VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID,
DEVICE_ENCLOSURE.ID as DEVICE_ENCLOSURE_ID,
DEVICE.IP_ADDRESS as LAN_IP_ADDRESS,
coalesce (CS_VS.IP_ADDRESS, CS_ME.IP_ADDRESS, DEVICE_ENCLOSURE.IP_ADDRESS) as
SAN_IP_ADDRESS,
VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID,
coalesce (VIRTUAL_SWITCH.WWN, CS_ME.WWN, DEVICE.NODE_WWN) as NODE_WWN
from
MANAGED_ELEMENT
left outer join VIRTUAL_SWITCH on MANAGED_ELEMENT.ID =
VIRTUAL_SWITCH.MANAGED_ELEMENT_ID
left outer join CORE_SWITCH CS_ME on (MANAGED_ELEMENT.ID =
CS_ME.MANAGED_ELEMENT_ID)
left outer join CORE_SWITCH CS_VS on (CS_VS.ID =
VIRTUAL_SWITCH.CORE_SWITCH_ID)
left outer join DEVICE on MANAGED_ELEMENT.ID = DEVICE.MANAGED_ELEMENT_ID
left outer join DEVICE_ENCLOSURE on MANAGED_ELEMENT.ID =
DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID;
SNMP_DATA_INFO
create or replace view SNMP_DATA_INFO as
select * from SNMP_DATA
union all
select * from SNMP_DATA_30MIN
union all