User's Manual

1428 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
SOURCE_NAME Name of the source. varchar 1024
DESCRIPTION_CONTAINS Description pattern about the rule. varchar 255
LAST_MODIFIED_TIME Rules last edited time. timestamp
SELECTED_TIME_UNIT Timestamp unit of the selected rule:
• 0 = second
• 1 = Minutes
• 2 = Hours
Default value is 1.
smallint
TABLE 126 EVENT_RULE_ACTION
Field Definition Format Size
ID* int
RULE_ID The rule ID present in the Event_Rule Table. int
NAME Name of the Event Rule Action:
• Launch Script = for launch script
• Send E-mail = for send e-mail
• Raise Event = for broadcast message
varchar 255
TYPE Name of the action:
• script = for Launch Script
• e-mail = for E-mail
• message = for Broadcast message
varchar 30
FIELD1 Data for the selected action. varchar 512
FIELD2 Data for the selected action. varchar 512
FIELD3 Data for the selected action. varchar 512
FIELD4 Data for the selected action. varchar 512
STATE State of the Action:
• 0 = Action Disabled
• 1 = Action Enabled
Default value is 0.
smallint
TABLE 127 FABRIC
Field Definition Format Size
ID* Unique generated database identifier. int
SAN_ID Foreign key to SAN table; usually 1 since there is only
one SAN.
int
SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to
discover the fabric.
char 23
NAME User-assigned fabric name. varchar 256
CONTACT User-assigned "contact" for the fabric. varchar 256
LOCATION User-assigned "location" for the fabric. varchar 256
DESCRIPTION User-assigned fabric description. varchar 256
TABLE 125 EVENT_RULE (Continued)
Field Definition Format Size