HP Brocade BladeSystem 4/12 Brocade Network Advisor SAN User Manual v11.1x (53 - Page 1131

Database tables and fields E TABLE 289 CNA_PORT Field Definition Format ID PORT_NUMBER PORT_WWN NODE_WWN PHYSICAL_PORT_TYPE NAME MAC_ADDRESS MEDIA CEE_STATE HBA_ID CREATION_TIME FACTORY_PORT_WWN FACTORY_NODE_WWN PREBOOT_CREATED Primary key autogenerated ID int Port number of the CNA port int Port WWN of the port char Node WWN of the port char Port type CNA/FC varchar Name of the port varchar MAC address of the port. varchar Media of the port varchar State of the port. varchar ID of the port. int timestamp Factory configured Port WWN defined for the CNA port varchar in HCM Factory configured Node WWN defined for the CNA port varchar in HC Flag to identify vports created during preboot and will accept string values True/false/empty varchar TABLE 290 COLLECTION_END_TIMESTAMP Field Definition COLLECTOR_SOURCE COLLECTOR_NAME TIMESTAMP_ LAST_COLLECTED_STATUS The default value is 0. FIRST_COLLECTION_TIME STAMP SUCCESSFUL_RUNS FAILED_RUNS LAST_FAILURE_TIMESTAM P LAST_SUCCESSFUL_TIME STAMP Format varchar varchar timestamp smallint timestamp bigint bigint timestamp timestamp TABLE 291 COLLECTOR_END_TIMESTAMP Field Definition COLLECTOR_SOURCE * COLLECTOR_NAME * Internal key for switches and fabrics for which collection is undertaken. Collection name, Java class used to collect specific fabric or switch information. Format varchar varchar Size 23 23 32 256 64 64 64 23 23 23 Size 256 256 Size 256 256 Brocade Network Advisor SAN User Manual 53-1002167-01 1087