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

Etable 313

Page 167 highlights

Database tables and fields E TABLE 313 SENSOR Field Definition Format Size ID int CORE_SWITCH_ID int SENSOR_ID Identifies the sensor device , requested by SMIA and int values filled in by Switch Asset Collector. Maps to Device Id in the html page. The default value is -1. CURRENT_READING Identifies the current temperature reading sensor, requested by SMIA and values filled in by Switch Asset Collector, Maps to value field in the html page. The default value is -1. bigint TYPE The default value is -1. int SUB_TYPE The default value is -1. int DESCRIPTION Provides the description of the temperature sensor, varchar 128 requested by SMIA and values filled in by Switch Asset Collector STATUS provides the status of the sensor, requested by SMIA int and values filled in by Switch Asset Collector,Values could be 0 or 1. 0 means faulty and 1 is ok.The default value is -1. OPERATIONAL_STATUS provides the operational status of the sensor, int requested by SMIA and values filled in by Switch Asset Collector will be available only from FOS 6.4 switches and above. The default value is -1. PART_NUMBER provides the part number of the sensor, requested by varchar 64 SMIA and values filled in by Switch Asset Collector will be available only from FOS 6.4 switches and above SERIAL_NUMBER provides the serial number of the sensor, requested varchar 64 by SMIA and values filled in by Switch Asset Collector will be available only from FOS 6.4 switches and above VERSION provides the version of the sensor, requested by varchar 32 SMIA and values filled in by Switch Asset Collector will be available only from FOS 6.4 switches and above CREATION_TIME provides the record creation time, standard columns for Management applciation and values filled in by Switch Asset Collector timestamp LAST_UPDATE_TIME provides the record last updated time, standard columns for Management applciation and values filled in by Switch Asset Collector timestamp FRU_TYPE provides the type of the sensor, requested by SMIA int and values filled in by Switch Asset Collector will be available only from FOS 6.4 switches and above. The values represents FAN,PS, SLOT etc. The default value is -1. Brocade Network Advisor Documentation Updates 159 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
159
53-1002363-02
Database tables and fields
E
TABLE 313
SENSOR
Field
Definition
Format
Size
ID
int
CORE_SWITCH_ID
int
SENSOR_ID
Identifies the sensor device , requested by SMIA and
values filled in by Switch Asset Collector. Maps to
Device Id in the html page.
The default value is -1.
int
CURRENT_READING
Identifies the current temperature reading sensor,
requested by SMIA and values filled in by Switch
Asset Collector, Maps to value field in the html page.
The default value is -1.
bigint
TYPE
The default value is -1.
int
SUB_TYPE
The default value is -1.
int
DESCRIPTION
Provides the description of the temperature sensor,
requested by SMIA and values filled in by Switch
Asset Collector
varchar
128
STATUS
provides the status of the sensor, requested by SMIA
and values filled in by Switch Asset Collector,Values
could be 0 or 1. 0 means faulty and 1 is ok.The
default value is -1.
int
OPERATIONAL_STATUS
provides the operational status of the sensor,
requested by SMIA and values filled in by Switch
Asset Collector will be available only from FOS 6.4
switches
and above. The default value is -1.
int
PART_NUMBER
provides the part number of the sensor, requested by
SMIA and values filled in by Switch Asset Collector
will be available only from FOS 6.4 switches and
above
varchar
64
SERIAL_NUMBER
provides the serial number of the sensor, requested
by SMIA and values filled in by Switch Asset Collector
will be available only from FOS 6.4 switches and
above
varchar
64
VERSION
provides the version of the sensor, requested by
SMIA and values filled in by Switch Asset Collector
will be available only from FOS 6.4 switches and
above
varchar
32
CREATION_TIME
provides the record creation time, standard columns
for Management applciation and values filled in by
Switch Asset Collector
timestamp
LAST_UPDATE_TIME
provides the record last updated time, standard
columns for Management applciation and values
filled in by Switch Asset Collector
timestamp
FRU_TYPE
provides the type of the sensor, requested by SMIA
and values filled in by Switch Asset Collector will be
available only from FOS 6.4 switches and
above. The
values represents FAN,PS, SLOT etc. The default
value is -1.
int