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

Database tables and fields E Device TABLE 37 Field DEVICE_PORT Definition Format Size ID* int NODE_ID DB ID of the device node to which this port belongs. int DOMAIN_ID Domain ID of the switch to which this device port is int attached. WWN Device port WWN. char 23 SWITCH_PORT_WWN WWN of the switch port to which this device port is char 23 attached. NUMBER Switch port number to which this device is attached. smallint PORT_ID Device port ID. varchar 6 TYPE Device port type, such as N or NL. varchar 32 SYMBOLIC_NAME Device port symbolic name. varchar 256 FC4_TYPE FC payload protocol. varchar 64 COS FC class of service. varchar 16 IP_PORT varchar 63 HARDWARE_ADDRESS varchar 32 TRUSTED 1 if found at discovery time or user has entrusted this device port explicitly. Default value is 0. smallint CREATION_TIME When the device port was discovered, i.e., created in the DB. default is 'now()'. timestamp MISSING 1 if that device port is missing from the fabric. Default value is 0. smallint MISSING_TIME Time when it misses. timestamp NPV_PHYSICAL Update NPV device type on this given device port. The value "npvPhysical" on the device port will be 1 when the device port has reference to a device node of DEVICE_TYPE value 0 i.e. physical. It points to a switch port to which at least one other device port points; and that other pointing device port has reference to a device node of DEVICE_TYPE value 2 (NPV). smallint EDGE_SWITCH_PORT_WW Edge switch port WWN will be the same as the char 23 N Switch_Port_WWN except in the case of devices behind the AG. This field will be updated by the name server info collector, added for the feature support of AG WWN N port mapping. This is a null able field. It is used to determine which mapping is used by the AG. Brocade Network Advisor Documentation Updates 29 53-1002363-02