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

Stats, TABLE 155

Page 93 highlights

Database tables and fields E Stats TABLE 155 FAVORITES Field ID* NAME USER_ TOP_N SELECTION_FILTER FROM_TIME CUSTOM_LAST_VALUE CUSTOM_TIME_UNIT CUSTOM_FROM CUSTOM_TO GRANULARITY THRESHOLD MAIN_MEASURE ADDITIONAL_MEASURE Definition Format int Name of the favorite. varchar The application user credentials. varchar The top number of ports(5,10,15,20). varchar Types of ports (FC/FCIP/GE) and -End Monitors. varchar The time interval in which the graph is shown. Time interval can be predefined or custom. If FROM_TIME is Custom, the user can choose the number of minutes/hours/days or specify the time interval. varchar The number of minutes/hours/days. It becomes null int in two cases. 1. When the value of FROM_TIME is not Custom. 2. When FROM_TIME is Custom, and user chooses the time interval (CUSTOM_FROM and CUSTOM_TO) The unit type (Minutes, Hours, Days) of the CUSTOM_LAST_VALUE. varchar The starting time. timestamp The ending time. timestamp The granularity. varchar The reference line. int The measure of FC/FCIP/GE. varchar The additional measures. int TABLE 156 USER_ Field ID * NAME DESCRIPTION PASSWORD EMAIL NOTIFICATION_ENABLED FULL_NAME PHONE_NUMBER INVALID_LOGIN_COUNT Definition Format int User name. varchar User description. varchar User password. varchar User e-mail ID. varchar Flag for e-mail notification. Default value is 0. smallint User''s Full Name. varchar User''s Phone number. varchar This is a counter filed to identify the number of invalid login attempts. Note: After successful login this filed will be set to NULL. Default value is 0. smallint Size 64 128 40 40 40 40 40 40 Size 128 512 512 1024 512 32 Brocade Network Advisor Documentation Updates 85 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
85
53-1002363-02
Database tables and fields
E
Stats
TABLE 155
FAVORITES
Field
Definition
Format
Size
ID*
int
NAME
Name of the favorite.
varchar
64
USER_
The application user credentials.
varchar
128
TOP_N
The top number of ports(5,10,15,20).
varchar
40
SELECTION_FILTER
Types of ports (FC/FCIP/GE) and -End Monitors.
varchar
40
FROM_TIME
The time interval in which the graph is shown. Time
interval can be predefined or custom. If FROM_TIME
is Custom, the user can choose the number of
minutes/hours/days or specify the time interval.
varchar
40
CUSTOM_LAST_VALUE
The number of minutes/hours/days. It becomes null
in two cases.
1. When the value of FROM_TIME is not Custom.
2. When FROM_TIME is Custom, and user chooses
the time interval (CUSTOM_FROM and CUSTOM_TO)
int
CUSTOM_TIME_UNIT
The unit type (Minutes, Hours, Days) of the
CUSTOM_LAST_VALUE.
varchar
40
CUSTOM_FROM
The starting time.
timestamp
CUSTOM_TO
The ending time.
timestamp
GRANULARITY
The granularity.
varchar
40
THRESHOLD
The reference line.
int
MAIN_MEASURE
The measure of FC/FCIP/GE.
varchar
40
ADDITIONAL_MEASURE
The additional measures.
int
TABLE 156
USER_
Field
Definition
Format
Size
ID *
int
NAME
User name.
varchar
128
DESCRIPTION
User description.
varchar
512
PASSWORD
User password.
varchar
512
EMAIL
User e-mail ID.
varchar
1024
NOTIFICATION_ENABLED
Flag for e-mail notification.
Default value is 0.
smallint
FULL_NAME
User''s Full Name.
varchar
512
PHONE_NUMBER
User''s Phone number.
varchar
32
INVALID_LOGIN_COUNT
This is a counter filed to identify the number of invalid
login attempts.
Note: After successful login this filed will be set to
NULL.
Default value is 0.
smallint