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

Database tables and fields E TABLE 84 Field GIGE_PORT_STATS_1DAY (Continued) Definition LATENCY BANDWIDTH Format Size double precision double precision TABLE 87 ISL Field Definition Format Size ID* FABRIC_ID SOURCE_DOMAIN_ID SOURCE_PORT_NUMBER DEST_DOMAIN_ID DEST_PORT_NUMBER COST TYPE TRUSTED CREATION_TIME MISSING MISSING_TIME Fabric DB ID. Source domain ID. Source port number. Destination domain ID. Destination port number. The cost of the link. The type of link. 1 = ISL is trusted 0 = ISL is not trusted Default value is 0. Time at which this record was created. Default value is 'now()'. 1 = ISL is missing 0 = ISL is not missing Default value is 0. Time at which ISL went missing. int int int smallint int smallint int smallint smallint timestamp smallint timestamp TABLE 88 Field FABRIC Definition Format Size ID* int SAN_ID Foreign key to SAN table; usually 1 since there is only int one SAN. SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to char 23 discover the fabric. 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 TYPE Type of fabric: 0 = legacy fabric 1 = base fabric 2 = logical fabric smallint SECURE 1 = it is a secured fabric. smallint AD_ENVIRONMENT 1 = there are user-defined ADs in this fabric. smallint Brocade Network Advisor Documentation Updates 57 53-1002363-02