53-1002363-03 26 August 2011 Network Advisor Documentation Updates Supporting Network Advisor 11.1.
Copyright © 2010 Brocade Communications Systems, Inc. All Rights Reserved. Brocade, the B-wing symbol, BigIron, DCFM, DCX, Fabric OS, FastIron, IronView, NetIron, SAN Health, ServerIron, TurboIron, and Wingspan are registered trademarks, and Brocade Assurance, Brocade NET Health, Brocade One, Extraordinary Networks, MyBrocade, and VCS are trademarks of Brocade Communications Systems, Inc., in the United States and/or in other countries.
Contents About This Document In this chapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii How this document is organized . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii Document feedback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii Chapter 1 Brocade Network Advisor Installation Guide In this chapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Appendix E Database Fields In this appendix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Database tables and fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Advanced Call Home . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Capability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Client_view . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
N2F_PORT_MAP_INFO. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177 DEVICE_NODE_INFO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .178 DEVICE_PORT_INFO. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .178 DEV_PORT_GIGE_PORT_LINK_INFO. . . . . . . . . . . . . . . . . . . . .180 DEV_PORT_MAC_ADDR_MAP_INFO . . . . . . . . . . . . . . . . . . . . .180 ETHERNET_ISL_INFO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .180 EVENT_DETAILS_INFO . .
vi Brocade Network Advisor Documentation Updates 53-1002363-02
About This Document In this chapter • How this document is organized . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii • Document feedback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii How this document is organized This document contains updates to the following Network Advisor manuals: TABLE 1 Brocade Network Advisor 11.1.
viii Brocade Network Advisor Documentation Updates 53-1002363-02
Chapter Brocade Network Advisor Installation Guide 1 In this chapter The updates in this chapter are for the Brocade Network Advisor Installation Guide, part number: 53-1002320-01, published May 2010. • Operating system requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Operating system requirements In Table 5, “Server operating system requirements,” on page 14, add ESX Server 4.1 to the VMware versions.
1 2 Operating system requirements Brocade Network Advisor Documentation Updates 53-1002363-02
Chapter Brocade Network Advisor Migration Guide 2 In this chapter The updates in this chapter are for the Brocade Network Advisor Migration Guide, part number: 53-1002321-01, published May 2011. • Operating system requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 • Network Advisor migration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
2 4 Network Advisor migration Brocade Network Advisor Documentation Updates 53-1002363-02
Chapter Brocade Network Advisor SAN User Manual 3 In this chapter The updates in this chapter are for the Brocade Network Advisor SAN User Manual, part number: 53-1002167-01, published May 2011. • Chapter 1, Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 • Chapter 4, Application Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 • Chapter 8, Third-party tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
3 Chapter 1, Getting Started Chapter 1, Getting Started In the section “User interface components,” on page 2, replace Figure 1 with the following: 1 2 3 4 FIGURE 1 Main window Chapter 4, Application Configuration In the section “Configuring an internal FTP server,” on page 124 change step 4 as follows: 4. Change your password by entering a new password in the Password and Confirm Password fields. The default password is passw0rd (zero).
Chapter 8, Third-party tools 3 Chapter 8, Third-party tools In the section “Launching Web Tools,” on page 200, change Fabro OS to Fabric OS. In the section “Launching Web Tools,” on page 200, change the second Note as follows: NOTE When you close the Management application client, any Web Tools instance launched from the clients closes as well.
3 Chapter 10, SAN Device Configuration In the section “Restoring a configuration from the repository,” on page 256, replace Figure 94 with the following: FIGURE 94 Switch Configuration Repository In the section “Viewing configuration file content,” on page 257, replace Figure 95 with the following: FIGURE 95 8 Configuration file content Brocade Network Advisor Documentation Updates 53-1002363-02
Chapter 13, Host Management 3 Chapter 13, Host Management In the section “Adapter software,” on page 316, replace Figure 107 with the following: FIGURE 107 Adapter Software dialog box, Driver tab In the section “Deleting a boot image from the repository,” on page 318, change the title as follows: Deleting a driver file from the repository Chapter 18, SAN Encryption configuration In the section “Adding target disk LUNs for encryption,” on page 516, replace Figure 226 with the following: FIGURE 226 Encr
3 Chapter 19, Zoning Chapter 19, Zoning In the section “Zone database size,” on page 573, change the supported maximum zone database size to 2 MB. Chapter 26, Troubleshooting In the section “Configuring IP ping,” on page 748, change the second notes as follows: NOTE IP Perf is not supported on the Fabric OS 8 Gbps Extension Switch or Blade.
Chapter 31, Technical Support 3 In the section “Generating a historical performance graph,” on page 780, add the following note to step 3 b: NOTE Devices with 10GE ports must have the rmon MIB enabled on the switch. For more information about the rmon collection command, refer to the Fabric OS Converged Enhanced Ethernet Command Reference. In the section “Filtering data by ports,” on page 782, add the following note to step 3: NOTE Devices with 10GE ports must have the rmon MIB enabled on the switch.
3 12 Appendix E, Database Fields Brocade Network Advisor Documentation Updates 53-1002363-02
Chapter Virtual Connect Enterprise Manager Guide 4 In this chapter The updates in this chapter are for the Virtual Connect Enterprise Manager Guide, part number: 53-1002308-01, published May 2011. • VCEM integration support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4 14 VCEM integration support Brocade Network Advisor Documentation Updates 53-1002363-02
Appendix Database Fields E In this appendix Tables • Advanced Call Home . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 • Capability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 • Client_view . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 • Collector . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
E In this appendix • Threshold . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100 • User Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 • Zoning 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106 Views • BOOT_IMAGE_FILE_DETAILS_INFO. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • CEE_PORT_INFO . . . . . . . .
E Database tables and fields • ROLE_PRIVILEGE_INFO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • SCOM_EE_MONITOR_INFO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • SENSOR_INFO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • SMART_CARD_USAGE_INFO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • SWITCH_DETAILS_INFO . . . . . . . . . . . . . . . . . . . . . . . .
E Database tables and fields TABLE 3 ACH_EVENT_FILTER_MAP Field Definition Format FILTER_ID * ID of the event filter. int EVENT_ID * Event ID which needs to be associated with the filter. int Definition Format TABLE 4 Size ACH_EVENT Field ID * Size int REASON_CODE Reason code of the event. varchar 256 FRU_CODE FRU code of the event. varchar 256 DESCRIPTION Description of the event. varchar 256 SEVERITY Severity of the event. int TYPE Type of the event.
E Database tables and fields TABLE 8 CARD_CAPABILITY Field Definition Format CARD_ID * DB ID of the card. int CAPABILITY_ * Name of the capability detected on the card. varchar ENABLED 1 = the capability is enabled on the card. Default value is 0. int TABLE 9 256 VIRTUAL_SWITCH_CAPABILITY Field Definition Format VIRTUAL-SWITCH_ID * DB ID of virtual switch. int CAPABILITY_ * Name of capability detected on virtual switch.
E Database tables and fields TABLE 10 CARD (Continued) Field Definition Format FCIP_CIRCUIT_CAPABLE The blade is capable of creating FCIP Circuits. 1 = true. 0 = false. Default value is 0. smallint FCIP_LICENSED FCIP Advanced Extension Licensing is available. 1 = available. 0 = not licensed. -1 = not supported. Default value is -1. smallint MAX_FCIP_TUNNELS The maximum number of tunnels that can be created in this slot. -1 = not supported. Default value is -1.
E Database tables and fields TABLE 12 USER_ (Continued) Field Definition Format NOTIFICATION_ENABLED Flag for e-mail notification. Default value is 0. smallint FULL_NAME User''s Full Name. varchar 512 PHONE_NUMBER User''s Phone number. varchar 32 INVALID_LOGIN_COUNT This is a counter filed to identify the number of invalid smallint login attempts. Note: After successful login this filed will be set to NULL. Default value is 0.
E Database tables and fields TABLE 15 CLIENT_VIEW_COLUMN (Continued) Field Definition Format Size ENTITY_CATEGORY Either "fabric" or "product (switch or device)" or "port"; or combination of these 3 basic categories. Default value is 0. varchar 128 COLUMN_INDEX 0 = Predefined column. 1 = First user-defined column. 2 = Second user-defined column. 3 = Third user-defined column. Default value is 0. small int DESCRIPTION Column description, typically populated for user-defined columns.
E Database tables and fields TABLE 17 FABRIC (Continued) Field Definition Format MANAGEMENT_STATE Bit map to indicate various management indications for the fabric. smallint TRACK_CHANGES 1 = changes (member switches, ISL and devices) in the fabric are tracked. smallint STATS_COLLECTION 1 = statistics collection is enabled on the fabric. smallint CREATION_TIME When the fabric record is inserted, i.e., created. timestamp LAST_FABRIC_CHANGED Time when fabric last changed.
E Database tables and fields TABLE 20 COLLECTOR Field Definition Format Size NAME * Name of the collector registered with the collection framework. varchar 256 CLASS_NAME Java class name which serves as the collector. varchar 256 DESCRIPTION Collector description, usually not used. varchar 512 TABLE 21 FABRIC Field Definition Format ID * int SAN_ID Foreign key to SAN table; usually 1 since there is only one SAN.
E Database tables and fields TABLE 22 COLLECTOR_END_TIMESTAMP Field Definition Format Size COLLECTOR_SOURCE * Internal key for switches and fabrics for which collection is undertaken. varchar 256 COLLECTOR_NAME * Collection name, Java class used to collect specific fabric or switch information. varchar 256 TIMESTAMP_ When the last successful collection is done. timestamp LAST_COLLECTED_STATUS Status of the last collection, successful or not. 200 is for successful.
E Database tables and fields TABLE 27 SECURITY_POLICY (Continued) Field Definition Format Size POLICY_TYPE* Type of the Policy. The possible values are IKE or IPSec smallint ENCRYPTION_ALGORITHM Encryption Algorithm for the policy.The following are the possible Encryption: NONE,DES,3DES,AES-128,AES-256,AES-CM-128 or AES-CM-256.
E Database tables and fields TABLE 29 FIRMWARE_FILE_DETAIL (Continued) Field Definition Format Size FIRMWARE_LOCATION Firmware file location in the Management applciation repository. varchar 1024 RELEASE_NOTES_ LOCATION Release notes file location in theManagement applciation repository. varchar 1024 FIRMWARE_REPOSITORY_ TYPE Repository type to identify the FTP server: 0 = internal FTP. 1 = external FTP.
E Database tables and fields TABLE 33 SWITCH_CONFIG (Continued) Field Definition Format Size BACKUP_DATE_TIME The date/time stamp at which the configuration has been uploaded. timestamp CONFIG_DATA The actual switch configuration data. text CEE_CONFIG_DATA Switch configuration data for CEE text KEEP_COPY The column value (1) helps to preserve the configuration even after the expiration of its age.
E Database tables and fields Device TABLE 37 DEVICE_PORT Field Definition ID* Format Size 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 attached. int WWN Device port WWN. char 23 SWITCH_PORT_WWN WWN of the switch port to which this device port is attached. char 23 NUMBER Switch port number to which this device is attached. smallint PORT_ID Device port ID.
E Database tables and fields TABLE 38 FICON_DEVICE_PORT Field Definition Format DEVICE_PORT_ID* Value for the device port to which these FICON properties are applied. int TYPE_NUMBER varchar 16 MODEL_NUMBER Ficon device model number, such as S18. varchar 64 MANUFACTURER Manufacturer of the device, typically IBM. varchar 64 MANUFACTURER_PLANT Plant number where the device is manufactured. varchar 64 SEQUENCE_NUMBER Device sequence number. varchar 32 TAG FICON device property, e.
E Database tables and fields TABLE 39 DEVICE_NODE (Continued) Field Definition Format AG 1 = the device node is actually an AG connected to a switch in the fabric. Default value is 0. smallint PREVIOUS_MISSING_STAT E Default value is 0. smallint TABLE 40 DEVICE_ENCLOSURE_MEMBER Field Definition Format ENCLOSURE_ID* DEVICE_ENCLOSURE table ID. int DEVICE_PORT_WWN* WWN Of Device Port. char DEVICE_PORT_ID Device_Port table ID.
E Database tables and fields TABLE 41 DEVICE_ENCLOSURE (Continued) (Continued) Field Definition Format TRACK_CHANGES Flag to enable/disable tracking. Default value is 0. smallint LAST_UPDATE_TIME Last time at which the host information was updated. timestamp LAST_UPDATE_MODULE Module which updated the host information. smallint TRUSTED Flag to mark the enclosure trusted. Default value is 0. smallint CREATION_TIME Time when enclosure was created. Default is ’now()’.
E Database tables and fields TABLE 42 FABRIC (Continued) Field Definition Format AD_ENVIRONMENT 1 = there are user-defined ADs in this fabric. smallint MANAGED 1 = it is an actively "monitored" fabric; otherwise, it is an "unmonitored" fabric. smallint MANAGEMENT_STATE Bit map to indicate various management indications for the fabric. smallint TRACK_CHANGES 1 = changes (member switches, ISL and devices) in the fabric are tracked.
E Database tables and fields TABLE 47 EE_MONITOR_STATS (Continued) Field Definition Format CREATION_TIME The polling time. timestamp ACTIVE_STATE State of collection 0 = failed 1 = success smallint TX Transmit (TX) value in bytes. double precision RX Receive (RX) value in bytes. double precision CRCERRORS Number of CRC errors.
E Database tables and fields TABLE 50 EE_MONITOR (Continued) Field Definition Format DEST_PORT_ID References the ID in DEVICE_PORT table and this is a target for EE monitor. int NAME Name of the End_End Monitor. varchar ERROR CODE Error code returned from the switch, when enabling End-End monitor is attempted on the switch. int STATUS Status of creating the End-End monitor on the switch. It can be either failed or succeeded.
E Database tables and fields TABLE 55 MESSAGE_RECIPIENT Field Definition Format ID* int DESCRIPTION Description about recipient. varchar 256 IP_ADDRESS IP Address of the recipient. varchar 128 PORT Port number of the recipient. int RECIPIENT_TYPE_ID Recipient Type (Syslog or SNMP). int ENABLED If forwarding to destination is enabled. smallint SOURCE_ADDRESS_ADD ED If source address is added as another varbind in trap. -1 for Syslog i.e RECIPIENT_TYPE_ID: 2. Default value is -1.
E Database tables and fields TABLE 57 SNMP_CREDENTIALS (Continued) Field Definition Format Size WRITE_COMMUNITY_ STRING The SNMP Write-Only Community String is like a password. It is sent along with each SNMP Set-Request and allows (or denies) access to device. The default value is "private". This is applicable if the agent is configured to operate in SNMPv1. varchar 64 USER_NAME A human-readable string representing the name of the user.
E Database tables and fields TABLE 58 SYSLOG_EVENT (Continued) Field Definition Format EVENT_NUMBER Sequence number of the event. int EVENT_COUNT Number of occurrences of the event. int AUDIT Audit file of the syslog message. varchar FIRST_OCCURENCE_ SWITCH_TIME First occurrence switch time. timestamp LAST_OCCURENCE_ SWITCH_TIME Last occurrence switch time. timestamp FIRST_OCCURENCE_ HOST_TIME Last occurrence switch time.
E Database tables and fields TABLE 59 EVENT (Continued) Field Definition Format EVENT_COUNT Number of occurrences of the event.. Default value is 1. int RESOLVED Resolution status of the event. Default value is 0. smallint ACKED_TIME Time at which the event is acknowledged. Timestamp Size FIRST_OCCURRENCE_HOST First occurrence host time; this is set to GMT time. _TIME timestamp 10 EVENT_AUDIT Flag to indicate if the event is audited.
E Database tables and fields TABLE 61 EVENT_NOTIFICATION (Continued) Field Definition Format Size USER_NAME User name for authentication. varchar 256 PASSWORD Password for authentication. varchar 256 NOTIFICATION_INTERVAL Time interval between successive event notifications. int NOTIFICATION_UNIT Time interval Unit: 0 = Seconds 1 = Minutes 2 = Hours Default value is 0. smallint TEST_OPTION Time interval Unit: 0 = Send test to configured e-mail address.
E Database tables and fields TABLE 62 EVENT_RULE (Continued) Field Definition Format SEVERITY_LEVEL Event severity level. Default value is 4. int 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.
E Database tables and fields TABLE 64 SAN (Continued) Field Definition Format STATS_COLLECTION 1 = statistics collection is enabled; otherwise, 0. Default value is 0. smallint CREATION_TIME time at which this record was created. Default value is ’now()’. timestamp LAST_UPDATE_TIME time when this was last updated. Default value is ’now()’. timestamp TABLE 65 FABRIC Field Definition Format ID* Size int SAN_ID Foreign key to SAN table; usually 1 since there is only one SAN.
E Database tables and fields TABLE 65 FABRIC (Continued) Field Definition Format LAST_UPDATE_TIME Time when fabric was last updated. Default value is ’now()’. timestamp ACTIVE_ZONESET_NAME Name of the zone configuration which is effective / active in that fabric. varchar 256 USER_DEFINED_VALUE_1 User-defined custom value. varchar 256 USER_DEFINED_VALUE_2 User-defined custom value. varchar 256 USER_DEFINED_VALUE_3 User-defined custom value.
E Database tables and fields FC Port Stats TABLE 68 FC_PORT_STATS Field Definition Format ID* References the ID in CORE_SWITCH table. int PORT_ID References the ID in SWITCH_PORT table. int TX Transmission (TX) value in bytes. double precision. RX Receive (RX) value in bytes. double precision. TX_UTILIZATION Transmit utilization value in percentage. double precision. RX_UTILIZATION Receive utilization value in percentage. double‘ precision. CREATION_TIME The polling time.
E Database tables and fields TABLE 69 FC_PORT_STATS_30MIN (Continued) Field Definition Format RX double precision. TX_UTILIZATION double precision. RX_UTILIZATION double precision. CREATION_TIME timestamp ACTIVE_STATE smallint LINKFAILURES double precision. TXLINKRESETS double precision. RXLINKRESETS double precision. SYNCLOSSES double precision. SIGNALLOSSES double precision. SEQUENCEERRORS double precision. INVALIDTRANSMISSIONS double precision. CRCERRORS double precision.
E Database tables and fields TABLE 70 FC_PORT_STATS_2HOUR (Continued) Field Definition LINKFAILURES double precision. TXLINKRESETS double precision. RXLINKRESETS double precision. SYNCLOSSES double precision. SIGNALLOSSES double precision. SEQUENCEERRORS double precision. INVALIDTRANSMISSIONS double precision. CRCERRORS double precision.
E Database tables and fields TABLE 71 FC_PORT_STATS_1DAY (Continued) Field Definition Format SIGNALLOSSES double precision. SEQUENCEERRORS double precision. INVALIDTRANSMISSIONS double precision. CRCERRORS double precision.
E Database tables and fields FCIP TABLE 72 FCIP_TUNNEL Field Definition Format ID* int ETHERNET_PORT_ID GigE Port ID on which the tunnel is created. int TUNNEL_ID Tunnel ID for that GigE Port. smallint VLAN_TAG VLAN Tag on the tunnel (if present). int SOURCE_IP Source IP on which the tunnel is created. char 64 DEST_IP Destination IP on the other end of tunnel. char 64 LOCAL_WWN Local port WWN for the tunnel. char 23 REMOTE_WWN_RESTRICT Remote Port WWN for the tunnel.
E Database tables and fields TABLE 75 FCIP_TUNNEL_DETAILS (Continued) Field Definition Format FICON_TIN_TIR_ EMULATION_ENABLED Whether Ficon_Tin_Tir_Emulation is enabled on that tunnel. smallint FICON_DEVICE_LEVEL_ ACK_EMULATION_ENABLED Whether Device_Level_Ack_Emulation is enabled on that tunnel. smallint FICON_TAPE_WRITE_MAX_ PIPE The value for this on the tunnel. int FICON_TAPE_READ_MAX_ PIPE The value for this on the tunnel.
E Database tables and fields TABLE 76 FCIP_TUNNEL_STATS (Continued) Field Definition Format ACTIVE_STATE State of collection: 0 = failed 1 = success smallint RTT_BY_TO Counter of retransmit packet by timeout. double precision RTT_BY_DUP_ACK Counter of retransmit packet by duplicate Ack.
E Database tables and fields TABLE 78 FCIP_TUNNEL_STATS_2HOUR (Continued) Field Definition Format CREATION_TIME timestamp TX double precision RX double precision TX_UTILIZATION double precision RX_UTILIZATION double precision DROPPED_PACKETS double precision COMPRESSION double precision LATENCY double precision LINK_RETRANSMITS double precision ACTIVE_STATE smallint RTT_BY_TO Counter of retransmit packet by timeout.
E Database tables and fields TABLE 79 52 FCIP_TUNNEL_STATS_1DAY (Continued) Field Definition Format TCP_OOO Counter of TCP out of order double precision SLOW_START SlowStart status from stage 1 to 8 double precision Size Brocade Network Advisor Documentation Updates 53-1002363-02
E Database tables and fields GigE Port Stats TABLE 80 FCIP_TUNNEL Field Definition ID* Format Size int TUNNEL_ID Tunnel ID for that GigE Port. smallint VLAN_TAG VLAN Tag on the tunnel (if present). Default value is -1. int SOURCE_IP Source IP on which the tunnel is created. char 64 DEST_IP Destination IP on the other end of tunnel. char 64 LOCAL_WWN Local port WWN for the tunnel. char 23 REMOTE_WWN_RESTRICT Remote Port WWN for the tunnel.
E Database tables and fields TABLE 80 54 FCIP_TUNNEL (Continued) Field Definition Format FICON_TAPE_WRITE_TIMER The Value for FICON_TAPE_WRITE_TIMER on the tunnel. Default value is -1. int FICON_TAPE_MAX_WRITE_ CHAIN The Value for FICON_TAPE_MAX_WRITE_CHAIN on the tunnel. Default value is -1. int FICON_OXID_BASE The Value for FICON_OXID_BASE on the tunnel. Default value is -1. int FICON_XRC_EMULATION_E NABLED Whether Xrc_Emulation is enabled on that tunnel. Default value is 0.
E Database tables and fields TABLE 80 FCIP_TUNNEL (Continued) Field Definition Format TPERF_ENABLED Is Tperf enabled. Default: 0, Values: 0|1. Default value is 0. smallint AUTH_KEY This is the preshared-key to be used during IKE authentication. varchar CONNECTED_COUNT Active connections count. Default value is 1. smallint TUNNEL_STATUS_STRING Tunnel Status string value from switch for the tunnel. varchar COMPRESSION_MODE Compression mode value (0,1,2,3). Default value is 0.
E Database tables and fields TABLE 82 GIGE_PORT_STATS_30MIN (Continued) Field Definition TX double precision RX double precision TX_UTILIZATION double precision RX_UTILIZATION double precision DROPPED_PACKETS double precision COMPRESSION double precision LATENCY double precision BANDWIDTH double precision TABLE 83 Definition Format ID* int SWITCH_ID int PORT_ID int CREATION_TIME timestamp TX double precision RX double precision TX_UTILIZATION double precision RX_UTILIZ
E Database tables and fields TABLE 84 GIGE_PORT_STATS_1DAY (Continued) Field Definition Format LATENCY double precision BANDWIDTH double precision TABLE 87 ISL Field Definition ID* Format Size int FABRIC_ID Fabric DB ID. int SOURCE_DOMAIN_ID Source domain ID. int SOURCE_PORT_NUMBER Source port number. smallint DEST_DOMAIN_ID Destination domain ID. int DEST_PORT_NUMBER Destination port number. smallint COST The cost of the link. int TYPE The type of link.
E Database tables and fields TABLE 88 FABRIC (Continued) Field Definition Format MANAGED 1 = it is an actively "monitored" fabric; otherwise, it is an "unmonitored" fabric. smallint MANAGEMENT_STATE Bit map to indicate various management indications for the fabric. smallint TRACK_CHANGES 1 = changes (member switches, ISL and devices) in the fabric are tracked. smallint STATS_COLLECTION 1 = statistics collection is enabled on the fabric.
E Database tables and fields TABLE 92 LICENSED_FEATURE Field Definition ID* Format Size int NAME License feature name, a short text description. varchar 64 DESCRIPTION Optional detailed description about the license feature. varchar 256 Format Size TABLE 93 SWITCH_LICENSE Field Definition ID* int CORE_SWITCH_ID Refers to the entry in the CORE_SWITCH table. int LICENSE_KEY Stores the license key obtained from the switch.
E Database tables and fields TABLE 94 60 CORE_SWITCH (Continued) Field Definition Format Size LAST_UPDATE_TIME 1 = the Management application server is registered with the switch to receive Syslog. Default is ’now()’. timestamp SYSLOG_REGISTERED 1 = Syslog is enabled for this switch. Default value is 0. smallint CALL_HOME_ENABLED 1 = call home is enabled for this switch. Default value is 1.
E Database tables and fields Encryption Device TABLE 95 KEY VAULT Field Definition ID* Format Size int IP_ADDRESS The IP Address (IPv4, IPv6, or hostname) of the key vault. varchar PORT_NUMBER The TCP port number for the key vault. int PUBLIC_CERTIFICATE The key vault’s public key certificate. Switches use varchar this to establish a secure connection to the key vault. 4096 CRETIFICATE_LABEL A text name to identify the certificate.
E Database tables and fields TABLE 96 CRYPTO_SWITCH (Continued) Field Definition Format Size CP_CERTIFICATE The public key certificate, in PEM format, of the switch’s Control Processor module. This certificate is exchanged with other switches to establish secure communication between switches in an Encryption Group. varchar 4096 KAC_CERTIFICATE The public key certificate, in PEM format, of the switch’s Key Archive Client module.
E Database tables and fields TABLE 97 ENCRYPTION GROUP (Continued) Field Definition Format SYSTEM_CARD_REQUIRED Boolean value that indicates whether a System Card (smart card) must be inserted in the Encryption Engine to enable the engine after power-up. This feature is not yet supported. smallint ACTIVE_MASTER_KEY_STAT US The operational status of the "master key" or "Key Encryption Key (KEK)" used to encrypt Data Encryption Keys in a key vault. Not used for NetApp LKM key vaults.
E Database tables and fields TABLE 98 ENCRYPTION_TAPE_POOL (Continued) Field Definition Format ENCRYPTION_GROUP_ID Foreign key reference to the ENCRYPTION_GROUP record that describes which Encryption Group this tape pool belongs to. int TAPE_POOL_NAME User-supplied name or number for the tape pool. This is the same name or number specified in the tape backup application. Numbers are stored in hex.
E Database tables and fields TABLE 100 ENCRYPTION_GROUP_MEMBER (Continued) Field Definition Format Size MEMBER_WWN The Node WWN of the member switch. char 23 MEMBER_STATUS The reachability status of the member switch as seen by the group leader switch. For possible values see the enum definition in the DTO class. Default value is 0.
E Database tables and fields TABLE 103 SMART CARD Field Definition Format Size GROUP_NAME The name of the Encryption Group used to initialize the card. For recovery set cards, this identifies which group’s master key is backed up on the card. varchar 64 CREATION_TIME The date and time that the card was initialized. For recovery set cards, this is the date and time the master key was written to the card.
E Database tables and fields Encryption Container TABLE 105 CRYPTO HOST Field Definition ID* Format Size int CRYPTO_TARGET_CONTAIN ER_ID Foreign key reference to the int CRYPTO_TARGET_CONTAINER that contains this host. 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.
E Database tables and fields TABLE 107 68 CRYPTO LUN (Continued) Field Definition Format Size SERIAL_NUMBER The LUN serial number, used to identify the physical LUN. varchar 64 ENCRYPTION_STATE Boolean. True (1) if LUN is being encrypted. False (0) if cleartext. smallint STATUS Not currently used but left in for possible future use. Replaced by LUN_STATE. smallint REKEY_INTERVAL The number of days that data encryption keys should be used before automatically generating a new key.
E Database tables and fields TABLE 107 CRYPTO LUN (Continued) Field Definition Format CRYPTO_HOST_ID Foreign key reference to the CRYPTO_HOST that uses this LUN. int LUN_NUMBER The Logical Unit Number of the LUN, as seen by the LUNs host. This may be an integer (0 - 65565) or a WWN-format 8-byte hex number. varchar BLOCK_SIZE 'The LUN's Logical Block Size, in bytes. Only valid for disk LUNs. int TOTAL_BLOCKS The total number of logical blocks in the LUN.
E Database tables and fields TABLE 108 70 ENCRYPTION ENGINE (Continued) Field Definition Format Size SP_CERTIFICATE The public key certificate, in PEM format, for the Security Processor within the Encryption Engine. Used to create link keys for NetApp LKM key vaults. varchar 4096 EE_STATE The operational status of this Encryption Engine. For possible values, see the enum definition in the DTO class.
E Database tables and fields Meta SAN TABLE 111 LSAN_DEVICE Field Definition ID* Format Size int BB_FABRIC_ID Backbone fabric DB ID. int FCR_FABRIC_ID FID assigned to edge fabric. int DEVICE_PORT_WWN Device port WWN of physical device. char 23 PHYSICAL_PID PID of physical device.
E Database tables and fields TABLE 114 FABRIC (Continued) Field Definition Format 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 MANAGED 1 = it is an actively "monitored" fabric; otherwise, it is an "unmonitored" fabric. smallint MANAGEMENT_STATE Bit map to indicate various management indications for the fabric.
E Database tables and fields Network TABLE 117 IP_INTERFACE Field Definition ID* Format Size int ETHERNET_PORT_ID GigE Port ID. int IP_ADDRESS IP address on the Ip_interface. varchar 64 NET_MASK Subnet mask for the interface. varchar 64 MTU_SIZE MTU Size for that interface. int CHECKSUM Check Sum. varchar 64 Definition Format Size TABLE 118 IP_ROUTE Field ID* int ETHERNET_PORT_ID GigE Port ID. int PORT_NUMBER Port Number related to the GigE Port.
E Database tables and fields TABLE 121 OUI_GUESSED_DEVICE_MAP Field Definition Format Size OUI* Vendor OUI. char 6 TYPE Guessed device type for this vendor. varchar 32 Field Definition Format Size FEATURE_ID* ID used to uniquely identify the feature. int 6 NAME Name of the feature. varchar 256 DESCRIPTION Description for the feature.
E Database tables and fields TABLE 125 PORT_FENCING_POLICY_MAP Field Definition ID* Format Size int POLICY_ID Foreign key to ID column of PORT_FENCING_POLICY table. int LEVEL 0 = All Fabric 1 = Fabric 2 = Core Switch Group 3 = Switch 4 = Port Type 5 = Port List smallint SUB_LEVEL 1 = E_Port 2 = F_Port 3 = FL_Port, Fabric WWN, Switch WWN char 23 NODE WWN of Node which policy assigned. char 23 INHERITANCE Directly assigned or inherited from root level.
E Database tables and fields TABLE 127 QRTZ_TRIGGERS (Continued) Field Definition Format Size JOB_GROUP Name of the job group. varchar 80 IS_VOLATILE Whether the trigger should be persisted in the JobStore for re-use after program restarts. boolean DESCRIPTION A description for the trigger instance - may be useful for remembering/displaying the purpose of the trigger, though the description has no meaning to Quartz. varchar 120 NEXT_FIRE_TIME The next fire time in milliseconds.
E Database tables and fields TABLE 129 QRTZ_FIRED_TRIGGERS (Continued) Field Definition Format IS_STATEFUL Whether the job implements the interface StatefulJob. boolean REQUESTS_RECOVERY True or false. boolean TABLE 130 size QRTZ_JOB_LISTENERS Field Definition Format Size JOB_NAME* Name of the job. varchar 80 JOB_GROUP* Name of the job group. varchar 80 JOB_LISTENER* Job listener action class instance.
E Database tables and fields TABLE 135 QRTZ_LOCKS Field Definition Format Size LOCK_NAME* Resource identification name assigned by user. varchar 40 TABLE 136 QRTZ_CALENDARS Field Definition Format Size CALENDAR_NAME* Name of the Calendar. varchar 80 CALENDAR Calendar object. bytea TABLE 137 QRTZ_PAUSED_TRIGGER_GRPS Field Definition Format Size TRIGGER_GROUP* Name of the trigger group. varchar 80 Field Definition Format Size ID* Meta Data for available reports.
E Database tables and fields TABLE 141 ROLE Field Definition ID* Format Size int NAME Role name. varchar 128 DESCRIPTION Role description. varchar 512 HIDDEN Field to identify whether the role is Hidden from users or not. Values: 0= Not Hidden 1= Hidden Currently, only ''All Users'' Role is hidden and other roles are visible to user. Default value is 0. smallint TABLE 142 ROLE_PRIVILEGE_MAP Field Definition Format ROLE_ID* User role ID. int PRIVILEGE_ID* Privilege ID.
E Database tables and fields TABLE 147 USER_ Field Definition Format ID * int NAME User name. varchar 128 DESCRIPTION User description. varchar 512 PASSWORD User password. varchar 512 EMAIL User e-mail ID. varchar 1024 NOTIFICATION_ENABLED Flag for e-mail notification. Default value is 0. smallint FULL_NAME User''s Full Name. varchar 512 PHONE_NUMBER User''s Phone number.
E Database tables and fields TABLE 150 RESOURCE_FABRIC_MAP Field Definition Format RESOURCE_GROUP_ID* Resource group ID. int FABRIC_ID* Fabric ID, which is in the resource group.
E Database tables and fields SNMP TABLE 152 SNMP_CREDENTIALS Field Definition Format ID* 82 Size int VIRTUAL SWITCH_ID Virtual switch ID for which this instance of the SNMP credentials apply. int RECIPIENT_ID Recipient in the MESSAGE_RECIPIENT table. int POR)_NUMBER Port number of the SNMP agent on the switch for get and set requests. smallint RETRY_COUNT Number of times to retry if get/set request to the SNMP agent times out. Default value is 3.
E Database tables and fields TABLE 152 SNMP_CREDENTIALS (Continued) Field Definition Format Size PRIV_PROTOCOL An indication of whether messages sent or received on behalf of this user can be encrypted and if so, which privacy protocol to use. The current values for this field are: usmNoPrivProtocol and usmDESPrivProtocol. This is applicable if the agent is configured to operate in SNMPv3.
E Database tables and fields TABLE 153 SNMP_PROFILE (Continued) Field Definition Format Size AUTH_PROTOCOL An indication of whether or not messages sent or received on behalf of this user can be authenticated and if so, which authentication protocol to use. The supported values for this field are: usmNoAuthProtocol, usmHMACMD5AuthProtocol, and usmHMACSHAAuthProtocol. This is applicable if the agent is configured to operate in SNMPv3.
E Database tables and fields Stats TABLE 155 FAVORITES Field Definition ID* Format Size int NAME Name of the favorite. varchar 64 USER_ The application user credentials. varchar 128 TOP_N The top number of ports(5,10,15,20). varchar 40 SELECTION_FILTER Types of ports (FC/FCIP/GE) and -End Monitors. varchar 40 FROM_TIME The time interval in which the graph is shown. Time interval can be predefined or custom.
E Database tables and fields TABLE 156 USER_ (Continued) Field Definition Format LOCKED_OUT_DATETIME The date time stamp when a user got locked out because of exceeding max number of invalid login attempts. timestamp STATUS User''s account status: 0=Disabled 1=Enabled Default value is 1. smallint SOURCE_OF_CREATION To identify the source for creating the user account. 0= User created through Management applciation Client 1= User created when authenticated through external server.
E Database tables and fields TABLE 159 DEFAULT_FAVORITES (Continued) Field Definition Format Size TOP_N Types of ports (FC/FCIP/GE) and -End Monitors. varchar 40 SELECTION_FILTER The time interval in which the graph is shown. varchar 40 FROM_TIME Always null. The default favorite is not customized. varchar 40 CUSTOM_LAST_VALUE Always null. The default favorite is not customized. int CUSTOM_TIME_UNIT Always null. The default favorite is not customized.
E Database tables and fields Switch TABLE 160 VIRTUAL-SWITCH Field Definition Format ID* 88 Size int LOGICAL_ID Logical ID of the switch. smallint NAME Switch name. varchar 64 WWN WWN of the switch. char 23 VIRTUAL_FABRIC_ID Virtual fabric ID. If VF enabled then will have the VFID; otherwise it will be -1. smallint DOMAIN_ID Domain ID of the switch. smallint BASE_SWITCH 1 = this is a base switch; otherwise, 0. smallint SWITCH_MODE 2 = switch is in AG mode; otherwise, 0.
E Database tables and fields TABLE 161 CORE_SWITCH Field Definition ID* Format Size int IP_ADDRESS IP address of the switch. varchar 128 WWN Chassis WWN. char 23 NAME Switch name. varchar 64 TYPE SWBD type number as given by Fabric OS. Default value is 0. smallint MODEL Model type of the switch: 0 = Unknown 1 = Not applicable 2 = Fabric OS switch 3 = M-EOS switch smallint FIRMWARE_VERSION Embedded (Fabric OS or M-EOS) software version. varchar 128 VENDOR Switch vendor.
E Database tables and fields TABLE 161 CORE_SWITCH (Continued) Field Definition Format NIC_PROFILE_ID NIC profile of the Management application server host used by this switch to communicate in interactive configuration and other operations. It determines which Management application host IP used by this switch. int MANAGING_SERVER_IP_ ADDRESS IP address(v4/v6) of the Management applciation server which is currently managing the M-model switch. Used for M-EOS switch only.
E Database tables and fields TABLE 164 SWITCH_MODEL (Continued) Field Definition Format Size DESCRIPTION Model description, such as FC link speed, port count and whether multi-card (director) class switch or other type of switch. Default is ‘Not Available’. varchar 256 MODEL Switch model string. varchar 32 REMARK Remarks, such as an internal project name. varchar 64 TABLE 165 PURGED_SWITCH Field Definition Format Size WWN* WWN of the switch. char 23 NAME Name of the switch.
E Database tables and fields TABLE 166 92 CORE_SWITCH_DETAILS (Continued) Field Definition Format Size FC_MASK Subnet mask for FC IP. char 64 FC_IP Fibre Channel IP address. char 64 FC_CERTIFICATE smallint SW_LICENSE_ID char 23 SUPPLIER_SERIAL_ NUMBER Serial number of the chassis. varchar 32 PART_NUMBER The part number assigned by the organization responsible for producing or manufacturing the PhysicalElement. varchar 32 CHECK_BEACON 1 = beacon is turned on; otherwise, 0.
E Database tables and fields TABLE 166 CORE_SWITCH_DETAILS (Continued) Field Definition Format Size MAX_NUM_OF_BLADES Required by SMIA to populate Brocade_Chassis.MaxNumOfBlades property. It indicates the max no of blades that can be present in a chassis. smallint VENDOR_VERSION Required by integrated SMI agent to populate Brocade_Product.Version property. varchar 32 VENDOR_PART_NUMBER Required by integrated SMI agent to populate Brocade_Product.SKUNumber property.
E Database tables and fields TABLE 167 94 CORE_SWITCH (Continued) Field Definition Format Size CREATION_TIME Time when this record was created by the Management application. Default is ’now()’. timestamp LAST_SCAN_TIME Time when this record was last updated. timestamp LAST_UPDATE_TIME 1 = the Management application server is registered with the switch to receive Syslog. Default is ’now()’. timestamp SYSLOG_REGISTERED 1 = Syslog is enabled for this switch. Default value is 0.
E Database tables and fields Switch port TABLE 169 GIGE_PORT Field Definition ID* Format Size int SWITCH_PORT_ID ID for the GigE Port in SWITCH_PORT. int PORT_NUMBER GigE Port Number(0 for ge0 and 1 for ge1). int SLOT_NUMBER Slot number on which the GigE Port is present. int ENABLED Enabled or disabled. Default value is 0. smallint SPEED Port speed details. Default value is 0. bigint MAX_SPEED Port maximum speed supported. bigint MAC_ADDRESS MAC Address of that port.
E Database tables and fields TABLE 170 SWITCH_PORT (Continued) Field Definition Format PORT_NUMBER The logical port number of the user port. There is no assumption of any relation to the physical location of a port within a chassis. smallint USER_PORT_NUMBER User port number. Unique port number in a chassis. smallint PORT_ID Port ID of this port. varchar PORT_INDEX Number used for identifying port in zoning. smallint AREA_ID Area number the port is assigned to.
E Database tables and fields TABLE 170 SWITCH_PORT (Continued) Field Definition Format PERSISTENT_DISABLE 1 = port is persistently disabled. smallint FICON_SUPPORTED 1 = FICON is supported; otherwise, 0. smallint BLOCKED 1 = port is blocked; otherwise, 0. smallint PROHIBIT_PORT_NUMBERS varchar PROHIBIT_PORT_COUNT smallint NPIV Whether NPIV mode is enabled.
E Database tables and fields TABLE 170 SWITCH_PORT (Continued) Field Definition Format LOGICAL_PORT_NUMBER F-Port trunk logical port number. Default value is -1. smallint DEFAULT_AREA_ID Default Area id of F-Port trunk port. Default value is -1. smallint LOGICAL_PORT_WWN Logical port WWN of F-Port trunk group. char 23 PREVIOUS_TYPE This fields copies the old state of the port type. The field could be used to track the state change information for the switch port type.
E Database tables and fields TABLE 174 FPORT_TRUNK_GROUP (Continued) Field Definition Format MASTER_USER_PORT User port number for the master port of this trunk. smallint WWN WWN of the trunk group. char TRUNK_AREA User-assigned area number used to group together F_ports of the trunk. smallint TABLE 175 Size 23 FPORT_TRUNK_MEMBER Field Definition Format GROUP_ID* Foreign key to the PORT_TRUNK_GROUP table. int PORT_NUMBER* Member user port number. smallint WWN Member port WWN.
E Database tables and fields TABLE 176 VIRTUAL_SWITCH (Continued) Field Definition Format Size USER_DEFINED_VALUE_2 varchar 256 USER_DEFINED_VALUE_3 varchar 256 CORE_SWITCH_ID Core switch DB ID. int INTEROP_MODE Mode in which this switch is operating.
E Database tables and fields TABLE 181 VIRTUAL_SWITCH Field Definition Format Size ID* int LOGICAL_ID smallint NAME varchar 64 WWN char 23 VIRTUAL_FABRIC_ID Default value is 0. DOMAIN_ID smallint smallint BASE_SWITCH Default value is 0. smallint SWITCH_MODE Default value is 0. smallint ROLE varchar 32 FCS_ROLE varchar 16 AD_CAPABLE Default value is 0. smallint FABRIC_IDID_MODE smallint OPERATIONAL_STATUS varchar MAX_ZONE_CONFIG_SIZE Defaultis 0.
E Database tables and fields TABLE 181 VIRTUAL_SWITCH (Continued) Field Definition Format DEFAULT_LOGICAL_SWITCH Check to see whether virtual switch is a default logical switch or not. 1 is true and 0 is false. Default value is 0. smallint FEATURES_SUPPORTED Contains the features supported as a bit mask. Default value is 0. int FMS_MODE Default value is 0. smallint DYNAMIC_LOAD_SHARING Default value is 0. smallint PORT_BASED_ROUTING Default value is 0.
E Database tables and fields TABLE 181 VIRTUAL_SWITCH (Continued) Field Definition Format Size PREVIOUS_STATE This fields copies the old state of the switch . The field could be used to track the state change information for the switch.These values to be populated by FCS during Fabric Refresh task.SMIA requested this information but could be used by any module which needs to track the state change varchar 32 MANAGED_ELEMENT_ID A unique managed element ID for this virtual switch.
E Database tables and fields TABLE 184 AVAILABLE_FLYOVER_PROPERTY (Continued) Field Definition Format TYPE The flyover property type: 0 = Product property 1 = Connection property smallint DEFAULT_SELECTION AVAILABLE_FLYOVER_PROPERTY DEFAULT_SELECTION 1 = default selected product/connection property 0 = not included in the default list. smallint TABLE 185 SELECTED_FLYOVER_PROPERTY Field Definition Format PROPERTY_ID* Refers to Flyover_Property ID from AVAILABLE_FLYOVER_PROPERTY table.
E Database tables and fields TABLE 188 PRODUCT_APP (Continued) Field Definition Format Size PROP2_KEY Second condition name to be satisfied by a selected product to launch a particular tool. varchar 256 PROP2_VALUE Second condition value to be satisfied by a selected product to launch a particular tool. varchar 256 TOOL_ID The tool to be used for launching the application. int PARAMETERS Link to that application. varchar IP_SELECTED Selected IP Address option.
E Database tables and fields TABLE 191 LSAN_ZONE (Continued) Field Definition Format EDGE_FABRIC_ID FID assigned to edge fabric. int NAME LSAN zone name. varchar BACKBONE 0= is not a backbone lsan zone, 1= is a backbone lsan zone. Default value is 0. smallint TABLE 192 Size 128 LSAN_ZONE_MEMBER Field Definition Format LSAN_ZONE_ID* LSAN_ZONE record reference. int MEMBER_PORT_WWN* Zone member WWN.
E Database tables and fields TABLE 196 ZONE_ALIAS_MEMBER Field Definition ID* Format int TYPE Zone alias member type: 2 = WWN 4 = D,P smallint VALUE Member value (D,P or WWN). varchar ZONE_ALIAS_ID PK of the owning zone alias. int TABLE 197 Definition Format ZONE_SET_ID* PK of the owning zone set. INT ZONE_ID* PK of the owning zone. INT Definition Format Size ZONE Field ID* Size int ZONE_DB_ID PK the owning ZONE_DB. int NAME The zone name. varchar TYPE The zone type.
E Database tables and fields TABLE 199 ZONE_DB (Continued) Field Definition Format DEFAULT_ZONE_STATUS All access or no access when no active zone configuration. smallint ZONE_TXN_SUPPORTED Zoning commands support transaction. smallint MCDATA_DEFAULT_ZONE McData switch default zoning mode. smallint MCDATA_SAFE_ZONE McData switch safe zoning mode. smallint ZONE_CONFIG_SIZE Zone configuration string length. int ZONE_AVAILABLE_SIZE Available zone DB size in the switch.
E Database tables and fields TABLE 204 AD_GROUP_ROLE_MAP Field Definition Format AD_GROUP_ID Active directory group ID int ROLE_ID TABLE 205 Size int AOR Field Definition Format Size ID* int NAME varchar 128 DESCRIPTION varchar 512 TABLE 206 AOR_DEVICE_GROUP_MAP Field Definition Format AOR_ID ID of the AOR. int DEVICE_GROUP_ID The Product Group which is in the AOR.
E Database tables and fields TABLE 211 AUTO_TRACE_DUMP Field Definition Format CORE_SWITCH_ID int ENABLED The enabled/disabled state of automatic trace dump transfer on the switch smallint PROTOCOL The protocol Unknown(0)/FTP(1)/SCP(2) to be used for transfer smallint IP_ADDRESS The Host IP Address varchar 64 USER_NAM The user name varchar 64 LOCATION Directory location where trace dump files are to be saved varchar 1024 PASSWORD The user password varchar 64 Format Size TABL
E Database tables and fields TABLE 214 BOOT_LUN_SEQUENCE Field Definition ID Format int NAME Name of the Boot LUN Sequence varchar FABRIC_ID PK of the owning fabric INT TABLE 215 64 BOOT_LUN_SEQUENCE_DETAIL Field Definition ID * Format Size int BOOT_LUN_SEQ_ID PK of the owning Boot LUN Sequence char PORT_WWN WWN of the port in the Boot LUN Sequenc int LUN_NUM LUN number of the port in the Boot LUN Sequence int SEQUENCE_NUM Sequence number of the port in the Boot LUN Sequence
E Database tables and fields TABLE 216 CEE_PORT (Continued) Field Definition Format Size QOS_NAME Name of the QoS Map set on the port varchar 64 DOT1X_ENABLED Indicate if 802.1x authentication is enabled on this port. The default value is 0. smallint TABLE 217 CLIENT_VIEW_MEMBER_HOST Field Definition Format CLIENT_VIEW_ID Primary key of CLIENT_VIEW table int HOST_ID Primary key of DEVICE_ENCLOSURE table int Field Definition Format ID * Arbitrary integer to identify the cluster.
E Database tables and fields TABLE 221 CNA_PORT Field Definition Format ID Primary key autogenerated ID int PORT_NUMBER Port number of the CNA port int PORT_WWN Port WWN of the port char 23 NODE_WWN Node WWN of the port char 23 PHYSICAL_PORT_TYPE Port type CNA/FC varchar 32 NAME Name of the port varchar 256 MAC_ADDRESS MAC address of the port. varchar 64 MEDIA Media of the port varchar 64 CEE_STATE State of the port. varchar 64 HBA_ID ID of the port.
E Database tables and fields TABLE 223 COLLECTOR_END_TIMESTAMP (Continued) Field Definition Format 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 224 CRYPTO_HOST Field Definition Format ID Size int CRYPTO_TARGET_CONTAINE R_ID Foreign key reference to the CRYPTO_TARGET_CONTAINER that contains this host.
E Database tables and fields TABLE 225 CRYPTO_LUN (Continued) Field Definition Format LAST_REKEY_PROGRESS Indicates whether a re-key operation is in progress. 0 = no re-keying in progress. > 0 = percentage done of re-keying operation in progress. Only valid for disk LUNs. The default value is 0. smallint If a tape session is in progress, this is the volume label for the currently mounted tape. Only valid for tape LUNs. varchar PRIOR_ENCRYPTION_STAT E Not used.
E Database tables and fields TABLE 225 CRYPTO_LUN (Continued) Field Definition Format LUN_FLAGS Bitmap of LUN options. The only option currently used is bit 0 (least significant) which indicates that the LUN must be manually enabled because it has been disabled due to inconsistent metadata detected. The default value is 0. bigint ENCRYPTION_ALGORITHM Stores the Encryption Algorithm used to encrypt/decrypt data on the LUN varchar KEY_ID_STATE State of the Key ID retrieval from Key Vault.
E Database tables and fields TABLE 226 CRYPTO_TARGET_CONTAINER (Continued) Field Definition Format FAILOVER_STATUS Indicates whether this container''s target is being encrypted by the encryption engine on which the container is configured (value 0) or by another encryption engine in the HA Cluster (value 1). Default value is 0.. smallint FAILOVER_STATUS_2 Failover status from the HA Cluster peer.
E Database tables and fields TABLE 229 ENCRYPTION_ENGINE Field Definition Format ID 118 Size int SWITCH_ID Foreign key reference to both the VIRTUAL_SWITCH table and the CRYPTO_SWITCH table (both switch tables use the same primary key values). Identifies the switch that contains this encryption engine. int SLOT_NUMBER For chassis switches, the slot or blade that contains the encryption engine. Always 0 for pizza-box switches with a single embedded encryption engine.
E Database tables and fields TABLE 229 ENCRYPTION_ENGINE (Continued) Field Definition Format LINK_MTU Local EE Link MTU. The default value is -1. int LINK_STATE Local EE State says whether link is down or up varchar REBALANCE_REQUIRED This field indicates whether a rebalance operation is required on the Encryption Engine. It can take two values, One(1) indicating that rebalance is required on the Encryption Engine and zero(0) indicating that no rebalance is required on the Encryption Engine.
E Database tables and fields TABLE 230 ENCRYPTION_GROUP (Continued) Field Definition Format Boolean value that indicates whether a System Card (smart card) must be inserted in the Encryption Engine to enable the engine after power-up. This feature is not yet supported. The default value is 0. smallint ACTIVE_MASTER_KEY_ STATUS The operational status of the "master key" or "Key Encryption Key (KEK)" used to encrypt Data Encryption Keys in a key vault. Not used for Decru LKM key vaults.
E Database tables and fields TABLE 231 ETHERNET_CLOUD Field Definition ID The unique id of the switch this cloud is associated to. int ETHERNET_ISL Field Definition ID Format Size int SOURCE_PORT_ID The unique id of the source port. int DEST_PORT_ID The unique id of the destination port.
E Database tables and fields TABLE 234 EVENT_CATEGORY Field Definition Format ID 0 - Unknown 1 - Product Event 2 - Link Incident Event 3 - Product Audit Event 4 - Product Status Event 5 - Security Event 6 - User Action Event 7 - Management Server Event int DESCRIPTION TABLE 235 varchar 50 Format Size EVENT_DESCRIPTION Field Definition ID int DESCRIPTION varchar 1024 Format Size TABLE 236 EVENT_DETAILS Field Definition ID int EVENT_ID int FIRST_OCCURRENCE_SWI TCH_TIME times
E Database tables and fields TABLE 237 EVENT_FWD_FILTER Field Definition ID Format int NAME Filter Name DESCRIPTION varchar 32 varchar 256 TYPE Filter Type (SNMP/ SYSLOG) smallint APPLICATION_ENABLED If Application Events enabled smallint SNORT_ENABLED If Snort Messages enabled smallint PSUDO_ENABLED If Pseudo Events enabled smallint REGULAR_EXP Common filtering message for Syslog Forwarding varchar SEVERITY Emergency(0), Alert(1), Critical(2), Error(3), Warning(4), Notice(5),
E Database tables and fields TABLE 242 EVENT_INSTANCE Field Definition Format ID int EVENT_POLICY_ID Foreign Key to Event_Policy Table int EVENT_KEY A String Key string which identifies a specific instance of an Event. varchar 64 STRING_PATTERN A Regular expression pattern string which can be used to match an Event instance. varchar 1024 CATEGORY A small integer which identifies the Category of an Event instance.
E Database tables and fields TABLE 245 EVENT_POLICY Field Definition ID Format Size int TYPE Even Policy Type 0 - Pseudo Event 1 - Event Action smallint NAME The Name of the Event Policy varchar 256 DESCRIPTION The Description of the Event Policy varchar 1024 STATUS Administrative status of the Event Policy 0 - disabled 1- enabled smallint LAST_MODIFIED_TIME The Severity of the Event that is logged per Event Policy 0- Unknown 1- Emergency 2- Alert 3- Critical 4- Error 5- Warning 6-
E Database tables and fields TABLE 246 EVENT_POLICY_SOURCE_ENTRY (Continued) Field Definition Format SOURCE_SELECTION_TYPE Option selected to give Source Information 0- IPAddress/Node wwn/Name provided 1- Source selected from available list of sources. The default value is 0.
Database tables and fields TABLE 250 E FCIP_TUNNEL_CIRCUIT (Continued) Field Definition Format TAPE_ACCELERATION_ENABLED Whether TapeAccelaration is enabled on that circuit smallint IKE_POLICY_NUM The IKE Policy on the int circuit.The default value is -1. IPSEC_POLICY_NUM The IPSEC Policy on the circuit'.
E Database tables and fields TABLE 250 128 FCIP_TUNNEL_CIRCUIT (Continued) Field Definition Format Size MAX_RETRANSMISSIONS Max number of Retransmission attempts on the circuit. The default value is 0. int SLOT_NUMBER Slot number of the circuit. The default value is 0. smallint VE_PORT_NUMBER VE port number of the tunnel to which the circuit belongs. int SECURITY_FLAG Security Flag associated with the circuit. The default value is 0.
Database tables and fields TABLE 251 E FCIP_TUNNEL_PERFORMANCE Field Definition Format TUNNEL_ID Primary key of the Switch Port int SWITCH_ID The number of octets or bytes that have been transmitted by this port. One second periodic polling of the port. This value is saved and compared with the next polled value to compute net throughput. Note, for Fibre Channel, ordered sets are not included in the count int TX 'The number of octets or bytes that have been transmitted by this port.
E Database tables and fields TABLE 251 FCIP_TUNNEL_PERFORMANCE (Continued) Field Definition Format RTT_BY_TIME_OUT Counter of retransmit packets due to timeout double precision RTT_BY_DUP_ACK Counter of retransmit packets due to duplicate acknowledgement' double precision DUPLICATE_ACK Counter of duplicate acknowledgement packets double precision ROUND_TRIP_TIME Round trip time in milliseconds double precision TCP_OUT_OF_ORDER Counter of TCP out-of-order.
E Database tables and fields TABLE 253 FRU (Continued) Field Definition Format Size VENDOR_PART_ NUMBER provides the Vendor-assigned part number of this package, requested by SMIA and values filled in by Switch Asset Collector varchar 64 VENDOR_SERIAL_ NUMBER provides the Vendor-assigned serial number of this package, requested by SMIA and values filled in by Switch Asset Collector' varchar 64 CAN_BE_FRUED provides whether this element can be removed from the switch, requested by SMIA and v
E Database tables and fields TABLE 253 FRU (Continued) Field Definition Format PREVIOUS_OP_STATUS provides the previous operational status of FRU element, requested by SMIA and values filled in by Switch Asset Collector. Helps identify the operational status transitions. The default value is -1.
Database tables and fields TABLE 255 E HBA (Continued) Field Definition Format MANAGEMENT_INTERFACE Management interface bit mask, JSON/WMI/SMI etc . The default value is -1.
E Database tables and fields TABLE 255 HBA (Continued) Field Definition Format Size VPD_PW PW details of the device varchar 32 VPD_EDC EDC details of the device varchar 32 VPD_MDC MDC details of the device varchar 32 VPD_FABRIC_GEOGRAPHY FABRIC_GEOGRAPHY of the device varchar 256 VPD_LOCATION LOCATION of the device varchar 256 VPD_MANUFACTURER_ID MANUFACTURER_ID of the device varchar 256 VPD_PCI_GEOGRAPHY PCI_GEOGRAPHY of the device varchar 256 VPD_VENDOR_DATA VENDOR_DAT
E Database tables and fields TABLE 257 HOST_DISCOVERY_REQUEST (Continued) Field Definition Format The status of HBA Discovery using CIM, indicating success or failure. The default value is 0. int CIM_MANAGEMENT_STA TE Reflects the status of the request E.g. 0-> Completed, 1->Add Pending 2->Delete Pending 3->Edit Pending 4->Delete Failed. The default value is 1.
E Database tables and fields TABLE 260 LAG (Continued) Field Definition Format LAG_MODE Static or dynamic (1=dynamic, 2=static) smallint ACTIVE LACP active or passive (1=active, 2=passive) valid if mode=dynamic smallint TYPE Trunking type (1=standard, 2=brocade, 3=hybrid) smallint IF_MODE L2 or L3 mode varchar 8 L2_MODE Type of L2 mode (default=access varchar 32 MAC_ACL_POLICY stores the MAC ACL policy information of the LAG varchar 64 VLAN_LIST Comma separated vlan id list.
E Database tables and fields TABLE 263 LICENSE_RULE (Continued) Field Definition Format DESCRIPTION Description of the rule varchar SCOPE Scope of the rule - is it applicable to Fabric, switch or ports varchar CATEGORY Category of the rule - is it used by unknown - 0, asset collection - 1, or 2 - the license manager service smallint ENABLE Whether the rule needs to be considered or not. 1 consider, 0 - do not consider for calculation. The default value is 1.
E Database tables and fields TABLE 267 PASSWORD_HISTORY Field Definition USER_NAME Size varchar 128 PASSWORD_UPDATED_ DATETIME The date and time the user updated password recently. timestamp PREVIOUS_PASSWORD User''s Previous password varchar 512 Format Size TABLE 268 PHANTOM_PORT Field Definition ID int WWN The Wwn of the phantom port. char VIRTUAL_SWITCH_ID The id of the phantom switch. int PORT_NUMBER The port number of the phantom port. The default value is -1.
E Database tables and fields TABLE 269 PORT_BOTTLENECK_CONFIG (Continued) Field Definition Format WINDOW_ Value of bottleneck detection latency window in millisecond. The default value is 0. int QUIET_TIME Value of bottleneck detection quiet time in millisecond. The default value is 0. int CREATION_TIME Creation time of the record. timestamp LAST_UPDATE_TIME Last update time of the record.
E Database tables and fields TABLE 274 RESOURCE_HOST_MAP Field Definition Format RESOURCE_GROUP_ID Resource Group ID int HOST_ID HOST_ID,which is in the resource group int TABLE 275 SSL_KEY_PASSWORD Field Definition Format ID Size int KEY_PASSWORD_ALIAS Key Password Alias is the alias name used for the encrypted key password. This alias name is used to identify the password in client UI.
E Database tables and fields TABLE 277 IP_DEVICE_LICENSE (Continued) Field Definition Format PRECEDENCE Defines the priority of a particular trial license among those having the same package and License ID. This is primarily used for determining which license to use, when there are many trial and normal licenses with same package name and LID. The value range is (0..65535) int LICENSE_STATE This indicates the state of the license.
E Database tables and fields TABLE 280 ZONE_TRANSACTION Field Definition Format FABRIC_ID The id of the fabric on which the zoning transaction is open. This is the primary key for this table and is a foreign key from the FABRIC table where ZONE_TR.FABRIC_ID == FABRIC.ID int USER_NAME The Management applciation username of the cimclient who has opened the zoning transaction on the fabric.
E Database tables and fields TABLE 285 V_CENTER_HOST Field Definition ID Format Size int HOST The FQDN or the ip address of the host varchar PORT The port of the VCENTER server on the host. The default value is 443 . int USER_NAME The username to login into the VCENTER varchar 64 PASSWORD The password to login into the VCENTER varchar 64 VERSION The version of VCENTER. The default value is 4.0 .
E Database tables and fields TABLE 288 VIRTUAL_FCOE_PORT_STAT Field Definition ID int SWITCH_ID int PORT_ID int TX The number of valid frames sent from the port double precision RX The number of valid frames received at this port double precision TX_UTILIZATION The computed value of TX based on speed of port (for MarchingAnts) double precision RX_UTILIZATION The computed value of RX based on speed of port (for MarchingAnts) double precision CREATION_TIME The time this stats record w
E Database tables and fields TABLE 289 VIRTUAL_FCOE_PORT_STAT_1DAY (Continued) Field Definition Format RX_UTILIZATION double precision CREATION_TIME timestamp ACTIVE_STATE smallint LINK_FAILURES double precision TX_LINK_RESETS double precision RX_LINK_RESETS double precision SYNC_LOSSES double precision SIGNAL_LOSSES double precision SEQUENCE_ERRORS double precision INVALID_TX double precision CRC_ERRORS double precision DATA_GAPS_5MIN smallint DATA_GAPS_30MIN Data gap in 2 h
E Database tables and fields TABLE 290 VIRTUAL_FCOE_PORT_STAT_2HR (Continued) Field Definition CREATION_TIME double precision ACTIVE_STATE timestamp LINK_FAILURES double precision TX_LINK_RESETS double precision RX_LINK_RESETS double precision SYNC_LOSSES double precision SIGNAL_LOSSES double precision SEQUENCE_ERRORS double precision INVALID_TX double precision CRC_ERRORS double precision DATA_GAPS_5MIN smallint DATA_GAPS_30MIN TABLE 291 Data gap in 30 minutes table Size sma
E Database tables and fields TABLE 291 VIRTUAL_FCOE_PORT_STAT_30M (Continued) Field Definition Format TX_LINK_RESETS double precision RX_LINK_RESETS double precision SYNC_LOSSES double precision SIGNAL_LOSSES double precision SEQUENCE_ERRORS double precision INVALID_TX double precision CRC_ERRORS double precision DATA_GAPS_5MIN TABLE 292 Data gap in 5 minutes table Size smallint VIRTUAL_MACHINE Field Definition Format ID Uniquely identifies the virtual machine.
E Database tables and fields TABLE 292 VIRTUAL_MACHINE (Continued) Field Definition Format DATASTORE_NAME The user-assigned name for the VMs datastore. The datastore holds the VMs virtual disks, swap file, and configuration data varchar DATASTORE_LOCATION The location of the VMs datastore May be a SAN target disk or a locally-attached host disk folder. For VMware, this is a target LUN name. varchar NODE_WWN The Node WWN for this VM.
E Database tables and fields TABLE 295 USER_DEFINED_DEVICE_DETAIL (Continued) Field Format Size USER_DEFINED_VALUE1 varchar 256 USER_DEFINED_VALUE2 varchar 256 USER_DEFINED_VALUE3 varchar 256 Size TABLE 296 Definition SWITCH_BOTTLENECK_CONFIG Field Definition Format VIRTUAL_SWITCH_ID The database ID of the switch that the configuration belongs to int 'Flag indicates if bottleneck detection is enabled or not. The default value is 0.
E Database tables and fields TABLE 297 Definition Format RX_UTILIZATION 'The computed value of RX based on speed of port double precision LINK_FAILURE Count of link failures. This count is part of the Link Error Status Block (LESB). (FC-PH 29.8). Note, this is a Fibre Channel only stat double precision TX_LINK_RESETS Count of Link resets. This is the number of LRs received. Note, this is a Fibre Channel only stat double precision RX_LINK_RESETS Count of Link resets.
E Database tables and fields TABLE 298 SWITCH_TE_PORT_PERFORMANCE (Continued) Field Definition Format RX The number of octets or bytes that have been received by this port. One second periodic polling of the port. This value is saved and compared with the next polled value to compute net throughput.
E Database tables and fields TABLE 299 SWITCH_TE_PORT_STATS Field Definition Format ID 152 int SWITCH_ID The primary key of the switch int PORT_ID The primary key of the port int TRANSMIT_OK 'The number of valid frames sent from the port double precision RECEIVE_OK The number of valid frames received at this port.
E Database tables and fields TABLE 300 SWITCH_TE_PORT_STATS_1DAY Field Definition Format ID int SWITCH_ID int PORT_ID int TRANSMIT_OK double precision RECEIVE_OK double precision TRANSMIT_OK_PERCENT_U TIL RECEIVE_OK_PERCENT_UTI L double precision double precision CREATION_TIME timestamp ACTIVE_STATE smallint RECEIVE_EOF double precision UNDERFLOW_ERRORS double precision OVERFLOW_ERRORS double precision CRC_ERRORS double precision ALIGNMENT_ERRORS double precision RUNT_ERRORS
E Database tables and fields TABLE 301 SWITCH_TE_PORT_STATS_2HR Field Definition ID int SWITCH_ID int PORT_ID int TRANSMIT_OK double precision RECEIVE_OK double precision double precision RECEIVE_OK_PERCENT_UTI L CREATION_TIME timestamp ACTIVE_STATE smallint RECEIVE_EOF double precision UNDERFLOW_ERRORS double precision OVERFLOW_ERRORS double precision CRC_ERRORS double precision ALIGNMENT_ERRORS double precision RUNT_ERRORS double precision EXCESS_COLL_ERRORS double precis
E Database tables and fields TABLE 302 SWITCH_TE_PORT_STATS_30MIN (Continued) Field Definition Format PORT_ID int TRANSMIT_OK double precision RECEIVE_OK double precision TRANSMIT_OK_PERCENT_ UTIL double precision RECEIVE_OK_PERCENT_ UTIL double precision CREATION_TIME timestamp ACTIVE_STATE smallint RECEIVE_EOF double precision UNDERFLOW_ERRORS double precision OVERFLOW_ERRORS double precision CRC_ERRORS double precision ALIGNMENT_ERRORS double precision RUNT_ERRORS double p
E Database tables and fields TABLE 304 TOPO_MAP_IMAGE Field Definition Format ID int NAME Image name in the foo.png format varchar IMAGE_OBJECT 'Image Object BLOB bytea Definition Format TABLE 305 256 SMART_CARD Field ID Size int CARD_TYPE Indicates how this smart card is configured: 0 = authorization card. The default value is 0. smallint CARD_INFO Additional smart card details.
E Database tables and fields TABLE 306 SNMP_DATA_1DAY (Continued) Field Definition Format Size VALUE double precision TIME_IN_SECONDS int COLLECTOR_ID int MIB_INDEX char 256 Format Size TABLE 307 SNMP_DATA_2HOUR Field Definition ID int MIB_OBJECT_ID int TARGET_TYPE numeric TARGET_ID int VALUE double precision TIME_IN_SECONDS int COLLECTOR_ID int MIB_INDEX char 256 Size TABLE 308 (2,0) SNMP_DATA_30MIN Field Definition Format ID Primary key autogenerated ID int
E Database tables and fields TABLE 309 SNMP_EXPR_DATA_1DAY (Continued) Field Definition Format TIME_IN_SECONDS int COLLECTOR_ID int TABLE 310 SNMP_EXPR_DATA_2HOUR Field Definition Format ID int EXPRESSION_ID int TARGET_TYPE smallint TARGET_ID int VALUE double precision TIME_IN_SECONDS int COLLECTOR_ID int TABLE 311 Definition Format ID Primary key autogenerated ID int EXPRESSION_ID DB ID of the expression object used for collection int TARGET_TYPE Target/Source type c
E Database tables and fields TABLE 313 SENSOR Field Definition Format ID int CORE_SWITCH_ID int Size SENSOR_ID Identifies the sensor device , requested by SMIA and values filled in by Switch Asset Collector. Maps to Device Id in the html page. The default value is -1. int CURRENT_READING Identifies the current temperature reading sensor, requested by SMIA and values filled in by Switch Asset Collector, Maps to value field in the html page. The default value is -1.
E Database tables and fields TABLE 313 SENSOR (Continued) Field Definition Format UNIT_NUMBER provides the unit number of the sensor, requested by SMIA and values filled in by Switch Asset Collector will be available only from FOS 6.4 switches and above . This the gives the index of the unit. For SLOT FRU, this will be slot number. For FAN fru, this will be fan number. The default value is -1.
E Database tables and fields TABLE 315 HOST_DISCOVERY_OPTION (Continued) Field Definition Format Size CIM_NAMESPACE CIM Namespace. The default value is 'root/brocade varchar 128 CIM_PORT Port number used for the CIM agent. The default value is 5988. int DISCOVER_VM Flag to indicate VM discovery for a host. On/Off'. The default value is 0.
E Database tables and fields TABLE 317 HBA_REMOTE_PORT_LUN (Continued) Field Definition Format BLOCK_SIZE The block size of the logical unit, in bytes (for example, 512 Bytes). The default value is 0. int VENDOR The vendor of the device to which the logical unit is assigned varchar 256 PRODUCT_ID The product identifier of the device to which the logical unit is assigned varchar 256 PRODUCT_VERSION The revision level of the device to which the logical unit is assigned.
E Database tables and fields TABLE 318 HBA_REMOTE_PORT (Continued) Field Definition Format Size QOS_PRIORITY QOS Priority on the target. The default value is 'Unknown'. varchar 64 QOS_FLOW_ID QOS Flow ID on the target. The default value is 0. varchar 64 CURRENT_SPEED Current speed of the remote port, as enforced by TRL. The default value is 0. varchar 64 TRL_ENFORCED The default value is 0. varchar 16 BUS_NO Channel number in the PCI Bus. The default value is 0.
E Database tables and fields TABLE 319 HBA_PORT (Continued) Field Definition Format CONFIGURED_TOPOLOGY The topology setting. The default value is 1. int MAX_SPEED_SUPPORTED The maximum port speed that is supported on the port, in Gb/s. The default value is 0. int OPERATING_STATE Indicates whether the link is online or offline. The default value is 0. smallint OPERATING_TOPOLOGY The topology setting at which the port is operating. The default value is 1.
E Database tables and fields TABLE 320 HBA_PORT_DETAIL (Continued) Field Definition Format BOOT_SPEED The default value is 0. int BOOT_TOPOLOGY The default value is 1. int BB_CREDIT The maximum number of receive buffer. The default value is 8. int FRAME_DATA_FIELD_SIZE The default value is 512. int HARDWARE_PATH Indicates whether MPIO is enabled or disabled V_PORT_COUNT Number of logical ports. The default value is 0.
E Database tables and fields TABLE 320 HBA_PORT_DETAIL (Continued) Field Definition Format FCSP_AUTH_STATE Indicates whether FC-SP authentication is on or off. The default value is 0. smallint FCSP_STATUS The status of FC-SP authentication. The default value is 'Disabled'. varchar 32 FCSP_ALGORITHM The configured authentication algorithm. The default value is 'MD5'. varchar 64 FCSP_GROUP The DH Group (DH Null, group 0 is the only option). The default value is 0.
E Database tables and fields TABLE 321 HBA_PORT_FCOE_DETAILS (Continued) Field Definition Format PORT_LOG_ENABLED The default value is 0. smallint MAX_FRAME_SIZE The default value is 512. int MTU The default value is 0. int PATH_TOV The default value is 0. int SCSI_QUEUE_DEPTH The default value is 0. int Size STATE varchar 64 SUPPORTED_CLASS varchar 256 TRL_SPEED The default value is 0. int TRL_STATE The default value is 0.
E Database tables and fields TABLE 323 Definition Format ID Identifies a server running a supported hypervisor. The ID value is the same as the ID of the corresponding DEVICE_ENCLOSURE record. int NODE_WWN The Node WWN for this host. char 23 HYPERVISOR_NAME Hypervisor name and version, such as VMware ESX Server v3.5.0 varchar 64 HYPERVISOR_TYPE Numeric hypervisor type ID. 1 = VMware, 2 = Hyper-V. The default value is 0. smallint CPU_COUNT Number of CPUs in the server.
E Database tables and fields TABLE 324 VM_LUN (Continued) Field Definition Format PATH_POLICY Determines how multiple paths to this LUN are used. 0 = fixed, 1 = Most Recently Used, 2 = Round Robin. The default value is 0. smallint UUID Universal unique ID varchar 64 Definition Format Size TABLE 325 Size VM_PATH Field ID int HOST_ID Identifies the host containing this path. This is a foreign key reference to VM_HOST.ID int VM_ID Identifies the VM using this path to a LUN.
E Views TABLE 325 VM_PATH (Continued) Field Definition Format Size VM_NODE_WWN The initiator node WWN used by the VM. If NPIV is used, this is a virtual node WWN assigned to the VM. If NPIV is not used, this WWN is the same as the node WWN of one of the HBAs in the host.
Views E CEE_PORT.OCCUPIED, CEE_PORT.LAST_UPDATE, CEE_PORT.NET_MASK, CEE_PORT.PROTOCOL_DOWN_REASON, CEE_PORT.MAC_ACL_POLICY, CEE_PORT.QOS_TYPE, CEE_PORT.QOS_NAME, CEE_PORT.DOT1X_ENABLED, CORE_SWITCH.IP_ADDRESS as PHYSICAL_SWITCH_IP, CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN, GIGE_PORT.OPERATIONAL_STATUS, GIGE_PORT.MAX_SPEED, GIGE_PORT.PORT_TYPE, GIGE_PORT.REMOTE_MAC_ADDRESS, GIGE_PORT.SLOT_NUMBER, VIRTUAL_SWITCH.WWN, SWITCH_PORT.USER_PORT_NUMBER, SWITCH_PORT.
E Views select CNA_PORT.ID, CNA_PORT.PORT_NUMBER, CNA_PORT.PORT_WWN, CNA_PORT.NODE_WWN, CNA_PORT.PHYSICAL_PORT_TYPE, CNA_PORT.NAME, CNA_PORT.MAC_ADDRESS, CNA_PORT.MEDIA, CNA_PORT.CEE_STATE, CNA_PORT.HBA_ID, CNA_PORT.CREATION_TIME as CNA_PORT_CREATION_TIME, CNA_ETH_PORT.ID as ETH_PORT_ID, CNA_ETH_PORT.ETH_DEV, CNA_ETH_PORT.ETH_LOG_LEVEL, CNA_ETH_PORT.NAME as ETH_PORT_NAME, CNA_ETH_PORT.MAC_ADDRESS as ETH_MAC_ADDRESS, CNA_ETH_PORT.IOC_ID, CNA_ETH_PORT.HARDWARE_PATH, CNA_ETH_PORT.STATUS, CNA_ETH_PORT.
Views E CORE_SWITCH_DETAILS.FC_CERTIFICATE, CORE_SWITCH_DETAILS.SW_LICENSE_ID, CORE_SWITCH_DETAILS.SUPPLIER_SERIAL_NUMBER, CORE_SWITCH_DETAILS.PART_NUMBER, CORE_SWITCH_DETAILS.CHECK_BEACON, CORE_SWITCH_DETAILS.TIMEZONE, CORE_SWITCH_DETAILS.MAX_PORT, CORE_SWITCH_DETAILS.CHASSIS_SERVICE_TAG, CORE_SWITCH_DETAILS.BAY_ID, CORE_SWITCH_DETAILS.TYPE_NUMBER, CORE_SWITCH_DETAILS.MODEL_NUMBER, CORE_SWITCH_DETAILS.MANUFACTURER, CORE_SWITCH_DETAILS.PLANT_OF_MANUFACTURER, CORE_SWITCH_DETAILS.
E Views LUN.ENCRYPTION_ALGORITHM, LUN.KEY_ID_STATE, LUN.REKEY_SESSION_NUMBER, LUN.PERCENTAGE_COMPLETE, LUN.REKEY_ROLE, LUN.CURRENT_LBA, LUN.LUN_STATE_STRING, LUN.NEW_LUN, LUN.NEW_LUN_TYPE, CRYPTO_HOST.HOST_PORT_WWN, CRYPTO_HOST.HOST_NODE_WWN from CRYPTO_LUN LUN, CRYPTO_HOST where LUN.CRYPTO_HOST_ID = CRYPTO_HOST.ID; CRYPTO_TARGET_ENGINE_INFO create or replace view CRYPTO_TARGET_ENGINE_INFO as select CRYPTO_TARGET_CONTAINER.ID TARGET_CONTAINER_ID, CRYPTO_TARGET_CONTAINER.NAME, CRYPTO_TARGET_CONTAINER.
Views E CORE_SWITCH.OPERATIONAL_STATUS as PHYSICAL_OPERATIONAL_STATUS, CORE_SWITCH.TYPE, CORE_SWITCH.MAX_VIRTUAL_SWITCHES, CORE_SWITCH.NUM_VIRTUAL_SWITCHES, CORE_SWITCH.FIRMWARE_VERSION, CORE_SWITCH.VENDOR, CORE_SWITCH.REACHABLE, CORE_SWITCH.UNREACHABLE_TIME, CORE_SWITCH.MODEL, CORE_SWITCH.SYSLOG_REGISTERED, CORE_SWITCH.SNMP_REGISTERED, CORE_SWITCH.CALL_HOME_ENABLED, CORE_SWITCH.USER_IP_ADDRESS, CORE_SWITCH.NIC_PROFILE_ID, CORE_SWITCH.MANAGING_SERVER_IP_ADDRESS, CORE_SWITCH.VF_ENABLED, CORE_SWITCH.
E Views VIRTUAL_SWITCH.PREVIOUS_OPERATIONAL_STATUS, VIRTUAL_SWITCH.LAST_SCAN_TIME, VIRTUAL_SWITCH.DOMAIN_MODE_239, VIRTUAL_SWITCH.DOMAIN_ID_OFFSET, VIRTUAL_SWITCH.DISCOVERED_PORT_COUNT, VIRTUAL_SWITCH.FCOE_LOGIN_ENABLED, VIRTUAL_SWITCH.LAST_PORT_MEMBERSHIP_CHANGE, VIRTUAL_SWITCH.FCIP_CIRCUIT_CAPABLE, VIRTUAL_SWITCH.MAX_FCIP_TUNNELS, VIRTUAL_SWITCH.MAX_FCIP_CIRCUITS, VIRTUAL_SWITCH.FCIP_LICENSED, VIRTUAL_SWITCH.ADDRESSING_MODE, VIRTUAL_SWITCH.PREVIOUS_STATE, VIRTUAL_SWITCH.
Views E SWITCH_PORT.ID as SWITCH_PORT_ID, SWITCH_PORT.WWN as SWITCH_PORT_WWN, SWITCH_PORT.NAME as SWITCH_PORT_NAME, SWITCH_PORT.SLOT_NUMBER, SWITCH_PORT.PORT_NUMBER, SWITCH_PORT.PORT_INDEX, SWITCH_PORT.TYPE as SWITCH_PORT_TYPE, SWITCH_PORT.FULL_TYPE as SWITCH_PORT_FULL_TYPE, SWITCH_PORT.STATUS as SWITCH_PORT_STATUS, SWITCH_PORT.HEALTH as SWITCH_PORT_HEALTH, SWITCH_PORT.SPEED, SWITCH_PORT.MAX_PORT_SPEED, SWITCH_PORT.NPIV, SWITCH_PORT.NPIV_CAPABLE, SWITCH_PORT.CALCULATED_STATUS, SWITCH_PORT.
E Views N2F_PORT_MAP, SWITCH_PORT AG_N_PORT, SWITCH_PORT AG_F_PORT where N2F_PORT_MAP.VIRTUAL_SWITCH_ID = AG_N_PORT.VIRTUAL_SWITCH_ID and N2F_PORT_MAP.N_PORT = AG_N_PORT.USER_PORT_NUMBER and N2F_PORT_MAP.VIRTUAL_SWITCH_ID = AG_F_PORT.VIRTUAL_SWITCH_ID and N2F_PORT_MAP.F_PORT = AG_F_PORT.USER_PORT_NUMBER; DEVICE_NODE_INFO create or replace view DEVICE_NODE_INFO as select DEVICE_NODE.ID, DEVICE_NODE.FABRIC_ID, DEVICE_NODE.WWN, DEVICE_NODE.TYPE, DEVICE_NODE.DEVICE_TYPE, DEVICE_NODE.
Views E DEVICE_PORT.SYMBOLIC_NAME, DEVICE_PORT.FC4_TYPE, DEVICE_PORT.COS, DEVICE_PORT.IP_PORT, DEVICE_PORT.HARDWARE_ADDRESS, DEVICE_PORT.TRUSTED, DEVICE_PORT.CREATION_TIME, DEVICE_PORT.MISSING, DEVICE_PORT.MISSING_TIME, DEVICE_PORT.NPV_PHYSICAL, DEVICE_PORT.EDGE_SWITCH_PORT_WWN, FICON_DEVICE_PORT.TYPE_NUMBER, FICON_DEVICE_PORT.MODEL_NUMBER, FICON_DEVICE_PORT.MANUFACTURER, FICON_DEVICE_PORT.MANUFACTURER_PLANT, FICON_DEVICE_PORT.SEQUENCE_NUMBER, FICON_DEVICE_PORT.TAG, FICON_DEVICE_PORT.
E Views DEV_PORT_GIGE_PORT_LINK_INFO create or replace view DEV_PORT_GIGE_PORT_LINK_INFO as select DEVICE_PORT_GIGE_PORT_LINK.DEVICE_PORT_ID, DEVICE_PORT_GIGE_PORT_LINK.GIGE_PORT_ID, DEVICE_PORT_GIGE_PORT_LINK.DIRECT_ATTACH, DEVICE_PORT.TRUSTED, DEVICE_PORT.CREATION_TIME, DEVICE_PORT.MISSING, DEVICE_PORT.MISSING_TIME from DEVICE_PORT_GIGE_PORT_LINK, DEVICE_PORT where DEVICE_PORT_GIGE_PORT_LINK.DEVICE_PORT_ID = DEVICE_PORT.
Views E ETHERNET_ISL, GIGE_PORT SOURCE_GIGE_PORT, VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH, SWITCH_PORT SOURCE_SWITCH_PORT, GIGE_PORT DEST_GIGE_PORT, VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH, SWITCH_PORT DEST_SWITCH_PORT where SOURCE_GIGE_PORT.ID = ETHERNET_ISL.SOURCE_PORT_ID and SOURCE_GIGE_PORT.SWITCH_PORT_ID = SOURCE_SWITCH_PORT.ID and SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID = SOURCE_VIRTUAL_SWITCH.ID and DEST_GIGE_PORT.ID = ETHERNET_ISL.DEST_PORT_ID and DEST_GIGE_PORT.SWITCH_PORT_ID = DEST_SWITCH_PORT.
E Views left outer join left outer join EVENT_CATEGORY.ID left outer join left outer join EVENT_DESCRIPTION.ID left outer join left outer join EVENT_ORIGIN on EVENT.EVENT_ORIGIN_ID = EVENT_ORIGIN.ID EVENT_CATEGORY on EVENT.EVENT_CATEGORY_ID = EVENT_MODULE on EVENT.EVENT_MODULE_ID = EVENT_MODULE.ID EVENT_DESCRIPTION on EVENT.EVENT_DESCRIPTION_ID = EVENT_DETAILS on EVENT.ID = EVENT_DETAILS.EVENT_ID EVENT_CALL_HOME on EVENT.ID = EVENT_CALL_HOME.
Views E FABRIC.CONTACT, FABRIC.LOCATION, FABRIC.DESCRIPTION, FABRIC.CREATION_TIME, FABRIC.LAST_SCAN_TIME, FABRIC.LAST_UPDATE_TIME, FABRIC.TRACK_CHANGES, FABRIC.TYPE, FABRIC.USER_DEFINED_VALUE_1, FABRIC.USER_DEFINED_VALUE_2, FABRIC.USER_DEFINED_VALUE_3, FABRIC.PRINCIPAL_SWITCH_WWN, FABRIC.ZONE_TRANSACTION_TIMEOUT, FABRIC.FABRIC_MODEL, FABRIC.ENHANCED_TI_ZONE_SUPPORT, VIRTUAL_SWITCH.ID as SEED_SWITCH_ID, VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID, VIRTUAL_SWITCH.INTEROP_MODE, CORE_SWITCH.
E Views FCIP_TUNNEL_CIRCUIT.SECURITY_FLAG, FCIP_TUNNEL_CIRCUIT.DSCP_CONTROL, FCIP_TUNNEL_CIRCUIT.CIRCUIT_STATUS, FCIP_TUNNEL_CIRCUIT.ENABLED, FCIP_TUNNEL_CIRCUIT.MISMATCHED_CONFIGURATIONS, FCIP_TUNNEL_CIRCUIT.CIRCUIT_STATUS_STRING, FCIP_TUNNEL_CIRCUIT.L2COS_F_CLASS, FCIP_TUNNEL_CIRCUIT.L2_COS_HIGH, FCIP_TUNNEL_CIRCUIT.L2_COS_MEDIUM, FCIP_TUNNEL_CIRCUIT.L2_COS_LOW, FCIP_TUNNEL_CIRCUIT.DSCP_F_CLASS, FCIP_TUNNEL_CIRCUIT.DSCP_HIGH, FCIP_TUNNEL_CIRCUIT.DSCP_MEDIUM, FCIP_TUNNEL_CIRCUIT.DSCP_LOW, GIGE_PORT.
Views E FCIP_TUNNEL.FICON_TR_EMUL_ENABLED, FCIP_TUNNEL.FICON_DEBUG_FLAGS, FCIP_TUNNEL.REMOTE_WWN, FCIP_TUNNEL.CDC, FCIP_TUNNEL.ADMIN_STATUS, FCIP_TUNNEL.CONTROL_L2_COS, FCIP_TUNNEL.DSCP_CONTROL, FCIP_TUNNEL.TRUNKING_ALGORITHM, FCIP_TUNNEL.EXTENDED_TUNNEL, FCIP_TUNNEL.VIRTUAL_SWITCH_ID, FCIP_TUNNEL.CIRCUIT_COUNT, FCIP_TUNNEL.MISMATCHED_CONFIG_DETAILS, FCIP_TUNNEL.SLOT_NUMBER, FCIP_TUNNEL.FICON_ENABLED, FCIP_TUNNEL.TPERF_ENABLED, FCIP_TUNNEL.AUTH_KEY, FCIP_TUNNEL.CONNECTED_COUNT, FCIP_TUNNEL.
E Views FRU_INFO create or replace view FRU_INFO as select FRU.ID, FRU.CORE_SWITCH_ID, FRU.TAG, FRU.PART_NUMBER, FRU.SERIAL_NUMBER, FRU.VENDOR_PART_NUMBER, FRU.VENDOR_SERIAL_NUMBER, FRU.CAN_BE_FRUED, FRU.SLOT_NUMBER, FRU.MANUFACTURER_DATE, FRU.UPDATE_DATE, FRU.VERSION, FRU.MANUFACTURER, FRU.VENDOR_EQUIPMENT_TYPE, FRU.OPERATIONAL_STATUS, FRU.TOTAL_OUTPUT_POWER, FRU.SPEED, FRU.CREATION_TIME, FRU.LAST_UPDATE_TIME, FRU.PREVIOUS_OP_STATUS, FRU.VENDOR, CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN, VIRTUAL_SWITCH.
Views E GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID; GIGE_PORT_INFO create or replace view GIGE_PORT_INFO as select GIGE_PORT.ID, GIGE_PORT.SWITCH_PORT_ID, GIGE_PORT.PORT_NUMBER, GIGE_PORT.SLOT_NUMBER, GIGE_PORT.ENABLED, GIGE_PORT.SPEED, GIGE_PORT.MAX_SPEED, GIGE_PORT.MAC_ADDRESS, GIGE_PORT.PORT_NAME, GIGE_PORT.OPERATIONAL_STATUS, GIGE_PORT.LED_STATE, GIGE_PORT.SPEED_LED_STATE, GIGE_PORT.PORT_TYPE, GIGE_PORT.PERSISTENTLY_DISABLED, GIGE_PORT.
E Views HBA_PORT.CNA_PORT_ID, HBA_PORT.PORT_NWWN, HBA_PORT.PHYSICAL_PORT_WWN, HBA_PORT.SWITCH_IP, HBA_PORT.PRINCIPAL_SWITCH_WWN, HBA_PORT.HBA_ID, HBA_PORT.PORT_NUMBER, HBA_PORT.NAME, HBA_PORT.FACTORY_PORT_WWN, HBA_PORT.FACTORY_NODE_WWN, HBA_PORT.PREBOOT_CREATED, HBA_PORT_DETAIL.PERSISTENT_BINDING, HBA_PORT_DETAIL.FABRIC_NAME, HBA_PORT_DETAIL.BOOT_OVER_SAN, HBA_PORT_DETAIL.BOOT_OPTION, HBA_PORT_DETAIL.BOOT_SPEED, HBA_PORT_DETAIL.BOOT_TOPOLOGY, HBA_PORT_DETAIL.BB_CREDIT, HBA_PORT_DETAIL.
Views E HBA_PORT_FCOE_DETAILS.MAX_FRAME_SIZE as FCOE_MAX_FRAME_SIZE, HBA_PORT_FCOE_DETAILS.MTU as FCOE_MTU, HBA_PORT_FCOE_DETAILS.PATH_TOV as FCOE_PATH_TOV, HBA_PORT_FCOE_DETAILS.SCSI_QUEUE_DEPTH as FCOE_SCSI_QUEUE_DEPTH, HBA_PORT_FCOE_DETAILS.STATE as FCOE_STATE, HBA_PORT_FCOE_DETAILS.SUPPORTED_CLASS as FCOE_SUPPORTED_CLASS, HBA_PORT_FCOE_DETAILS.TRL_SPEED as FCOE_TRL_SPEED, HBA_PORT_FCOE_DETAILS.TRL_STATE as FCOE_TRL_STATE, HBA_PORT_FCOE_DETAILS.PG_ID as FCOE_PG_ID, HBA_PORT_FCOE_DETAILS.
E Views HBA_REMOTE_PORT_LUN.TARGET_WWN, HBA_REMOTE_PORT_LUN.PHYSICAL_LUN, HBA_REMOTE_PORT_LUN.LUN_ID, HBA_REMOTE_PORT.FCP_IM_STATE, HBA_REMOTE_PORT.IO_LATENCY_MIN, HBA_REMOTE_PORT.IO_LATENCY_MAX, HBA_REMOTE_PORT.IO_LATENCY_AVERAGE, HBA_REMOTE_PORT.DATA_RETRANSMISSION_SUPPORT, HBA_REMOTE_PORT.REC_SUPPORT, HBA_REMOTE_PORT.TASK_RENTRY_IDENT_SUPPORT, HBA_REMOTE_PORT.CONFIRMED_COMPLETIONS_SUPPORT from HBA_TARGET, HBA_REMOTE_PORT, HBA_REMOTE_PORT_LUN where HBA_TARGET.
Views E DEVICE_ENCLOSURE.SERIAL_NUMBER, DEVICE_ENCLOSURE.FIRMWARE, DEVICE_ENCLOSURE.USER_DEFINED_VALUE1, DEVICE_ENCLOSURE.USER_DEFINED_VALUE2, DEVICE_ENCLOSURE.USER_DEFINED_VALUE3, DEVICE_ENCLOSURE.HCM_AGENT_VERSION, DEVICE_ENCLOSURE.OS_VERSION, DEVICE_ENCLOSURE.CREATED_BY, DEVICE_ENCLOSURE.TRACK_CHANGES, DEVICE_ENCLOSURE.LAST_UPDATE_TIME, DEVICE_ENCLOSURE.LAST_UPDATE_MODULE, DEVICE_ENCLOSURE.TRUSTED, DEVICE_ENCLOSURE.CREATION_TIME, DEVICE_ENCLOSURE.MISSING, DEVICE_ENCLOSURE.
E Views ISL.SOURCE_DOMAIN_ID, ISL.SOURCE_PORT_NUMBER, ISL.MISSING, SOURCE_VIRTUAL_SWITCH.ID as SOURCE_SWITCH_ID, SOURCE_VIRTUAL_SWITCH.NAME as SOURCE_SWITCH_NAME, SOURCE_VIRTUAL_SWITCH.WWN as SOURCE_SWITCH_WWN, SOURCE_VIRTUAL_SWITCH.CORE_SWITCH_ID as SOURCE_CORE_SWITCH_ID, SOURCE_VIRTUAL_SWITCH.BASE_SWITCH as SOURCE_BASE_SWITCH, SOURCE_SWITCH_PORT.ID as SOURCE_SWITCH_PORT_ID, SOURCE_SWITCH_PORT.WWN as SOURCE_SWITCH_PORT_WWN, SOURCE_SWITCH_PORT.NAME as SOURCE_SWITCH_PORT_NAME, SOURCE_SWITCH_PORT.
Views E ISL_INFO.TYPE, ISL_INFO.SOURCE_PORT_NUMBER, ISL_INFO.SOURCE_SWITCH_ID, SOURCE_CORE_SWITCH.IP_ADDRESS as SOURCE_SWITCH_IP_ADDRESS, SOURCE_VIRTUAL_SWITCH.WWN as SOURCE_SWITCH_WWN, ISL_INFO.SOURCE_DOMAIN_ID as MASTER_PORT, ISL_INFO.SOURCE_SWITCH_NAME, ISL_INFO.SOURCE_SWITCH_PORT_ID, ISL_INFO.DEST_PORT_NUMBER, ISL_INFO.DEST_SWITCH_ID, DEST_CORE_SWITCH.IP_ADDRESS as DEST_SWITCH_IP_ADDRESS, DEST_VIRTUAL_SWITCH.WWN as DEST_SWITCH_WWN, ISL_INFO.SOURCE_SWITCH_PORT_WWN, ISL_INFO.
E Views PHANTOM_PORT_INFO create or replace view PHANTOM_PORT_INFO as select PHANTOM_PORT.ID, PHANTOM_PORT.WWN, PHANTOM_PORT.VIRTUAL_SWITCH_ID, PHANTOM_PORT.PORT_NUMBER, PHANTOM_PORT.PORT_ID, PHANTOM_PORT.SPEED, PHANTOM_PORT.MAX_SPEED, PHANTOM_PORT.TYPE, PHANTOM_PORT.REMOTE_NODE_WWN, PHANTOM_PORT.REMOTE_PORT_WWN, PHANTOM_PORT.PHANTOM_TYPE, PHANTOM_PORT.BB_FABRIC_ID, VIRTUAL_SWITCH.WWN as VIRTUAL_SWITCH_WWN from PHANTOM_PORT, VIRTUAL_SWITCH where PHANTOM_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.
Views E SWITCH_PORT.VIRTUAL_SWITCH_ID, SWITCH_PORT.USER_PORT_NUMBER, SWITCH_PORT.TYPE from PORT_BOTTLENECK_STATUS left outer join SWITCH_PORT on PORT_BOTTLENECK_STATUS.SWITCH_PORT_ID = SWITCH_PORT.ID; PORT_GROUP_INFO create or replace view PORT_GROUP_INFO as select SWITCH_PORT.ID as PORT_ID, SWITCH_PORT.NAME as SWITCH_PORT_NAME, SWITCH_PORT.WWN, SWITCH_PORT.HEALTH, SWITCH_PORT.STATUS, SWITCH_PORT.PORT_NUMBER, SWITCH_PORT.SLOT_NUMBER, SWITCH_PORT.FICON_SUPPORTED, SWITCH_PORT.STATE, SWITCH_PORT.
E Views SCOM_EE_MONITOR_INFO This view provides combined ee_monitor, ee_monitor_stats, device_port and device_node tables to get the EE Monitor information for SCOM plug-in. create or replace view SCOM_EE_MONITOR_INFO as select distinct EE_MONITOR.NAME, EE_MONITOR.SWITCH_PORT_ID, EE_MONITOR.SOURCE_PORT_ID, EE_MONITOR.DEST_PORT_ID, EE_MONITOR_STATS.TX, EE_MONITOR_STATS.RX, EE_MONITOR_STATS.CRCERRORS, EE_MONITOR_STATS.CREATION_TIME, SOURCE_PORT.PORT_ID as SID, DEST_PORT.PORT_ID as DID, SOURCE_NODE.
Views E SENSOR.VERSION, SENSOR.CREATION_TIME, SENSOR.LAST_UPDATE_TIME, SENSOR.FRU_TYPE, SENSOR.UNIT_NUMBER, SENSOR.STATE, CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN, VIRTUAL_SWITCH.SWITCH_MODE as VIRTUAL_SWITCH_MODE from SENSOR, CORE_SWITCH, VIRTUAL_SWITCH where SENSOR.CORE_SWITCH_ID = CORE_SWITCH.ID and SENSOR.CORE_SWITCH_ID = VIRTUAL_SWITCH.CORE_SWITCH_ID; SMART_CARD_USAGE_INFO create or replace view SMART_CARD_USAGE_INFO as select SC.ID SMART_CARD_ID, SC.CARD_TYPE, SC.CARD_INFO, SC.CARDCN_ID, SC.
E Views SMART_CARD SC, ENCRYPTION_GROUP EG, RECOVERY_CARD_GROUP_MAPPING RCGM where SC.ID = RCGM.SMART_CARD_ID and EG.ID = RCGM.ENCRYPTION_GROUP_ID and SC.CARD_TYPE = 1 union select SC.ID SMART_CARD_ID, SC.CARD_TYPE, SC.CARD_INFO, SC.CARDCN_ID, SC.FIRST_NAME, SC.LAST_NAME, SC.NOTES, SC.CREATION_TIME, EE.ID ENGINE_ID, -1 ENCRYPTION_GROUP_ID, '' GROUP_NAME, -1 CARD_POSITION, EE.SWITCH_ID CRYPTO_SWITCH_ID, EE.
Views E CORE_SWITCH.NAT_PRIVATE_IP_ADDRESS, CORE_SWITCH.ALTERNATE_IP_ADDRESS, VIRTUAL_SWITCH.ID, VIRTUAL_SWITCH.NAME, VIRTUAL_SWITCH.OPERATIONAL_STATUS, VIRTUAL_SWITCH.SWITCH_MODE, VIRTUAL_SWITCH.AD_CAPABLE, VIRTUAL_SWITCH.WWN, VIRTUAL_SWITCH.ROLE, VIRTUAL_SWITCH.FCS_ROLE, VIRTUAL_SWITCH.DOMAIN_ID, VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID, VIRTUAL_SWITCH.BASE_SWITCH, VIRTUAL_SWITCH.MAX_ZONE_CONFIG_SIZE, VIRTUAL_SWITCH.CREATION_TIME, VIRTUAL_SWITCH.LAST_UPDATE_TIME, VIRTUAL_SWITCH.USER_NAME, VIRTUAL_SWITCH.
E Views CORE_SWITCH_DETAILS.TAG, CORE_SWITCH_DETAILS.ACT_CP_PRI_FW_VERSION, CORE_SWITCH_DETAILS.ACT_CP_SEC_FW_VERSION, CORE_SWITCH_DETAILS.STBY_CP_PRI_FW_VERSION, CORE_SWITCH_DETAILS.STBY_CP_SEC_FW_VERSION, CORE_SWITCH_DETAILS.TYPE as DETAILS_TYPE, CORE_SWITCH_DETAILS.EGM_CAPABLE, CORE_SWITCH_DETAILS.SUB_TYPE, CORE_SWITCH_DETAILS.PARTITION, CORE_SWITCH_DETAILS.MAX_NUM_OF_BLADES, CORE_SWITCH_DETAILS.SNMP_INFORMS_ENABLED, CORE_SWITCH_DETAILS.VENDOR_VERSION, CORE_SWITCH_DETAILS.
Views E SWITCH_PORT.ACTUAL_DISTANCE, SWITCH_PORT.LONG_DISTANCE_SETTING, SWITCH_PORT.DEGRADED_PORT, SWITCH_PORT.REMOTE_NODE_WWN, SWITCH_PORT.REMOTE_PORT_WWN, SWITCH_PORT.LICENSED, SWITCH_PORT.SWAPPED, SWITCH_PORT.TRUNKED, SWITCH_PORT.TRUNK_MASTER, SWITCH_PORT.PERSISTENT_DISABLE, SWITCH_PORT.FICON_SUPPORTED, SWITCH_PORT.BLOCKED, SWITCH_PORT.PROHIBIT_PORT_NUMBERS, SWITCH_PORT.PROHIBIT_PORT_COUNT, SWITCH_PORT.NPIV, SWITCH_PORT.NPIV_CAPABLE, SWITCH_PORT.NPIV_ENABLED, SWITCH_PORT.
E Views SWITCH_SNMP_INFO create or replace view SWITCH_SNMP_INFO as select CORE_SWITCH.ID as PHYSICAL_SWITCH_ID, CORE_SWITCH.NAME as PHYSICAL_SWITCH_NAME, CORE_SWITCH.IP_ADDRESS, CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN, CORE_SWITCH.OPERATIONAL_STATUS as PHYSICAL_OPERATIONAL_STATUS, CORE_SWITCH.TYPE, CORE_SWITCH.MAX_VIRTUAL_SWITCHES, CORE_SWITCH.FIRMWARE_VERSION, CORE_SWITCH.VENDOR, CORE_SWITCH.REACHABLE, CORE_SWITCH.UNREACHABLE_TIME, CORE_SWITCH.MODEL, CORE_SWITCH_DETAILS.CONTACT, CORE_SWITCH_DETAILS.
Views E coalesce(SNMP_CREDENTIALS.WRITE_COMMUNITY_STRING, (select SNMP_PROFILE.WRITE_COMMUNITY_STRING from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_WRITE_COMMUNITY_STRING, coalesce(SNMP_CREDENTIALS.USER_NAME, (select SNMP_PROFILE.USER_NAME from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_USER_NAME, coalesce(SNMP_CREDENTIALS.CONTEXT_NAME, (select SNMP_PROFILE.CONTEXT_NAME from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_CONTEXT_NAME, coalesce(SNMP_CREDENTIALS.
E Views VIRTUAL_FCOE_PORT.PORT_TYPE, VIRTUAL_FCOE_PORT.ENABLED, VIRTUAL_FCOE_PORT.STATUS, VIRTUAL_FCOE_PORT.TRUNK_INDEX, VIRTUAL_FCOE_PORT.PORT_NUMBER, VIRTUAL_FCOE_PORT.NAME, VIRTUAL_FCOE_PORT.SLOT_NUMBER, VIRTUAL_FCOE_PORT.VLAN_ID, VIRTUAL_FCOE_PORT.DEVICE_COUNT, VIRTUAL_FCOE_PORT.PEER_MAC, VIRTUAL_SWITCH.WWN as VIRTUAL_SWITCH_WWN, VIRTUAL_SWITCH.ROLE as SWITCH_ROLE, VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID as VIRTUAL_FABRIC_ID, VIRTUAL_SWITCH.DOMAIN_ID as DOMAIN_ID, VIRTUAL_SWITCH.
Views E from DEVICE_PORT left outer join USER_DEFINED_DEVICE_DETAIL on DEVICE_PORT.WWN = USER_DEFINED_DEVICE_DETAIL.WWN, CORE_SWITCH, SWITCH_PORT, VIRTUAL_SWITCH, VM_CONNECTIVITY, DEVICE_NODE, FABRIC where VM_CONNECTIVITY.ADAPTER_PORT_WWN = DEVICE_PORT.WWN and DEVICE_PORT.SWITCH_PORT_WWN = SWITCH_PORT.WWN and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and DEVICE_PORT.NODE_ID = DEVICE_NODE.ID and DEVICE_NODE.FABRIC_ID = FABRIC.
E Views and and and and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID DEVICE_PORT.NODE_ID = DEVICE_NODE.ID DEVICE_NODE.FABRIC_ID = FABRIC.ID; VM_EE_MONITOR_INFO This view provides combined ee_monitor, ee_monitor_stats, device_port and device_node tables to get the EE Monitor information for vmplug-in. create or replace view VM_EE_MONITOR_INFO as select distinct EE_MONITOR.NAME, EE_MONITOR.SWITCH_PORT_ID, EE_MONITOR.SOURCE_PORT_ID, EE_MONITOR.
Views E VM_HOST.CPU_COUNT, VM_HOST.CPU_TYPE, VM_HOST.CPU_RESOURCES as HOST_CPU_RESOURCES, VM_HOST.MEM_RESOURCES as HOST_MEM_RESOURCES, VM_HOST.LICENSE_SERVER, VM_HOST.BOOT_TIME as HOST_BOOT_TIME, CLUSTER.NAME as CLUSTER_NAME, CLUSTER.IP_ADDRESS as CLUSTER_ADDRESS, VIRTUAL_MACHINE.ID as VM_ID, VIRTUAL_MACHINE.HYPERVISOR_VM_ID, VIRTUAL_MACHINE.NAME as VM_NAME, VIRTUAL_MACHINE.DESCRIPTION as VM_DESCRIPTION, VIRTUAL_MACHINE.OS as VM_OS, VIRTUAL_MACHINE.STATUS as VM_STATUS, VIRTUAL_MACHINE.
E Views VM_PATH.ACTIVE as PATH_ACTIVE, VM_PATH.PREFERRED as PATH_PREFERRED from VM_LUN join VM_PATH on VM_LUN.ID = VM_PATH.LUN_ID; VM_STATISTICS_INFO This view gets the FC port statistics for the VM Connectivity data. create or replace view VM_STATISTICS_INFO as select distinct DEVICE_PORT.SWITCH_PORT_WWN, DEVICE_PORT.DOMAIN_ID, VM_CONNECTIVITY.HYPERVISOR_HOST, VM_CONNECTIVITY.ADAPTER_PORT_WWN, VM_CONNECTIVITY.ADAPTER_PORT_STATUS, VM_CONNECTIVITY.HYPERVISOR_VM_ID, VM_CONNECTIVITY.VM_NAME, CORE_SWITCH.
Views E CORE_SWITCH.NAME as CORE_NAME, SWITCH_TE_PORT_STATS.TRANSMIT_OK, SWITCH_TE_PORT_STATS.RECEIVE_OK, SWITCH_TE_PORT_STATS.TRANSMIT_OK_PERCENT_UTIL, SWITCH_TE_PORT_STATS.RECEIVE_OK_PERCENT_UTIL, -1,-1,-1,-1,-1, SWITCH_TE_PORT_STATS.CREATION_TIME, VIRTUAL_SWITCH.NAME as VIRTUAL_NAME, SWITCH_PORT.STATUS as SWITCH_PORT_STATUS, SWITCH_PORT.PORT_ID, SWITCH_PORT.
E Views ZONE_DB.ID = ZONE_DB_CONFIG.
Views E ); -- Name: accessible_port_group; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE accessible_port_group ( accessible_entity_id integer NOT NULL, port_group_id integer ); -- Name: accessible_vip_server; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE accessible_vip_server ( accessible_entity_id integer NOT NULL, server_ip character varying(39) NOT NULL, server_mode character varying(39) NOT NULL, server_iron_ip character varying(39) ); -- Name: acl_spec; Typ
E Views -- Name: address_spec; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE address_spec ( address_spec_id integer NOT NULL, table_subtype character varying(32) NOT NULL ); -- Name: alert; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE alert ( alert_id integer NOT NULL, name character varying(32) NOT NULL, user_id integer NOT NULL, description character varying(255), status character(1), props_str character varying(2048), last_updated bigint, severity smallint,
Views E macaddr character varying(17), authenticated smallint, associated smallint, forwarding smallint, lastkeytype smallint, manualblock smallint, dynamicblock smallint, attemptsconsumed integer, attemptsremained integer, remainedcycletime integer, remainedblocktime integer ); -- Name: ap_ids_last_saved; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE ap_ids_last_saved ( device_id integer NOT NULL, time_stamp bigint NOT NULL ); -- Name: ap_ids_sqnum_seq; Type: SEQUENCE; Schema: dcm;
E Views authenticated smallint, associated smallint, isforwarding smallint, keytype smallint, lastauthenticatedtime bigint, associatedtime bigint, lastassociatedtime bigint, lastdisassociatedtime bigint, txpacketcount bigint, rxpacketcount bigint, txbytecount bigint, rxbytecount bigint, time_interval bigint, radio smallint, channel smallint ); -- Name: ap_station_last_saved; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE ap_station_last_saved ( device_id integer NOT NULL, time_stamp b
Views E ); -- Name: block_mac_list; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE block_mac_list ( block_mac_list_id integer NOT NULL, mac character varying(32) NOT NULL, radio_vap numeric(2,0), lockout_time character varying(64), last_seen_ap_id integer, last_time_seen character varying(64), device_group_id integer, is_full_device_group numeric(1,0), deployment_setting_id integer ); -- Name: cfg_backup_archive; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE cfg_
E Views -- Name: cfg_restore_backup_detail; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE cfg_restore_backup_detail ( cfg_backup_detail_id integer NOT NULL, user_id integer, cfg_file_revision_id integer ); -- Name: chassis_component; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE chassis_component ( chassis_component_id integer NOT NULL, device_id integer NOT NULL, name character varying(128), description character varying(128), class character varying(32), hw_re
Views E exec_option numeric(2,0), is_public numeric(1,0), content character varying, report_file_name character varying(256), template_report_type numeric(2,0) ); -- Name: cli_template_report_execution; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE cli_template_report_execution ( cli_template_report_execution_id integer NOT NULL, device_deployment_job_id integer, cli_template_id integer, content character varying, compare_status numeric(2,0) ); -- Name: cli_template_target_device; Ty
E Views -- Name: collector_target_entry; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE collector_target_entry ( collector_target_entry_id integer NOT NULL, collector_id integer, target_id integer NOT NULL, prop_str character varying(8192), collector_target_entry_type integer ); -- Name: collector_threshold_rearm_trigger; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE collector_threshold_rearm_trigger ( collector_threshold_rearm_trigger_id integer NOT NULL, collec
Views E device_deployment_job_id integer NOT NULL, interface_id integer NOT NULL ); -- Name: deployment_setting; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE deployment_setting ( deployment_setting_id integer NOT NULL, scenario_id integer NOT NULL, user_id integer NOT NULL, is_write_to_ram numeric(1,0), is_reload numeric(1,0), deployment_mode character(1), do_pre_post_snapshot numeric(2,0) NOT NULL, cli_template_id integer NOT NULL, pre_post_deploy_setting_id integer NOT NULL, post_
E Views local_username_port_cfg character varying(512), local_password_port_cfg character varying(512), local_username_read_only character varying(512), local_password_read_only character varying(512), radius_username_port_cfg character varying(512), radius_password_port_cfg character varying(512), radius_username_read_only character varying(512), radius_password_read_only character varying(512), tac_username_port_cfg character varying(512), tac_password_port_cfg character varying(512), tac_username_read_
Views E name_key character varying(64) NOT NULL, device_config_id integer NOT NULL, value_str bytea NOT NULL, line_num smallint NOT NULL, key1 smallint, key2 smallint, ref_table_name character varying(64), table_id integer, table_subtype character varying(32) NOT NULL, type_key character varying(32) ); -- Name: device_deployment_job; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE device_deployment_job ( device_config_id integer NOT NULL, device_deployment_job_id integer NOT NULL, depl
E Views start_time numeric(20,0) NOT NULL, duration integer ); -- Name: discovery_log; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE discovery_log ( discovery_log_id integer NOT NULL, discovery_cycle_id integer NOT NULL, "timestamp" numeric(20,0), category smallint, device_ip character varying(40), messages character varying(4096) ); -- Name: discovery_profile; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE discovery_profile ( discovery_profile_id integer NOT NUL
Views E -- Name: events; Type: VIEW; Schema: dcm; Owner: dcmadmin CREATE VIEW events AS SELECT emain.trap_log_id, emain.trap_sender, emain."timestamp", emain.severity, emsgs.messages, emain.is_ack, emain.log_type, emain.slot, emain.port, emain.device_id, emain.event_action_id, emain.device_group_id, emain.port_group_id, emain.trap_device_ip, emain.log_sub_type, emain.unit FROM (events_main emain LEFT JOIN events_messages emsgs ON ((emain.messages_id = emsgs.
E Views is_port_vlan_enabled numeric(1,0), architecture_type numeric(2,0), build_label character varying(64), ssl_slot numeric(4,0) ); -- Name: foundry_module; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE foundry_module ( module_id integer NOT NULL, serial_num character varying(32), dram_size numeric(4,0), boot_flash_size numeric(4,0), module_type numeric(4,0), code_flash_size numeric(4,0), expansion_module_type numeric(4,0), expansion_module_description character varying(128) ); --
Views E -- Name: image_archive; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE image_archive ( image_archive_id integer NOT NULL, product_type character varying(32) NOT NULL, feature_mask character varying(32), supported_type character varying(32) NOT NULL, flash_size integer, location character varying(255) NOT NULL, file_name character varying(64) NOT NULL, version_label character varying(32) NOT NULL, release_datetime character varying(64), special_key character varying(32), image_
E Views CREATE TABLE ip_address_spec ( address_spec_id integer NOT NULL, ip_address character varying(40) NOT NULL, wildcard_mask character varying(40) ); -- Name: inm_ip_interface; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE inm_ip_interface ( ip_interface_id integer NOT NULL, ip_routing_service_id integer, interface_id integer, device_id integer NOT NULL, ip_subnet_id integer NOT NULL, ip_address character varying(40) NOT NULL, subnet_mask character varying(40) ); -- Name: ip_rou
Views E network_number character varying(32) NOT NULL, frame_type numeric(4,0) NOT NULL ); -- Name: ironclad_adaptive_entry; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE ironclad_adaptive_entry ( policy_entry_id integer NOT NULL, normal_burst numeric(20,3), normal_burst_type character(1), max_burst numeric(20,3), max_burst_type character(1), conform_action numeric(2,0), exceed_action numeric(2,0), vlan_id numeric(4,0) ); -- Name: jetcore_adaptive_entry; Type: TABLE; Schema: dcm; Own
E Views config_state character varying(1), time_stamp character varying(64) ); -- Name: license_files; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE license_files ( license_file_id integer NOT NULL, identifier character varying(255) NOT NULL, license_details character varying(255) NOT NULL, is_eval numeric(1,0) NOT NULL ); -- Name: license_parameters; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE license_parameters ( license_param_id integer NOT NULL, identifier
Views E type numeric(2,0) ); -- Name: loopback_interface; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE loopback_interface ( interface_id integer NOT NULL ); -- Name: mac_filter_entry; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE mac_filter_entry ( mac_filter_entry_id integer NOT NULL, mac_filter_group_id integer, mac_filter_num numeric(8,0) NOT NULL, is_permit numeric(1,0), src_mac_address character varying(24) NOT NULL, src_address_mask character varying(24),
E Views is_independent numeric(1,0) NOT NULL, xml_instance bytea NOT NULL, key1 character varying(128), key2 character varying(128), last_updated_time numeric(20,0), is_internal numeric(1,0) ); -- Name: mib_object; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE mib_object ( mib_object_id integer NOT NULL, oid character varying(128) NOT NULL, name character varying(64), value_type numeric(2,0), target_type numeric(2,0) ); -- Name: module; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tabl
Views E mpls_admin_group_db_id integer NOT NULL, interface_id integer NOT NULL ); -- Name: mpls_lsp; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE mpls_lsp ( mpls_lsp_db_id integer NOT NULL, table_subtype character varying(32) NOT NULL, name character varying(255) NOT NULL, destination_ip_address character varying(255) NOT NULL, oper_status smallint NOT NULL, device_id integer NOT NULL ); -- Name: mpls_path; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE mpls_pat
E Views ); -- Name: mpls_rsvp_lsp_admin_group_container; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE mpls_rsvp_lsp_admin_group_container ( mpls_rsvp_lsp_admin_group_container_db_id integer NOT NULL, mpls_rsvp_lsp_parameters_db_id integer, mpls_rsvp_lsp_frr_parameters_db_id integer ); -- Name: mpls_rsvp_lsp_frr_parameters; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE mpls_rsvp_lsp_frr_parameters ( mpls_rsvp_lsp_frr_parameters_db_id integer NOT NULL, bandwidth
Views E ); -- Name: mpls_service; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE mpls_service ( mpls_service_db_id integer NOT NULL, name character varying(255) NOT NULL, vcid bigint NOT NULL, mpls_service_type smallint NOT NULL, vll_mode smallint, status smallint NOT NULL, conflicts integer NOT NULL, last_updated_time numeric(20,0) ); -- Name: mpls_service_device_relation; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE mpls_service_device_relation ( mpls_service_
E Views mrp_ring_device_db_id integer NOT NULL, mrp_ring_id integer NOT NULL, device_id integer NOT NULL, port_vlan_db_id integer DEFAULT 0 NOT NULL, mrp_ring_name character varying(255), topo_grp_id integer DEFAULT 0 NOT NULL, state smallint NOT NULL, role smallint NOT NULL, hello_time integer NOT NULL, pre_fwd_time integer NOT NULL, pri_port_interface_id integer DEFAULT 0 NOT NULL, pri_port_state smallint NOT NULL, pri_port_type smallint NOT NULL, pri_port_active_interface_id integer DEFAULT 0 NOT NULL,
Views E port_num smallint NOT NULL, module_id integer NOT NULL, is_port_present smallint, table_subtype character varying(32) NOT NULL ); -- Name: policy; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE policy ( policy_id integer NOT NULL, name character varying(64) NOT NULL, user_id integer, is_public numeric(1,0), description character varying(256) ); -- Name: policy_entry; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE policy_entry ( policy_entry_id integer NOT
E Views -- Name: port_vlan; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE port_vlan ( vlan_db_id integer NOT NULL, stp numeric(1,0), vlan_id smallint NOT NULL, qos smallint, global_vlan_db_id integer, stp_instance_id integer ); -- Name: pos_interface; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE pos_interface ( interface_id integer NOT NULL ); -- Name: inm_privilege; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE inm_privilege ( privilege_i
Views E last_updated bigint, name character varying(64) NOT NULL, messages character varying(255), policy_desc character varying(255) ); -- Name: query_based_device_group; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE query_based_device_group ( device_group_id integer NOT NULL, query_text character varying(512) ); -- Name: radio_interface; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE radio_interface ( interface_id integer NOT NULL, radio_type numeric(2,0) NOT N
E Views ); -- Name: report_definition; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE report_definition ( report_definition_id integer NOT NULL, name character varying(64) NOT NULL, category character varying(20) NOT NULL, user_id integer NOT NULL, type numeric(2,0) NOT NULL, last_modified character varying(64) NOT NULL, description character varying(128), definition character varying NOT NULL, is_with_data_source numeric(1,0), prompt numeric(1,0) DEFAULT 0, is_prompt_fields_filled nu
Views E sensor_total integer, sensor_up integer, sensor_down integer, sensor_relief integer, last_viewed_timestamp bigint NOT NULL ); -- Name: rf_overview_logs; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE rf_overview_logs ( log_timestamp bigint NOT NULL, log_message character varying(512) NOT NULL ); -- Name: rfmon_ap; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE rfmon_ap ( sqnum integer NOT NULL, time_stamp bigint, device_id integer NOT NULL, sys_up_time int
E Views totalcrcerrframes integer, totalfragerrframes integer, totalretryframes integer, totalassocreq integer, totalassocresp integer, totalreassocreq integer, totalreassocresp integer, totalprobereq integer, totalproberesp integer, totalbeacon integer, totaldisassoc integer, totalauth integer, totaldeauth integer, totalcriticalalerts integer, totalmoderatealerts integer, totalminor integer ); -- Name: rfmon_ap_last_saved; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE rfmon_ap_last_
Views E authtype smallint, networkmode smallint, wepenabled smallint, cfpollable smallint, shortpreamblemode smallint, rsnsupported smallint, onexenabled smallint, shortslottime integer, failedreassocattempts integer, failedassocattempts integer, associateid integer, rssi integer, listeninterval integer, ssidlen smallint, ssid character varying(256), ipaddress character varying(40), deauthreasoncode integer, deassocreasoncode integer, ratesupported character varying(256), extratesupported character varyin
E Views -- Name: rl_access_control_group; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE rl_access_control_group ( rl_access_control_group_id integer NOT NULL, name character varying(64) NOT NULL, user_id integer, is_public numeric(1,0), description character varying(256) ); -- Name: rl_access_control_list; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE rl_access_control_list ( rl_access_control_list_id integer NOT NULL, rl_acl_num numeric(8,0) NOT NULL, is_standa
Views E privilege_id integer NOT NULL, role_id integer NOT NULL ); -- Name: routing_service; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE routing_service ( service_id integer NOT NULL ); -- Name: scenario; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE scenario ( scenario_id integer NOT NULL, name character varying(256) NOT NULL, user_id integer NOT NULL, description character varying(1024), is_internal numeric(1,0) NOT NULL, creation_time character varying(16)
E Views -- Name: scenario_port_binding; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE scenario_port_binding ( scenario_binding_id integer NOT NULL, interface_id integer NOT NULL ); -- Name: scenario_port_group_binding; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE scenario_port_group_binding ( port_group_id integer NOT NULL, scenario_binding_id integer NOT NULL ); -- Name: schedule_email_user; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE s
Views E ); -- Name: service_group_spec; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE service_group_spec ( port_spec_id integer NOT NULL, service_group_id integer ); -- Name: service_name_entry; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE service_name_entry ( service_name_entry_id integer NOT NULL, service_group_id integer NOT NULL, service_port_definition_id integer NOT NULL, name character varying(32) ); -- Name: service_port_definition; Type: TABLE; Schema:
E Views L4_DEST_PORT integer, SRC_SUBNET_BITS smallint, DEST_SUBNET_BITS smallint, LOCAL_AS bigint, SRC_AS bigint, SRC_PEER_AS bigint, SFLOW_IP_ROUTE_INFO_ID integer, IP_FLOW_LABEL integer, SRC_USER integer, DEST_USER integer, FRAMES bigint not null, BYTES bigint not null, TCP_FLAGS smallint ); create table SFLOW_STAGING_SLNUM ( MIN_SLNUM bigint ) with (autovacuum_vacuum_threshold=4); -- Name: sflow_hour_summary; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: create table SFLOW_HOUR_SUMMARY ( SLNU
Views E create table SFLOW_HOUR_SUMMARY_SLNUM ( MAX_SLNUM bigint ) with (autovacuum_vacuum_threshold=4); -- Name: sflow; Type: VIEW; Schema: dcm; Owner: dcmadmin create or replace view SFLOW as select DEVICE_ID, IN_SLOT, IN_PORT, OUT_SLOT, OUT_PORT, L4_PROTOCOL, IP_TOS, SRC_SUBNET_BITS, DEST_SUBNET_BITS, IN_PRIORITY, OUT_PRIORITY, IN_VLAN, OUT_VLAN, L3_PROTOCOL, L4_SRC_PORT, L4_DEST_PORT, TIME_IN_SECONDS, SRC_MAC, DEST_MAC, L3_SRC_ADDR, L3_DEST_ADDR, TCP_FLAGS, LOCAL_AS, SRC_AS, SRC_PEER_AS, SFLOW_IP_ROUT
E Views -- Name: sflow_minute_bgp_view; Type: VIEW; Schema: dcm; Owner: dcmadmin create or replace view SFLOW_MINUTE_BGP_VIEW as select DEVICE_ID, TIME_IN_SECONDS, SRC_AS, SFLOW_IP_ROUTE_INFO_ID, IN_VLAN, OUT_VLAN, FRAMES, BYTES from SFLOW_MINUTE_BGP where SLNUM <= (select MAX_SLNUM from SFLOW_MINUTE_BGP_SLNUM fetch first 1 rows only) union all select DEVICE_ID, TIME_IN_SECONDS, SRC_AS, SFLOW_IP_ROUTE_INFO_ID, IN_VLAN, OUT_VLAN, FRAMES, BYTES from SFLOW_STAGING where SLNUM >= (select MIN_SLNUM from SFLOW_
Views E IN_VLAN smallint, OUT_VLAN smallint, SRC_MAC bytea, DEST_MAC bytea ); create table SFLOW_MINUTE_MAC_SLNUM ( MAX_SLNUM bigint ) with (autovacuum_vacuum_threshold=4); -- Name: sflow_minute_mac_view; Type: VIEW; Schema: dcm; Owner: dcmadmin create or replace view SFLOW_MINUTE_MAC_VIEW as select DEVICE_ID, TIME_IN_SECONDS, SRC_MAC, DEST_MAC, IN_VLAN, OUT_VLAN, FRAMES, BYTES from SFLOW_MINUTE_MAC where SLNUM <= (select MAX_SLNUM from SFLOW_MINUTE_MAC_SLNUM fetch first 1 rows only) union all select DEVI
E Views where SLNUM >= (select MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows only); -- Name: sflow_report_l3_source; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE sflow_report_l3_source ( sflow_report_l3_source_id integer NOT NULL, report_definition_id integer NOT NULL, address_group_id integer, ip_subnet_definition_id integer ); -- Name: sflow_report_l4_source; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE sflow_report_l4_source ( sflow_report_l4_source
Views E constraint PK_SNMP_EXPR_DATA primary key (ID) ); -- Name: snmp_expression; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: create table SNMP_EXPRESSION ( EXPRESSION_ID serial not null, NAME character varying(64) not null, DESCRIPTION character varying(512), EQUATION character varying(1024) ); -- Name: snmp_fwd_aa; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE snmp_fwd_aa ( snmp_fwd_aa_id integer NOT NULL, trap_community character varying(64), trap_user character varyin
E Views CREATE TABLE snmp_fwd_targets ( snmp_fwd_targets_id integer NOT NULL, is_enable character varying(8) DEFAULT 'Yes'::character varying NOT NULL, ip_address character varying(40) NOT NULL, snmp_trap_port integer DEFAULT 162 NOT NULL, snmp_version character varying(8) DEFAULT 'v2/v3'::character varying NOT NULL, snmp_notify_type character varying(1) DEFAULT '1'::character varying NOT NULL, snmp_to_nnm character varying(8) DEFAULT 'No'::character varying NOT NULL ); -- Name: snmp_fwd_trap_oid; Type: T
Views E -- Name: ssl_certificate; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE ssl_certificate ( ssl_certificate_id integer NOT NULL, name character varying(255), location character varying(255), file_name character varying(255), key_id integer NOT NULL, cert_type numeric(2,0) NOT NULL, start_time numeric(20,0), expiration_time numeric(20,0), format numeric(2,0) NOT NULL, description character varying(1024), notification_time numeric(20,0) NOT NULL DEFAULT 0, notification_sent numer
E Views CREATE TABLE stp_entry ( stp_entry_id integer NOT NULL, device_id integer NOT NULL, vlan_id integer NOT NULL, port_id character varying(32) NOT NULL, port_priority smallint NOT NULL, path_cost integer NOT NULL, port_state smallint NOT NULL, designated_cost integer NOT NULL, designated_root character varying(32) NOT NULL, designated_bridge character varying(32) NOT NULL, edge_port smallint NOT NULL, p2p smallint NOT NULL, oper_path_cost integer NOT NULL, port_role smallint NOT NULL, bpdu_tx integer
Views E row_id integer NOT NULL, file_pointer bigint NOT NULL, file_name character varying(512) ); -- Name: system_profile; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE system_profile ( system_profile_id integer NOT NULL, new_installation_update_status character varying(64) NOT NULL, db_schema_string character varying(20), is_demo_version numeric(1,0), demo_expiration_datetime character varying(32), is_full_install numeric(1,0) DEFAULT 0, serial_number character varying(64), system_
E Views -- Name: trap_backup_detail; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE trap_backup_detail ( cfg_backup_detail_id integer NOT NULL, cfg_change_user_name character varying(64), trap_log_id integer ); -- Name: trunk_group_interface; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE trunk_group_interface ( interface_id integer NOT NULL ); -- Name: trunk_group_member; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE trunk_group_member ( tru
Views E phone_number character varying(32), status character(1) NOT NULL, user_type numeric(2,0) DEFAULT 0 NOT NULL, email_address1 character varying(255), email_address2 character varying(255), email_address3 character varying(255), email_address4 character varying(255), email_alertflag1 character(1), email_alertflag2 character(1), email_alertflag3 character(1), email_alertflag4 character(1), last_updated character varying(32), previous_passwords_used character varying(2500), nbi_identity_key character v
E Views ); -- Name: vlan_dynamic_interface_member; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE vlan_dynamic_interface_member ( vlan_interface_relation_id integer NOT NULL ); -- Name: vlan_excluded_interface; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE vlan_excluded_interface ( vlan_interface_relation_id integer NOT NULL ); -- Name: vlan_interface_member; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE vlan_interface_member ( vlan_interfac
Views E -- Name: vpls_endpoint_relation; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE vpls_endpoint_relation ( mpls_service_endpoint_relation_db_id integer NOT NULL ); -- Name: vpnpt_authentication; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE vpnpt_authentication ( vpnpt_authentication_id integer NOT NULL, vpnpt_policy_id integer, realm_policy_id integer ); -- Name: vpnpt_policy; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE vpnpt_policy
E Views xinfo character varying(64) ); -- Name: wired_interface; Type: VIEW; Schema: dcm; Owner: dcmadmin CREATE VIEW wired_interface AS SELECT l2.device_id, l2.device_ip_address, l2.physical_device_id, l2.unit_number, l2.slot_id, l2.slot_num, l2.module_id, l2.physical_port_id, l2.port_num, l2.interface_id, l2.name, l2.if_name, l2.identifier, l2.table_subtype, l2.tag_mode, l2.speed_in_mb, l2.physical_address, l2.duplex_mode, l3.ip_id, l3.ip_interface_id, l3.ip_address, l3.
Views E radio_interface.beacon_rate, radio_interface.dtim, radio_interface.rts_threshold, radio_interface.is_turbo_mode, radio_interface.radio_g_mode, radio_interface.max_associated_clients FROM radio_interface) wireless ON ((l2.interface_id = wireless.
E Views select * from SNMP_DATA_2HOUR union all select * from SNMP_DATA_1DAY; SNMP_EXPR_DATA_INFO create or replace view SNMP_EXPR_DATA_INFO as select * from SNMP_EXPR_DATA union all select * from SNMP_EXPR_DATA_30MIN union all select * from SNMP_EXPR_DATA_2HOUR union all select * from SNMP_EXPR_DATA_1DAY; SNMP_DATA_VIEW create view SNMP_DATA_VIEW AS ( ( SELECT de.device_id, de.ip_address AS device_ip, se.target_type, de.device_id AS target_id, de.sys_name AS target_name, 1 AS collectible_type, se.
Views E SELECT de.device_id, de.ip_address AS device_ip, sd.target_type, ifs.interface_id AS target_id, ifs.if_name AS target_name, 0 AS collectible_type, sd.mib_object_id AS collectible_id, sd.collector_id, ( SELECT perf_collector.name AS collector_name FROM perf_collector WHERE perf_collector.collector_id = sd.collector_id) AS collector_name, ( SELECT (mib_object.name::text || '.'::text) || sd.mib_index::text AS collectible_name FROM mib_object WHERE mib_object.mib_object_id = sd.