Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

1088 Brocade Network Advisor SAN User Manual
53-1002167-01
Database tables and fields
E
TIMESTAMP_ When the last successful collection is done. timestamp
LAST_COLLECTED_STATUS Status of the last collection, successful or not. 200 is
for successful. Values are standard HTTP protocol
values.
smallint
TABLE 292 CRYPTO_HOST
Field Definition Format Size
ID int
CRYPTO_TARGET_CONTAINE
R_ID
Foreign key reference to the
CRYPTO_TARGET_CONTAINER that contains this
host.
int
VI_NODE_WWN Node WWN of Virtual Initiator that represents this
host.
char 23
VI_PORT_WWN Port WWN of Virtual Initiator that represents this
host.
char 23
HOST_PORT_WWN Physical (real) host''s Port WWN char 23
HOST_NODE_WWN Physical (real) host''s Node WWN char 23
TABLE 293 CRYPTO_LUN
Field Definition Format Size
ID int
CRYPTO_TARGET_CONTAI
NER_ID
Foreign key reference to the CRYPTO_TARGET_CONTAINER
that contains the host for which these LUNs are configured.
int
SERIAL_NUMBER The LUN serial number, used to identify the physical
LUN.
varchar 256
ENCRYPTION_STATE Boolean. True (1) if LUN is being encrypted. False (0)
if cleartext.';
The default value is 0.
smallint
STATUS Not currently used but left in for possible future use.
Replaced by LUN_STATE. The default value is 0.
smallint
REKEY_INTERVAL The number of days that data encryption keys should
be used before automatically generated a new key. 0 =
infinite, i.e., no re-keying.
int
VOLUME_LABEL_PREFIX A user-configured string used to construct the
Brocade-specific volume label on encrypted tapes.
Ignored for disk LUNs.
varchar 256
LAST_REKEY_DATE The last time a data encryption key was generated for
this LUN. REKEY_INTERVAL days after this date, a new
key will be generated.
timestamp
LAST_REKEY_STATUS The success or failure of the most recent re-keying
operation, if any. This field is not currently used, but is
left in the hope that FOS will support it in the future.
Only valid for disk LUNs. The default value is 0.
smallint
TABLE 291 COLLECTOR_END_TIMESTAMP (Continued)
Field Definition Format Size