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

Views, Boot_image_file_details_info, Cee_port_info

Page 178 highlights

E Views Views TABLE 325 VM_PATH (Continued) Field Definition Format Size VM_NODE_WWN The initiator node WWN used by the VM. If NPIV is char 23 used, this is a virtual node WWN assigned to the VM. If NPIV is not used, this WWN is the same as the node WWN of one of the HBAs in the host. TARGET_NODE_WWN The node WWN of the destination target char 23 HBA_NAME The hypervisor device name of the HBA used in this varchar 64 path, such as vmhba1 BOOT_IMAGE_FILE_DETAILS_INFO create or replace view BOOT_IMAGE_FILE_DETAILS_INFO as select BOOT_IMAGE_FILE_DETAILS.BOOT_IMAGE_NAME, BOOT_IMAGE_FILE_DETAILS.MAJOR_VERSION, BOOT_IMAGE_FILE_DETAILS.MINOR_VERSION, BOOT_IMAGE_FILE_DETAILS.MAINTENANCE, BOOT_IMAGE_FILE_DETAILS.PATCH, BOOT_IMAGE_FILE_DETAILS.IMPORTED_DATE, BOOT_IMAGE_FILE_DETAILS.RELEASE_DATE, BOOT_IMAGE_FILE_DETAILS.RELEASE_NOTES_LOCATION, BOOT_IMAGE_FILE_DETAILS.LOCATION, BOOT_IMAGE_DRIVER_MAP.SUPPORTED_DRIVERS from BOOT_IMAGE_FILE_DETAILS, BOOT_IMAGE_DRIVER_MAP where BOOT_IMAGE_FILE_DETAILS.DRIVER_MAPPING_ID= BOOT_IMAGE_DRIVER_MAP.ID; CEE_PORT_INFO create or replace view CEE_PORT_INFO as select GIGE_PORT.ID, GIGE_PORT.SWITCH_PORT_ID, GIGE_PORT.PORT_NUMBER, CEE_PORT.ID AS CEE_PORT_ID, CEE_PORT.VIRTUAL_SWITCH_ID, CEE_PORT.IF_INDEX, CEE_PORT.IF_NAME, CEE_PORT.IF_MODE, CEE_PORT.L2_MODE, CEE_PORT.VLAN_ID, CEE_PORT.LAG_ID, CEE_PORT.IP_ADDRESS, CEE_PORT.MAC_ADDRESS, CEE_PORT.PORT_SPEED, CEE_PORT.ENABLED, 170 Brocade Network Advisor Documentation Updates 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

170
Brocade Network Advisor Documentation Updates
53-1002363-02
Views
E
Views
BOOT_IMAGE_FILE_DETAILS_INFO
create or replace view BOOT_IMAGE_FILE_DETAILS_INFO as
select
BOOT_IMAGE_FILE_DETAILS.BOOT_IMAGE_NAME,
BOOT_IMAGE_FILE_DETAILS.MAJOR_VERSION,
BOOT_IMAGE_FILE_DETAILS.MINOR_VERSION,
BOOT_IMAGE_FILE_DETAILS.MAINTENANCE,
BOOT_IMAGE_FILE_DETAILS.PATCH,
BOOT_IMAGE_FILE_DETAILS.IMPORTED_DATE,
BOOT_IMAGE_FILE_DETAILS.RELEASE_DATE,
BOOT_IMAGE_FILE_DETAILS.RELEASE_NOTES_LOCATION,
BOOT_IMAGE_FILE_DETAILS.LOCATION,
BOOT_IMAGE_DRIVER_MAP.SUPPORTED_DRIVERS
from
BOOT_IMAGE_FILE_DETAILS,
BOOT_IMAGE_DRIVER_MAP
where
BOOT_IMAGE_FILE_DETAILS.DRIVER_MAPPING_ID= BOOT_IMAGE_DRIVER_MAP.ID;
CEE_PORT_INFO
create or replace view CEE_PORT_INFO as
select
GIGE_PORT.ID,
GIGE_PORT.SWITCH_PORT_ID,
GIGE_PORT.PORT_NUMBER,
CEE_PORT.ID AS CEE_PORT_ID,
CEE_PORT.VIRTUAL_SWITCH_ID,
CEE_PORT.IF_INDEX,
CEE_PORT.IF_NAME,
CEE_PORT.IF_MODE,
CEE_PORT.L2_MODE,
CEE_PORT.VLAN_ID,
CEE_PORT.LAG_ID,
CEE_PORT.IP_ADDRESS,
CEE_PORT.MAC_ADDRESS,
CEE_PORT.PORT_SPEED,
CEE_PORT.ENABLED,
VM_NODE_WWN
The initiator node WWN used by the VM. If NPIV is
used, this is a virtual node WWN assigned to the VM.
If NPIV is not used, this WWN is the same as the node
WWN of one of the HBAs in the host.
char
23
TARGET_NODE_WWN
The node WWN of the destination target
char
23
HBA_NAME
The hypervisor device name of the HBA used in this
path, such as vmhba1
varchar
64
TABLE 325
VM_PATH
(Continued)
Field
Definition
Format
Size