Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

ManualsBrandsHP ManualsStorageHP SN8000B 8-slot Power Pack+ SAN Backbone Director Switch

Table Of Contents

53-1003016-05

8 January 2014

53-1003016-05

Network Advisor 12.1.X

Documentation Updates

Summary of content (305 pages)

PAGE 1
53-1003016-05 8 January 2014 Network Advisor 12.1.
PAGE 2
Copyright © 2012 - 2013 Brocade Communications Systems, Inc. All Rights Reserved. Brocade, Brocade Assurance, the B-wing symbol, DCX, Fabric OS, MLX, SAN Health, VCS, and VDX are registered trademarks, and AnyIO, Brocade One, CloudPlex, Effortless Networking, ICX, NET Health, OpenScript, and The Effortless Network are trademarks of Brocade Communications Systems, Inc., in the United States and/or in other countries.
PAGE 3
Contents Contents About This Document In this chapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . v How this document is organized . . . . . . . . . . . . . . . . . . . . . . . . . . . . . v What’s changed in these documents . . . . . . . . . . . . . . . . . . . . . . . . . v Document feedback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vi Chapter 1 Brocade Network Advisor SAN + IP User Manual In this chapter . . . . . . . . .
PAGE 4
Chapter 14, SAN Device Configuration . . . . . . . . . . . . . . . . . . . . . . . 16 Chapter 28, Image Repository for IP Products . . . . . . . . . . . . . . . . . 17 Chapter 32, Global Server Load Balancing . . . . . . . . . . . . . . . . . . . . 17 Appendix A, Application menus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Appendix E, Device Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Appendix G, CLI Templates . . . . . . . . . . . . . . . . . . . . . . . . .
PAGE 5
About This Document In this chapter • How this document is organized . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . v • What’s changed in these documents. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . v • Document feedback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vi How this document is organized This document contains updates to the following Network Advisor manuals: TABLE 1 Brocade Network Advisor 12.1.
PAGE 6
• For the Brocade Network Advisor SAN User Manual, has changes to the following sections: - About this document - Chapter 26, VLAN Management - Chapter 29, Performance Data - Chapter 30, Flow Vision - Chapter 50, Monitoring and Alerting Policy Suite - Appendix H, Database Fields • For the Brocade Network Advisor IP User Manual, has changes to the following sections: - Chapter 4, Discovery - Chapter 9, View Management - Chapter 28, Image Repository for IP Products - Chapter 32, Global Server Load Balancing -
PAGE 7
Chapter 1 Brocade Network Advisor SAN + IP User Manual In this chapter The updates in this chapter are for the Brocade Network Advisor SAN + IP User Manual, part number: 53-1002949-01, published July 2013. • Chapter 4, Discovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • Chapter 9, View Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • Chapter 35, Image Repository for IP Products . . . . . . . . . . . . . . . . . . . .
PAGE 8
1 Chapter 9, View Management Mapping VCS in-band management For VCS device in-band management, you must map the VCS device WWN to the in-band management interface IP address in the DeviceWWNToIPMap text file; otherwise, discovery fails. 1. Open the in-band mapping file (DeviceWWNToIPMap.txt) in a text editor (such as, Notepad). The DeviceWWNToIPMap.txt file is located in the Install_Home/conf/discovery/ip directory. 2. Enter the in-band IP addresses you want to include in discovery.
PAGE 9
Chapter 35, Image Repository for IP Products 1 Chapter 35, Image Repository for IP Products In the section “Obtaining software files,” on page 1287, modify the third paragraph as follows: You can obtain copies of software files by downloading them from the Knowledge Portal (kp.brocade.com). Chapter 39, Global Server Load Balancing In the section “Adding a host to a zone,” on page 1413, modify the second bullet point under step 1 as follows: • ftp.brocade.
PAGE 10
1 Chapter 43, Performance Data TABLE 1 Performance statistic counters Counter name Type Protocol Source OID value Formula Uncompressed FCIP Tx/Rx MB/sec SNMP .1.3.6.1.4.1.1588.4.1.1.
PAGE 11
Chapter 43, Performance Data 1 Table 2 lists the additional counters for which you can obtain performance statistics. TABLE 2 Performance counters Counter name Type Protocol Source OID value CRC Errors FC SNMP .1.3.6.1.3.94.4.5.1.40 Signal Losses FC SNMP .1.3.6.1.3.94.4.5.1.43 Sync Losses FC SNMP .1.3.6.1.3.94.4.5.1.44 Link Failures FC SNMP .1.3.6.1.3.94.4.5.1.39 Sequence Errors FC SNMP .1.3.6.1.3.94.4.5.1.42 Invalid Transmissions FC SNMP .1.3.6.1.3.94.4.5.1.
PAGE 12
1 Chapter 44, Flow Vision Chapter 44, Flow Vision In the section, "Configuring Basic Options", on page 1587, add the following note after step 5, bullet 1: NOTE You must enter the slot number and port number. For Backbone chassis, the slot number cannot be 0 (zero). For switches, you must enter 0 (zero) as the slot number. For logical (virtual) switches, follow the rule for the physical chassis (either Backbone chassis or switch) from which you created the logical switch.
PAGE 13
Appendix A, Application menus 1 Appendix A, Application menus In the section “IP shortcut menus,” on page 1920, under the IronWare device, DCB, VCS/VDX, and Third-party device components modify the Network Objects content and add L2 Topology content as follows: Component Menu/Submenu Commands Comments Network Objects Displays the Network Objects view with the selected device highlighted. L2 Topology Displays the L2 Topology view with the selected device highlighted.
PAGE 14
1 8 Appendix E, Device Properties Brocade Network Advisor 12.1.
PAGE 15
Chapter Brocade Network Advisor SAN User Manual 2 In this chapter The updates in this chapter are for the Brocade Network Advisor SAN User Manual, part number: 53-1002948-01, published July 2013. • About this document . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 • Chapter 26, VLAN Management. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 • Chapter 29, Performance Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
PAGE 16
2 Chapter 29, Performance Data Chapter 29, Performance Data In the section “SAN historical performance data,” on page 1478, after the section “How to extract performance statistics data from the database”, add the following section: Performance statistics counters Table 1 details the formulas used to calculate performance statistics based on counter type and protocol.
PAGE 17
Chapter 29, Performance Data TABLE 1 2 Performance statistic counters Counter name Type Protocol Source OID value Formula TX% / RX% FC, GE, HBA, CNA N/A N/A TX% or RX% = ((TX or RX) / ((105000000 * port speed)* (polling interval2))) * 100 If utilization is less than 1, the value is 0.0. TX% / RX% FCIP N/A N/A TX% or RX% = ((bytes transferred) / (maximum bytes transmitted))*100 where maximum bytes transmitted = tunnel speed * 134217728 (maximum bytes transmitted 1 Gbps).
PAGE 18
2 Chapter 30, Flow Vision TABLE 2 Performance counters Counter name Type Protocol Source OID value C3 Discard Others FC SNMP .1.3.6.1.4.1.1588.2.1.1.1.27.1.28 Encode Error Out FC SNMP .1.3.6.1.4.1.1588.2.1.1.1.27.1.29 Temperature FC SNMP .1.3.6.1.4.1.1588.2.1.1.1.28.1.1.1 Voltage FC SNMP .1.3.6.1.4.1.1588.2.1.1.1.28.1.1.2 Current FC SNMP .1.3.6.1.4.1.1588.2.1.1.1.28.1.1.3 Rx Power FC SNMP .1.3.6.1.4.1.1588.2.1.1.1.28.1.1.4 Tx Power FC SNMP .1.3.6.1.4.1.1588.2.1.1.1.28.1.1.
PAGE 19
Chapter 50, Monitoring and Alerting Policy Suite 2 • ISL monitoring: Measures the traffic transmitted via an ISL to different destination domains using a 5-minute sampling rate. • Top Talker monitoring: Measures the flows that are major consumer of bandwidth on a port using a 5-minute sampling rate. In the section “Frame Monitoring Requirements,” on page 1055, change the book reference from the Fabric OS Administrator’s Guide to the Flow Vision Administrator’s Guide.
PAGE 20
2 14 Appendix H, Database Fields Brocade Network Advisor 12.1.
PAGE 21
Chapter 3 Brocade Network Advisor IP User Manual In this chapter The updates in this chapter are for the Brocade Network Advisor IP User Manual, part number: 53-1002947-01, published July 2013. • Chapter 4, Discovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • Chapter 9, View Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • Chapter 28, Image Repository for IP Products . . . . . . . . . . . . . . . . . . . . . . .
PAGE 22
3 Chapter 9, View Management Mapping VCS in-band management For VCS device in-band management, you must map the VCS device WWN to the in-band management interface IP address in the DeviceWWNToIPMap text file; otherwise, discovery fails. 1. Open the in-band mapping file (DeviceWWNToIPMap.txt) in a text editor (such as, Notepad). The DeviceWWNToIPMap.txt file is located in the Install_Home/conf/discovery/ip directory. 2. Enter the in-band IP addresses you want to include in discovery.
PAGE 23
Chapter 28, Image Repository for IP Products 3 Chapter 28, Image Repository for IP Products In the section “Obtaining software files,” on page 851, modify the third paragraph as follows: You can obtain copies of software files by downloading them from the Knowledge Portal (kp.brocade.com). Chapter 32, Global Server Load Balancing In the section “Adding a host to a zone,” on page 977, modify the second bullet point under step 1 as follows: • ftp.brocade.
PAGE 24
3 18 Appendix G, CLI Templates Brocade Network Advisor 12.1.
PAGE 25
Chapter Brocade Network Advisor Installation and Migration Guide 4 In this chapter The updates in this chapter are for the Brocade Network Advisor Installation and Migration Guide, part number: 53-1002950-01, published August 2012. • Chapter 1, Network Advisor Configuration. . . . . . . . . . . . . . . . . . . . . . . . . . . 19 • Appendix A, References . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
PAGE 26
4 Appendix A, References In the section, “Scalability limits,” on page 75, add the following note and replace Table 37 (Professional Plus-supported limits by SAN size) with the following table: Table 37 summarizes the SAN scalability limits for support with Network Advisor Professional Plus edition.
PAGE 27
Chapter Virtual Connect Enterprise Manager Server Guide 5 In this chapter The updates in this chapter are for the Virtual Connect Enterprise Manager Server Guide, part number: 53-1003019-01, published July 2013. • Virtual Connect Enterprise Manager server discovery . . . . . . . . . . . . . . . . .
PAGE 28
5 22 Virtual Connect Enterprise Manager server discovery Brocade Network Advisor 12.1.
PAGE 29
Appendix G CLI Templates In this appendix The Management application provides preconfigured Configuration templates for IronWare and Network OS devices. By default, all preconfigured templates are configure to prompt for additional targets during manual deployment. The preconfigured templates include the following: • HyperEdge – Stack Enable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • HyperEdge – Stack Disable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
PAGE 30
G CLI Templates • Network OS – Configure RX Symbol Errors Monitor . . . . . . . . . . . . . . . . • Network OS – Configure Standard L2 Access List . . . . . . . . . . . . . . . . . • Network OS – Create CoS Mutation Map. . . . . . . . . . . . . . . . . . . . . . . . . • Network OS – Create LLDP Profile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • Network OS – Create Port Profile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . • Network OS – Create Traffic Class Map . . . . .
PAGE 31
CLI Templates G • IronWare OS VLAN – Configure virtual routing interface . . . . . . . . . . . . 1392 • IronWare OS VLAN – Enable Spanning Tree Protocol on IOS VLAN . . . . 1392 • IronWare OS VLAN – Disable Spanning Tree Protocol on IOS VLAN. . . . 1393 • Network OS VLAN – VLAN Interface Creation . . . . . . . . . . . . . . . . . . . . . 1393 • Network OS VLAN – VLAN Interface Deletion . . . . . . . . . . . . . . . . . . . . . 1393 • Network OS VLAN – Layer2 Switch Port Configuration . . . . . . . . . . .
PAGE 32
G CLI Templates TABLE 1 Feature HyperEdge – Stack Enable Description HyperEdge To enable stacking mode.
PAGE 33
CLI Templates TABLE 9 Feature HyperEdge – Peri Trunk Creation Description HyperEdge To create peripheral trunks.
PAGE 34
G CLI Templates TABLE 15 Feature Description CLI Commands MCT Create a session VLAN. vlan $ name Session-VLAN tagged ethernet $ router-interface ve $ interface ve $ ip address $ MCT Create a keep–alive VLAN. vlan $ name MCT-keep-alive tagged ethernet $ MCT Create cluster configuration.
PAGE 35
CLI Templates TABLE 20 G MCT Client Deletion Feature Description CLI Commands MCT Delete a cluster client. cluster $ $ no client $ TABLE 21 MPLS – Loopback Interface Configuration Feature Description CLI Commands MPLS Loopback interface configuration used for device reachability using OSPF. It assigns an IP address and advertises the interface through OSPF.
PAGE 36
G CLI Templates TABLE 24 Network OS – Associate MAC to Port Profile Feature Description CLI Commands AMPP Associates the MAC to the existing port profile no port-profile $ activate no port-profile $ static $ no port-profile $ static $ no port-profile $ static $ port-profile $ activate port-profile $
PAGE 37
CLI Templates TABLE 27 G Network OS – Configure Inter Frame Gap Violation Fencing Feature Description CLI Commands Network OS This template is used to configure high threshold value to fence an interface when Inter Frame Gap(IFG) minimum length (typical value is 12) violation occurs. Possible values for timebase are day, hour, minute and none.
PAGE 38
G CLI Templates TABLE 30 Feature Description CLI Commands Network OS This template is used to configure threshold and alert values for RX Symbol Errors Monitoring. Possible values for timebase are day, hour, minute and none. Buffer value cannot be more than average of high plus low threshold. Supported Values for High and Low Threshold Action Parameters are email, raslog, all, and none.
PAGE 39
CLI Templates TABLE 34 Network OS – Create Port Profile Feature Description CLI Commands AMPP Creates the port profile and its sub profile.
PAGE 40
G CLI Templates TABLE 38 Feature Description CLI Commands AMPP Removes the port profile. no port-profile $ activate no port-profile $ TABLE 39 Network OS – Update ACL on Port Profile Feature Description CLI Commands AMPP Adds a security profile to a port profile.
PAGE 41
CLI Templates TABLE 43 Private VLAN – Delete PVLAN configuration from VLAN Feature Description CLI Commands VLAN To remove PVLAN type from VLAN interface. interface vlan $ no private-vlan TABLE 44 Private VLAN – Associate Secondary VLAN with Primary VLAN Feature Description CLI Commands VLAN To associate secondary VLAN with primary VLAN.
PAGE 42
G CLI Templates TABLE 49 Feature Description CLI Commands VLAN To assign Primary Vlan to Promiscuous port. This command also maps a Promiscuous port to selected secondary VLANs.
PAGE 43
CLI Templates TABLE 55 Private VLAN – Display private VLAN Configuration Feature Description CLI Commands VLAN To display the private vlan status. show vlan private-vlan TABLE 56 VRF – VRF Creation Feature Description CLI Commands VRF To create VRF in specific RBridge. rbridge-id $ vrf $ TABLE 57 VRF – VRF Deletion Feature Description CLI Commands VRF To delete VRF from specific RBridge.
PAGE 44
G CLI Templates TABLE 62 Feature Description CLI Commands VLAN To display the VRF details. show vrf detail show vrf rbridge-id $ show vrf $ TABLE 63 IronWare OS VLAN – Remove interfaces from VLAN as untagged Feature Description CLI Commands VLAN To remove interfaces from the VLAN as untagged.
PAGE 45
CLI Templates TABLE 71 IronWare OS VLAN – Disable Spanning Tree Protocol on IOS VLAN Feature Description CLI Commands VLAN To disable spanning tree protocol on VLAN. vlan $ no spanning-tree TABLE 72 Network OS VLAN – VLAN Interface Creation Feature Description CLI Commands VLAN To create a VLAN Interface. interface vlan $ TABLE 73 Network OS VLAN – VLAN Interface Deletion Feature Description CLI Commands VLAN To delete a VLAN Interface.
PAGE 46
G CLI Templates TABLE 78 Feature Description CLI Commands VLAN To disable native VLAN from a trunk interface. interface tengigabitethernet $ no switchport trunk native-vlan $ TABLE 79 Network OS VLAN – Access Interface Configuration Feature Description CLI Commands VLAN To configure the interface as an access interface.
PAGE 47
Appendix H Database Fields In this appendix • Database tables and fields. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1329 • Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1511 Database tables and fields NOTE The primary keys are marked by an asterisk (*) TABLE 83 ACH_CALL_CENTER Field Definition Format ID * Unique generated database identifier. int NAME Name of the Call Center.
PAGE 48
H Database tables and fields TABLE 85 Definition Format Size TYPE Type of the event. varchar 256 CONTRIBUTOR_PATTERN Indicates the Contributor pattern to be used for searching the event contributor in event description. In some cases, FOS uses same message id for different events (e.g MAPS events). To increase the filtering capability of Call Home events, this contributor pattern string is used along with message id.
PAGE 49
H Database tables and fields TABLE 90 ADAPTER_DRIVER_FILE_DETAILS Field Definition Format ID Unique generated database identifier.
PAGE 50
H Database tables and fields TABLE 95 Field Definition Format AOR_ID ID of AOR int HOST_ID HOST ID which is in the AOR int TABLE 96 Definition Format AOR_ID ID of AOR int PORT_GROUP_ID IP of port group int Definition Format AOR_ID The column holds ID of an AOR. It is Foreign Key and refers to ID column of AOR table int VIP_SERVER_ID The column holds ID of VIP Server.
PAGE 51
H Database tables and fields TABLE 99 BIRTREPORT_PARAMETER (Continued) Field Definition Format DATA_TYPE Data type of the parameter. Possible values are: • 1 - String • 2 - Float • 3 - Decimal • 4 - Date and Time • 5 - Boolean • 6 - Integer • 7 - Date • 8 - Time int PARAMETER_VALUE Value of the Parameter. varchar 256 Size TABLE 100 Size BIRTREPORT_RUN_TEMPLATE Field Definition Format ID The primary key of the table.
PAGE 52
H Database tables and fields TABLE 102 Field Definition Format ID Unique generated database identifier.
PAGE 53
H Database tables and fields TABLE 106 CARD (Continued) Field Definition Format Size STATE State of the blade, such as ENABLED or DISABLED. varchar 32 POWER_STATE State of power supply to the blade. varchar 16 varchar 32 ATTN_STATE SERIAL_NUMBER Factory serial number of the blade. varchar 32 PART_NUMBER The part number assigned by the organization responsible for producing or manufacturing the blade. varchar 32 TRUNKING_SUPPORTED 1 = trunking is supported on this blade.
PAGE 54
H Database tables and fields TABLE 106 Definition Format HEADER_VERSION The OEM or vendor-assigned version number. int GIGE_MODE Determines the port operating mode for GE ports. 0 - 1G 1 - 10G 2 - Dual mode 3 - Failover mode Default value -1 means it is not applicable. smallint TABLE 107 • • • • 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.
PAGE 55
H Database tables and fields TABLE 111 CEE_PORT (Continued) Field Definition Format IF_INDEX Interface index int IF_NAME Interface name varchar 256 IF_MODE Gige port mode (L2, L3, none) varchar 8 L2_MODE L2 mode (hybrid, trunk, access) varchar 32 VLAN_ID List of VLAN this port belongs to text LAG_ID LAG ID this port belongs to int IP_ADDRESS Port''s configured IP address varchar 128 MAC_ADDRESS Port''s MAC address varchar 64 PORT_SPEED Speed in Gb/sec.
PAGE 56
H Database tables and fields TABLE 113 Definition Format Size ENTITY_CATEGORY Holds the type of the entity to whom the column name belongs to like Port, Fabric, IPProduct, VCSInterface, etc' varchar 128 COLUMN_INDEX Used to differentiate user defined columns and static columns. For static it is 0 and for user defined columns it is 1,2,3. small int DESCRIPTION Holds description of the column. varchar ICON_ID Holds Icon Id for the column. Currently it is unused.
PAGE 57
H Database tables and fields TABLE 118 CNA_ETH_PORT Field Definition Format ID ID of the Eth port int ETH_DEV Ethernet device varchar ETH_LOG_LEVEL Log level for the Ethernet device. Possible values are 0 - Log Invalid 1 - Log Critical 2 - Log Error 3 - Log Warning 4 - Log Info int NAME Name of the port varchar 256 MAC_ADDRESS MAC Address varchar 64 IOC_ID IO controller ID. The default value is 0.
PAGE 58
H Database tables and fields TABLE 120 Definition Format Size MAX_BANDWIDTH Maximum guaranteed bandwidth. Value will be in Gbps (1 to 10). varchar 64 MIN_BANDWIDTH Minimum guaranteed bandwidth. Value will be in Gbps (0 to 10). int PORT_NUMBER Physical port number of adapter. int PORT_TYPE Type of this port. For example, ETH. varchar CREATION_TIME Creation time of this DB record. timestamp CONFIGURATION_STATUS Indicates current configuration status of the port.
PAGE 59
H Database tables and fields TABLE 123 COLLECTOR_MIB_OBJECT_ENTRY Field Definition Format COLLECTOR_MIB_OBJECT_ ENTRY_ID Primary key autogenerated ID. int COLLECTOR_ID ID of the PERF_COLLECTOR. int MIB_OBJECT_ID MIB_OBJECT table DB ID. int TABLE 124 COLLECTOR_SNMP_EXPRESSION_ENTRY Field Definition Format COLLECTOR_SNMP_EXPRE SSION_ENTRY_ID Primary key autogenerated ID. int COLLECTOR_ID ID of the PERF_COLLECTOR. int EXPRESSION_ID Id of the SNMP_EXPRESSION.
PAGE 60
H Database tables and fields TABLE 126 1342 CORE_SWITCH (Continued) Field Definition Format REACHABLE Determines whether the switch is reachable from the Management application. 1 is reachable and 0 is unreachable smallint UNREACHABLE_TIME Time when the switch becomes unreachable. timestamp OPERATIONAL_STATUS Chassis operational status like FRU, Power Supply etc.. varchar CREATION_TIME Core switch record creation time. This tells us when the intial discovery has happened.
PAGE 61
H Database tables and fields TABLE 126 CORE_SWITCH (Continued) Field Definition Format Size NAT_PRIVATE_IP_ADDRESS NAT private IP Address. Feature available from NMS DC Eureka release onwards. During a successful NAT translation the Private IP that gets translated will be stored in this field. The new translated IP Address will be stored in the existing IP_ADDRESS field. All the NAT look up will be done using the NAT Private IP Address.
PAGE 62
H Database tables and fields TABLE 130 CORE_SWITCH_DETAILS (Continued) Field Definition Format Size FC_MASK FC IP Address ethernet mask. char 64 FC_IP Fibre Channel IP address. char 64 FC_CERTIFICATE FC IP Address. smallint SW_LICENSE_ID License ID of the chassis. char 23 SUPPLIER_SERIAL_ NUMBER Supplier serial number for the switch. varchar 32 PART_NUMBER Partnumber of the switch varchar 32 CHECK_BEACON Denotes if Switch Beacon is enabled or not on the switch.
PAGE 63
H Database tables and fields TABLE 130 CORE_SWITCH_DETAILS (Continued) Field Definition Format Size 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. varchar 32 SNMP_INFORMS_ENABLED Flag to denote whether SNMP informs option in the switch is enabled or disabled. Default value is 0.
PAGE 64
H Database tables and fields TABLE 132 CRYPTO_LUN Field Definition Format ID Unique generated database identifier. int CRYPTO_TARGET_CONTAI NER_ID Foreign key reference to the CRYPTO_TARGET_CONTAINER that contains the host for which these LUNs are configured. int SERIAL_NUMBER The LUN serial number, used to identify the physical LUN. varchar ENCRYPTION_STATE Boolean. • True (1) if LUN is being encrypted. • False (0) if cleartext. The default value is 0.
PAGE 65
H Database tables and fields TABLE 132 CRYPTO_LUN (Continued) Field Definition Format DECRYPT_EXISTING_DATA Not used. When configuring disk LUN that was previously encrypted and is to become cleartext, this property tells the switch whether or not to start a re-keying operation to decrypt the existing LUN data. This property does not need to be persisted. This feature is no longer supported in FOS. smallint KEY_ID Hex-encoded binary key vault ID for the current data encryption key for this LUN.
PAGE 66
H Database tables and fields TABLE 132 Definition Format Size NEW_LUN_TYPE This field indicates the role of the LUN configured in the SRDF mode. The values could be R1, R2 or UNKNOWN. Feature available only from 6.4 release onwards and for RSA key vaults. CryptoLuncollector fills in this value. varchar 64 DISABLE_WRITE_EARLY_A CK This variable indicates whether write early acknowledgement is enabled (if value is 0) or disabled (if value is 1).
PAGE 67
H Database tables and fields TABLE 133 CRYPTO_SWITCH (Continued) Field Definition Format PRIMARY_VAULT_LINK_ STATUS The status of the link key for the primary key vault. Link keys are used only for NetApp LKM key vaults. For possible values, see the enum definition in the DTO class. Default value is 0. smallint BACKUP_VAULT_LINK_ STATUS The status of the link key for the backup key vault. Link keys are used only for NetApp LKM key vaults.
PAGE 68
H Database tables and fields TABLE 134 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. smallint DEVICE_STATUS The physical target storage device operational status when the virtual initiator last attempted to access the target.
PAGE 69
Database tables and fields TABLE 136 DASHBOARD (Continued) Field Definition Format CREATION_TIME Time when dashboard was created. timestamp LAST_OPENED_TIME Time when dashboard was last opened. timestamp TABLE 137 H Size DASHBOARD_CANVAS Field Definition Format ID Dashboard Canvas ID. int NAME Name of the Dashboard canvas. varchar 128 DESCRIPTION Description of the dashboard canvas.
PAGE 70
H Database tables and fields TABLE 139 Definition PROVIDER_GROUP The Group to which the Provider belong to. varchar Similar providers will have same group name. PROVIDER_ORDER The order of execution passed to the Job Executor framework. Provider belong to same group will have different order number. Default: 0 TABLE 140 1352 DASHBOARD_PROVIDER Field Format Size 128 int DASHBOARD_WIDGET Field Definition Format Size ID ID of the dashboard widget. Auto incremented.
PAGE 71
H Database tables and fields TABLE 140 DASHBOARD_WIDGET (Continued) Field Definition Format installation_type Indicates the widgets is SAN Only (0) / IP Only (1) / SAN_IP (2)' int shared_provider Can the provider be shared? 0 - Not Shared 1 - Shared. int TABLE 141 Size DASHBOARD_WIDGET_PREFERENCE Field Definition Format ID Auto incremented widget preference ID. int WIDGET_ID Foreign Key to DASHBOARD_WIDGET(ID). int USER_ID Foreign Key to USER_ (ID).
PAGE 72
H Database tables and fields TABLE 142 Definition Format Size MAIN_MEASURE The Additional measures based on the FAVORITE.MAIN_MEASURE varchar 40 ADDITIONAL_MEASURE The Additional measures based on the FAVORITE.MAIN_MEASURE int TABLE 143 DEFAULT_WIDGET_PREFERENCE Field Definition Format ID Auto incremented Dashboard Widget Preference ID. int dashboard_id Foreign Key to DASHBOARD(ID). int widget_id Foreign Key to DASHBOARD_WIDGET(ID).
PAGE 73
H Database tables and fields TABLE 144 DEPLOYMENT_CONFIGURATION (Continued) Field Definition Format SNAPSHOT_ENABLED 1 indicates that snapshot is applied to the configuration smallint CLI_TEMPLATE_ID Identifies the CLI template details.
PAGE 74
H Database tables and fields TABLE 146 Definition Format PRODUCT_ID This record will be per product. Hence this will have the id of the product. int PRODUCT_TYPE_ID Foreign Key references TARGET_TYPE(id). This identifies the PRODUCT_ID. (Whether it is switch, device, etc). int STATUS Indicated the product deployment status 1-Aborted 2-Succesful 3-Partial Failure 4-Failed smallint MESSAGE Message to be displayed in the report.
PAGE 75
H Database tables and fields TABLE 148 DEPLOYMENT_TARGET_MAP (Continued) Field Definition Format TARGET_TYPE_ID Foreign Key references TARGET_TYPE (id) Identifies the target type int TARGET_PARENT_ID Identifies the parent of the target. If, switch, device, port group, device group it will be same as target id. If it is port/interfaces the parent id will be the switch id int TABLE 149 Size DEVICE Field Definition Format DEVICE_ID Primary key for this table.
PAGE 76
H Database tables and fields TABLE 149 DEVICE (Continued) Field Definition Format Size IS_SLB Flag to identify whether the device supports server load balancing or not. num (1,0) varchar 64 varchar 64 LAST_PROBE_TIME varchar 64 LAST_PROBE_STATUS varchar 64 FIRST_SEEN_TIME LAST_SEEN_TIME 1358 Time when the device is getting discovered by recent collection. IS_SFLOW_CAPABLE Flag to identify whether the device is SFlow capable or not.
PAGE 77
H Database tables and fields TABLE 149 DEVICE (Continued) Field Definition Format Size TACPLUS_USERNAME_READ_ONL Y TACACS+ username for read only access. varchar 512 TACPLUS_PASSWORD_READ_ONL Y TACACS+ password for read only access. varchar 512 ENABLE_PASSWORD_PORT_CFG Enable password configured in device used for port configuration. varchar 512 ENABLE_PASSWORD_READ_ONLY Enable password for read only access. varchar 512 ADMIN_STATUS Device admin status.
PAGE 78
H Database tables and fields TABLE 149 DEVICE (Continued) Field Definition Format PORT_COUNT Record the number of presented physical ports on the device. int SERIAL_NUMBER Record the serial number of the device. If there is no serial number, an empty string will be stored.
PAGE 79
H Database tables and fields TABLE 149 DEVICE (Continued) Field Definition Format POE_CAPABLE The POE capability of device. Possible values are: • 0 = POE is not supported by this device • 1 = POE is supported with IEEE 802.3af standard by this device • 2 = POE plus is supported with IEEE 802.3at standard by this device smallint CLUSTER_MODE This column is used to determine whether VCS Cluster is in Standalone mode or Cluster mode.
PAGE 80
H Database tables and fields TABLE 149 Definition Format IS_PRINCIPAL_SWITCH This column is used to determine whether VCS member is a Principal switch or not. Value 1 indicates that this is a principal switch and 0 indicates that this not a Principal switch. The values will be populated by the VCS collector during the discovery of the VCS switch. The default value of 0 means that its a principal switch.
PAGE 81
H Database tables and fields TABLE 150 DEVICE_ENCLOSURE (Continued) Field Definition Format ICON Type of Icon. int OS Operating System. varchar 256 APPLICATIONS Application which created device enclosure. varchar 256 DEPARTMENT Department using this device enclosure. varchar 256 CONTACT Contact person details. varchar 256 LOCATION Location of physical setup. varchar 256 DESCRIPTION Description if any. varchar 256 COMMENT_ Comments if any.
PAGE 82
H Database tables and fields TABLE 150 Definition VIRTUALIZATION smallint If this enclosure is a host, this column indicates whether the host is running a virtualization hypervisor. 0 = unknown 1 = no supported hypervisor present 2 = VMware ESX 3 = Microsoft Hyper-V. Default value is 0. MANAGED_ELEMENT_ID A unique managed element ID for a managed host.If the device enclosure is manually created (does not represent a managed host) then the field is null.
PAGE 83
H Database tables and fields TABLE 152 DEVICE_FDMI_DETAILS (Continued) Field Definition Format Size MODEL_DESCRIPTION Holds the model description of the device available via FDMI, ex : Brocade-825 varchar 64 NODE_NAME Holds the node name of the device available via FDMI, ex : 20:00:00:05:1e:7c:64:94 varchar 64 TABLE 153 DEVICE_GROUP Field Definition Format DEVICE_GROUP_ID Primary key for this table. int NAME Name of this device group.
PAGE 84
H Database tables and fields TABLE 155 DEVICE_NODE (Continued) Field Definition Format Size TYPE Initiator or target or both or unknown. The possible values are Initiator, Target, Initiator+Target, Unknown(Initiator or Target) varchar 32 DEVICE_TYPE 0 = physical 1 = virtual 2 = NPV 3 = iSCSI 4 = both physical & virtual smallint SYMBOLIC_NAME Device node symbolic name. varchar 256 FDMI_HOST_NAME Device node FDMI host name. varchar 128 VENDOR Device node vendor.
PAGE 85
H Database tables and fields TABLE 156 DEVICE_PORT Field Definition Format Size PORT_ID Stores the FDMI host name. varchar 6 TYPE Stores the Vendor of this device. varchar 32 SYMBOLIC NAME Stores the Symbolic Name. varchar 256 varchar 64 varchar 16 varchar 63 32 FC4_TYPE COS Stores the Class of Service. IP_PORT HARDWARE_ADDRESS Stores the Hardware Address. varchar TRUSTED Denotes if the device port is trusted or not. smallint CREATION_TIME The creation time of this record.
PAGE 86
H Database tables and fields TABLE 157 Definition Format VIRTUAL_FCOE_PORT_ID The value of virtual_fcoe_port_id in the Device_Port_Gige_Port_Link table is applicable only for NOS devices. For FOS devices, the virtual_fcoe_port_id value, will be null, as currently in the Management application that mapping data is not collected. Hence the default value is null. int LAG_ID LAG interface ID which associates port channel with end device.
PAGE 87
H Database tables and fields TABLE 159 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 Decru LKM key vaults. varchar 4096 EE_STATE The operational status of this Encryption Engine. For possible values, see the enum defintion in the DTO class The default value is 0.
PAGE 88
H Database tables and fields TABLE 160 ENCRYPTION_GROUP (Continued) Field Definition Format DEPLOYMENT_MODE Indicates Transparent (0) or NonTransparent (1) deployment mode. Only Transparent mode is currently supported. All switches in the Encryption Group share the same deployment mode. Transparent mode uses re-direction zones to preserve existing zoning of physical hosts and targets.
PAGE 89
H Database tables and fields TABLE 160 ENCRYPTION_GROUP (Continued) Field Definition Format PRIMARY_KEY_VAULT_ID Foreign key reference to the KEY_VAULT record that describes the primary key vault for this Encryption Group. Null if no primary key vault is configured. int BACKUP_KEY_VAULT_ID Foreign key reference to the KEY_VAULT record that describes the backup key vault for this Encryption Group. Null if no backup key vault is configured.
PAGE 90
H Database tables and fields TABLE 163 ENCRYPTION_TAPE_POOL Field Definition Format ID Unique generated database identifier. int SWITCH_ID No longer used. Tape pools used to belong to specific switches, but are now shared by all switches in an encryption group int ENCRYPTION_ENGINE_ID No longer used.
PAGE 91
H Database tables and fields TABLE 166 ETHERNET_ISL (Continued) Field Definition Format MISSING Flag to identify whether the ethernet isl link is missing from the switch. smallint, MISSING_TIME Time when the ethernet isl link is missing from the switch. timestamp TRUSTED Is this ethernet isl link is trusted. smallint, CREATION_TIME Time when the ethernet isl link record is created.
PAGE 92
H Database tables and fields TABLE 167 EVENT (Continued) Field Definition Format ACKED_TIME Indicates the timestamp when the event was acknowledged. Timestamp FIRST_OCCURRENCE_HOST Indicates the the Management application server _TIME timestamp when the event occurred for the first time. timestamp 10 EVENT_AUDIT 'Indicates whether this is an audit event or not. varchar 255 EVENT_KEY Unique key for the event.
PAGE 93
H Database tables and fields TABLE 171 EVENT_DETAILS Field Definition Format ID Unique generated database identifier. int EVENT_ID Database ID of the EVENT instance. int FIRST_OCCURRENCE_SWI TCH_TIME Indicates the first occurrence switch timestamp of the event. timestamp LAST_OCCURRENCE_SWIT CH_TIME Indicates the last occurrence switch timestamp of the event. timestamp CONTRIBUTORS Indicates the contributing factor for the event resulted due to a status change of the switch.
PAGE 94
H Database tables and fields TABLE 172 Definition Format Size 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. 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. The default value is 0.
PAGE 95
H Database tables and fields TABLE 174 EVENT_PROCESSOR_MAP Field Definition Format Size PROCESSOR_CLASS_NA ME The fully qualified processor class name which will be invoked for the corresponding event id in this table. Column added as part of the Event Processing Framework varchar 1024 EVENT_ID The Event Id is the Trap OID on which the corresponding processor needs to act up on .
PAGE 96
H Database tables and fields TABLE 175 Definition Format LAST_MODIFIED_TIME Rules last edited time. timestamp SELECTED_TIME_UNIT Timestamp unit of the selected rule: • 0 = second • 1 = Minutes • 2 = Hours Default value is 1. smallint Field Definition Format ID* Unique generated database identifier. int SAN_ID Foreign key to SAN table; usually 1 since there is only one SAN. int SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to discover the fabric.
PAGE 97
H Database tables and fields TABLE 176 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.
PAGE 98
H Database tables and fields TABLE 177 Field Definition Format FABRIC_ID * Fabric ID, foreign key to the FABRIC table. int CHECKSUM_KEY * Type of checksum, e.g. device data or zone data. varchar 32 CHECKSUM Actual checksum value. varchar 16 Size TABLE 178 Size FABRIC_COLLECTION Field Definition Format FABRIC_ID * Fabric ID, foreign key to the FABRIC table. int COLLECTOR_NAME * Name of the collector, e.g.
PAGE 99
H Database tables and fields TABLE 181 FABRIC_VCS_CLUSTER_MAP Field Definition Format FABRIC_ID Foreign key to ID in fabric table. int VCS_CLUSTER_ME_ID Foreign key to ID in ManagedElement table. This is the VCS cluster entry managed_element_id reference. int TABLE 182 FABRIC_ZONING_EDIT_RESTRICTION Field Definition Format ID Unique generated database identifier.
PAGE 100
H Database tables and fields TABLE 183 FAVORITES (Continued) Field Definition Format CUSTOM_SELECTION_OBJE CT_TYPE Represents the selected filter type. • 0 - Default favorite • 1 - FC Ports • 2 - Device Ports • 3 - ISL Ports • 4 - 10GE Ports • 5 - FCIP Tunnels • 6 - EE Monitors Selected member identifiers are stored in CUSTOM_FAVORITES_OBJECT_LIST table if this favorite is not default. int PLOT_EVENTS Indicates whether the PM historical chart should overlay the events on the graph.
PAGE 101
H Database tables and fields TABLE 186 FCIP_TUNNEL (Continued) Field Definition Format WAN_TOV_ENABLED Is WAN TOV enabled. Default value is 0. smallint TUNNEL_STATUS Tunnel Status (Active/Inactive). int DESCRIPTION Description for the created tunnel. varchar FICON_TRB_ID_ENABLED Whether Ficon_Tape_Read_Block is enabled on that tunnel. Default value is 0. smallint FICON_TT_EMUL_ENABLED Whether Ficon_Tin_Tir_Emulation is enabled on that tunnel. Default value is 0.
PAGE 102
H Database tables and fields TABLE 186 1384 FCIP_TUNNEL (Continued) Field Definition Format CDC CDC Flag. Default value is 0. smallint ADMIN_STATUS Admin Status of the Tunnel. Default value is 0. smallint CONTROL_L2_COS Class of service as defined by IEEE 802.1p for tunnel. int Default value is -1. DSCP_CONTROL DiffServe marking for control frame. Default value is -1. int TRUNKING_ALGORITHM Trunking Algorithm. Default value is -1.
PAGE 103
H Database tables and fields TABLE 186 FCIP_TUNNEL (Continued) Field Definition Format QOS_HIGH QoS high value. smallint QOS_MEDIUM QoS medium value. smallint QOS_LOW QoS low value. smallint BACKWARD_COMPATIBLE Whether the 10G tunnel is backward compatible with previous FOS versions. smallint FICON_TERADATA_READ_E NABLED Whether Ficon_Teradata_Read_Pipelining is enabled on that tunnel.
PAGE 104
H Database tables and fields TABLE 187 1386 FCIP_TUNNEL_CIRCUIT (Continued) Field Definition Format MIN_COMM_RATE Minimum communication int Speed. The default value is 0. MAX_COMM_RATE Maximum communication int Speed. The default value is 0. MIN_RETRANSMIT_TIME Minimum Retransmission Time. The default value is -1 int MAX_RETRANSMIT_TIME Maximum retransmission time. The default value is -1 int KEEP_ALIVE_TIMEOUT Keep Alive timeout.
PAGE 105
H Database tables and fields TABLE 187 FCIP_TUNNEL_CIRCUIT (Continued) Field Definition Format Size CIRCUIT_STATUS_STRING Circuit Status string value from switch for the tunnel varchar 256 L2COS_F_CLASS The default value is 0. smallint L2_COS_HIGH The default value is 0. smallint L2_COS_MEDIUM The default value is 0. smallint L2_COS_LOW The default value is 0. smallint DSCP_F_CLASS The default value is 0. smallint DSCP_HIGH The default value is 0.
PAGE 106
H Database tables and fields TABLE 188 Definition Format RX_UTILIZATION The computed value of RX based on speed of port double precision DROPPED_PACKETS Number of TCP packets dropped double precision COMPRESSION Compression ratio bigint LATENCY Round trip time (latency) in milliseconds int LINK_RETRANSMITS Number of segments retransmitted double precision RTT_BY_TIME_OUT Counter of retransmit packets due to timeout double precision RTT_BY_DUP_ACK Counter of retransmit packets due to
PAGE 107
H Database tables and fields TABLE 191 FEATURE 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. varchar 256 Size TABLE 192 FEATURE_EDITION_MAP Field Definition Format FEATURE_ID* ID used to uniquely identify the feature. int EDITION_MASK Used to associate a feature to the edition (Reserved for future).
PAGE 108
H Database tables and fields TABLE 195 Field Definition Format ID* Unique generated database identifier. int FIRMWARE_NAME Name of the firmware file. varchar MAJOR_VERSION Major version bit from the firmware version. smallint MINOR_VERSION Minor version bit from the firmware version. smallint MAINTENANCE Maintenance bit from the firmware version. smallint PATCH Patch bit from the firmware version. varchar 64 PHASE Phase bit from the firmware version.
PAGE 109
H Database tables and fields TABLE 197 FOUNDRY_DEVICE (Continued) Field Definition Format Size IS_PORT_VLAN_ENABLED 'Port VLANs enabled for the product or not. num (1,0) ARCHITECTURE_TYPE Chassis architecture type. Refer snChasArchitectureType MIB in foundry.mib for possible values. num (2,0) BUILD_LABEL The image label of the built software. varchar 64 SSL_SLOT Slot number of the SSL module.
PAGE 110
H Database tables and fields TABLE 200 FOUNDRY_PHYSICAL_PORT (Continued) Field Definition Format MEDIA_TYPE The media type for the port. Refer snSwPortInfoMediaType of foundry.mib for more details and possible values. smallint GIG_TYPE TABLE 201 smallint FPORT_TRUNK_GROUP Field Definition Format ID* Unique generated database identifier. int VIRTUAL_SWITCH_ID Virtual switch ID where this F_Port Trunk Group is defined.
PAGE 111
H Database tables and fields TABLE 203 FRU (Continued) Field Definition Format Size 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 values filled in by Switch Asset Collector. Maps to IsRemovable field in the html. The default value is -1.
PAGE 112
H Database tables and fields TABLE 204 FTP_SERVER Field Definition Format ID* int TYPE Type indicates the what type of file. Internal FTP - 0, External FTP - 1, External SCP - 2, Internal SCP/SFTP 3, External SFTP - 4 and Technical support FTP - 100. Technical Support FTP server configuration is created by user to transfer the technical support files from the Management application repository to specified FTP server. Other server configurations can be seen in Options dialog.
PAGE 113
H Database tables and fields TABLE 206 GIGE_PORT (Continued) Field Definition Format FCIP_CAPABLE 1 = FCIP capable; otherwise, 0. Default value is 2. smallint ISCSI_CAPABLE 1 = ISCSI capable; otherwise, 0. Default value is 2. smallint REMOTE_MAC_ADDRESS MAC address of attached port of the 10G GigE Port. varchar INBAND_MANAGEMENT_ST ATUS 1 = Inband Management status is enabled; otherwise, 0. Default value is 0. smallint OCCUPIED Default value is 0.
PAGE 114
H Database tables and fields TABLE 209 Field Definition Format GLOBAL_VLAN_DB_ID Unique database generated identifier. int NAME Name for Global VLAN. varchar CONTEXT_DEVICE_ID Database ID of the DEVICE instance which is associated with global VLAN. int TABLE 210 Definition Format INTERFACE_ID This column is used to store the id of the interface. The value will be populated by the discovery engine where the corresponding GRE Tunnel Interface details will be persisted in the INTERFACE table.
PAGE 115
Database tables and fields TABLE 212 H HBA (Continued) Field Definition Format Size USERNAME User name to be used for logging into the HBA. varchar 256 PASSWORD Password used for logging into the HBA varchar 256 MANAGEMENT_STATE Management state bit mask, Managed/Auth failed etc. The default value is -1. int MANAGEMENT_INTERFACE Management interface bit mask, JSON/WMI/SMI etc . The default value is -1.
PAGE 116
H Database tables and fields TABLE 212 1398 HBA (Continued) Field Definition Format Size CARD_TYPE FC for HBA, CNA for CNA. The default value is ‘FC’. varchar 32 WWN WWN of the adapter varchar 23 HCM_AGENT_VERSION Version of HCM agent used to managed the HBA varchar 128 MAC_ADDRESS Adapter mac address varchar 64 MAX_SPEED_SUPPORTED The maximum port speed that is supported on the port, in Gb/s. The default value is 0.
PAGE 117
H Database tables and fields TABLE 213 HBA_NODE_MAP Field Definition Format DEVICE_NODE_ID Primary key from the Device Node table int HBA_ID Primary key from the HBA table int TABLE 214 Size HBA_PORT Field Definition Format DEVICE_PORT_ID Primary key on the owner Device port table int CONFIGURED_STATE Indicates whether the port is enabled or disabled. The default value is 0. smallint CONFIGURED_SPEED The configured speed of the port. E.g.
PAGE 118
H Database tables and fields TABLE 214 HBA_PORT (Continued) Field Definition Format FACTORY_NODE_WWN Factory configured Node WWN defined for the HBA port in HCM varchar PREBOOT_CREATED Flag to identify vports created during preboot varchar MAX_BANDWIDTH Maximum bandwidth varchar 64 PCIF_INDEX Pci function index varchar 64 MAX_PCIF Maximum number of Pci functions. smallint Synthetic FC is applicable for Windows only: 0 - Unknow 1 - Yes 2 - No.
PAGE 119
H Database tables and fields TABLE 215 HBA_PORT_DETAIL (Continued) Field Definition Format QUEUE_DEPTH The number of I/O operations that can be run in parallel on a device. The default value is 0. int Indicates whether interrupt control is on or off. The default value is 0. smallint Sets the interrupt control latency value.. The default value is 0. int Sets the interrupt control delay value.. The default value is 0. int BEACON_STATE Indicates whether beaconing is on or off..
PAGE 120
H Database tables and fields TABLE 215 HBA_PORT_DETAIL (Continued) Field Definition Format QOS_CONFIGURED_STATE Indicates whether QoS is enabled or disabled. The default value is 0. smallint QOS_OPERATING_STATE QOS Operating state. The default value is 'Disabled'. varchar 256 QOS_TOTAL_BB_CREDIT The number of receive buffers. The default value is 2. varchar 16 QOS_PRIORITY_LEVEL QoS priority levels.
PAGE 121
H Database tables and fields TABLE 216 HBA_PORT_DEVICE_PORT_MAP Field Definition Format DEVICE_PORT_ID ID from the device_port table. int HBA_PORT_ID DEVICE_PORT_ID from the hba_port table. int TABLE 217 Size HBA_PORT_FCOE_DETAILS Field Definition DEVICE_PORT_ID Format Size int BANDWIDTH The bandwidth percentage of the FCoE port eg. 10 gb for CNA. int FIP_STATE FIP (Fibre channel Initialization Protocol) state of the port 0 – disable , 1- enabled.
PAGE 122
H Database tables and fields TABLE 217 Definition Format Size SUPPORTED_CLASS The classes supported on the FCoE port. For example, Class2 and Class3. varchar 256 TRL_SPEED TRL (Target Rate limit) speed. This will be less than max speed supported by this port. int TRL_STATE TRL (Target Rate limit) state of the port. Possible values are 0 - disable , 1 - Enable smallint PG_ID The priority group ID. Possible values are 0-7 (user-definable) and 15.0-15.7 (strict priority).
PAGE 123
H Database tables and fields TABLE 218 HBA_REMOTE_PORT (Continued) Field Definition Format Size CURRENT_SPEED Current speed of the remote port, as enforced by TRL. The default value is 0. varchar 64 TRL_ENFORCED True if TRL(Target Rate limit) is enforced. varchar 16 BUS_NO Channel number in the PCI Bus. The default value is 0. varchar 32 FCP_IM_STATE Indicates whether the Fibre Channel Protocol Input Method (FCP-IM) is online or offline.
PAGE 124
H Database tables and fields TABLE 219 Definition Format size 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.
PAGE 125
H Database tables and fields TABLE 221 HOST_DISCOVERY_OPTION (Continued) Field Definition Format CIM_IMPL CIM implemenation used. 1: SMI, 2: WMI. The default value is 0. smallint CIM_USERNAME Username for the CIM based agent varchar 128 CIM_PASSWORD Password for the CIM based agent' varchar 512 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.
PAGE 126
H Database tables and fields TABLE 224 IFL Field Definition Format ID* Primary key for this table. Serial number which is uniquely generated by DB. int EDGE_FABRIC_ID Edge fabric ID of this IFL link. int EDGE_PORT_WWN Edge switch port wwn of this IFL link. varchar BB_FABRIC_ID Backbone fabric ID of this IFL link. int BB_PORT_WWN Backbone fabric switch port wwn of this IFL link. varchar BB_RA_TOV Backbone fabric resource allocation time out value specified in milliseconds.
PAGE 127
H Database tables and fields TABLE 226 INTERFACE (Continued) Field Definition Format Size LLDP_PORT_ID_SUBTYPE smallint LLDP_PORT_ID bytea IS_FDP_ENABLED num (1,0) IS_CDP_ENABLED num (1,0) PORT_STATUS smallint PORT_STATE smallint IF_INDEX This column is used to store the ifIndex of the interface. The value will be populated by the DCB collector during the discovery of the DCB switch. Since this value is not populated by IP discovery engine, making the field as nullable.
PAGE 128
H Database tables and fields TABLE 228 Definition Format Size NET_MASK Subnet mask for the interface. varchar 64 MTU_SIZE MTU Size for that interface. int CHECKSUM Check Sum. varchar GIGE_PORT_TYPE Whether the IP interface is created on a 10G cross port or not. Non-zero value denotes a cross port. smallint TABLE 229 64 IP_PORT_GROUP Field Definition Format PORT_GROUP_ID Unique database generated identifier. int NAME Name for Port group.
PAGE 129
H Database tables and fields TABLE 232 IPX_NETWORK_VLAN Field Definition Format VLAN_DB_ID Database ID of the VLAN instance which is associated with the IPX network. int NETWORK_NUMBER Number for IPX network. varchar 32 FRAME_TYPE Frame type for IPX. Possible values are 0-Not Applicable, 1-802.2, 2-802.3, 3-Ethernet II and 4-SNAP. num (4,0) Field Definition Format Size ID* Primary key for the table. int FABRIC_ID Fabric ID of the associated fabric for this ISL.
PAGE 130
H Database tables and fields TABLE 234 Definition Format SOURCE_SWITCH_PORT_ID The Switch port ID of the Source Switch (local end of the ISL). Maintained as a nullable foreign key to account for ports being moved from one VF to other. int TARGET_SWITCH_PORT_ID The Switch port ID of the Target Switch (remote end of the ISL). Maintained as a nullable foreign key to account for ports being moved from one VF to other. int COST Cost of the ISL link. int TYPE Type of the IS.
PAGE 131
H Database tables and fields TABLE 235 ISL_TRUNK_GROUP (Continued) Field Definition Format MISSING Denotes whether ISL trunk group is missing or not. 0 denotes present and 1 states that ISL trunk is missing smallint MISSING_TIME States the missing time of the this ISL trunk group. If the trunk is not missing then it will be null timestamp MEMBER_TRACKING_STAT US Member added/removed status of this trunk. This is represented as bitmap value. Each bit is set based on membership state change.
PAGE 132
H Database tables and fields TABLE 238 L2_ACL_DEVICE_DEPLOY_MAP Field Definition Format DEPLOYMENT_ID Deployment configuration ID. Foreign Key for DEPLOYMENT table. int L2_ACCESS_CONTROL_LIST_ID L2 Access control List ID for reference to the L2_ACCESS_CONTROL_LIST. Foreign Key for L2_ACCESS_CONTROL_LIST table. int TABLE 239 L2_ACL_INTERFACE_DEPLOY_MAP Field Definition Format ID Unique generated database identifier. serial DEPLOYMENT_ID Deployment configuration ID.
PAGE 133
H Database tables and fields TABLE 241 LAG Field Definition Format ID DB ID of LAG(Port-Channel).
PAGE 134
H Database tables and fields TABLE 243 Field Definition ID Primary key. MANAGED_ELEMENT_ID The managed element id of the device. This is the foreign key to MANAGED_ELEMENT table. int CONFIG_XPATH The xpath string. varchar LAST_UPDATE_TIME Timestamp returned by the device for this particular xpath.
PAGE 135
H Database tables and fields TABLE 245 LICENSE Field Definition Format ID Unique Number assigned for the license information. int LICENSE_KEY License key string which has encoded value of number of products, ports licensed and package which this license isapplicable, etc. varchar 1024 SERIAL_NO Unique serial number string that helps to identify the customer or organization which this license is issued for.
PAGE 136
H Database tables and fields TABLE 248 Field Definition Format ID Unique generated database identifier. int NAME Name of the license rule varchar 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.
PAGE 137
H Database tables and fields TABLE 252 LSAN_DEVICE Field Definition Format ID* Unique generated database identifier. 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.
PAGE 138
H Database tables and fields TABLE 256 Field Definition Format ID Unique generated database identifier. serial BB_FABRIC_ID Backbone fabric db ID. int EDGE_FABRIC_ID FID assigned to edge fabric. int ZONE_CONTENT LSAN zone string. text BACKBONE 0= is not a backbone lsan zone configuration. 1= is a backbone lsan zone configuration. smallint TABLE 257 Size LSAN_ZONE_MEMBER Field Definition Format LSAN_ZONE_ID* LSAN_ZONE record reference. int MEMBER_PORT_WWN* Zone member WWN.
PAGE 139
H Database tables and fields TABLE 262 MANAGED_ELEMENT Field Definition Format ID An ID that is unique across managed elements of all types: SAN physical switches, SAN logical switches, IP switches, and hosts. Also the primary key for the MANAGED_ELEMENT table. int PLACEHOLDER Not used. iBatis/Abator requires at least one non-serial column to generate correct objects. The default value is 0. int TABLE 263 MAPS_EVENT Field Definition Format ID The primary key of the table.
PAGE 140
H Database tables and fields TABLE 264 Definition Format TIME_BASE The time base for the threshold. 0 - None, 1 - Minute, 2 - Hour, 3 - Day int ACTIONS A bit map for the actions configured for the rule. 0 None, 1 - RASLOG, 2 - SNMP, 4 - Email, 8 - Fence Port, 16 - SW_ST_DOWN, 32 - SW_ST_MARGINAL. int CURRENT_VALUE The current value of the measure that triggered the violation. varchar SWITCH_ENABLED_ACTI ONS MAPS actions enabled on the switch at the time the violation occurred.
PAGE 141
H Database tables and fields TABLE 268 MESSAGE_RECIPIENT (Continued) Field Definition Format 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. smallint REPEATER_ENABLED If filtering is disabled. -1 for Syslog i.e RECIPIENT_TYPE_ID: 2. Default value is -1.
PAGE 142
H Database tables and fields TABLE 271 MODULE_TYPE Field Format Size MODULE_TYPE_ID int MODULE_TYPE num (4,0) NAME varchar 32 DESCRIPTION varchar 128 NUM_PORTS num (4,0) TABLE 272 N2F_PORT_MAP Field Definition Format ID* Unique generated database identifier. int VIRTUAL_SWITCH_ID Virtual switch ID of AG for N to F_port mapping, foreign key to VIRTUAL_SWITCH table. int N_PORT Port number of port type N_Port which is being mapped, One N_Port can be mapped to multiple F_ports.
PAGE 143
H Database tables and fields TABLE 276 NP_FLOW_DEFINITION Field Definition Format ID The primary key of the table. int NAME The name of the table. varchar VIRTUAL_SWITCH_ID The id for the virtual switch. int SRCDEV Comma separated list of source device ports. varchar 1024 DSTDEV Comma separated list of destination device ports. varchar 1024 SRCPORT Comma separated list of source switch ports. varchar 1024 DSTPORT Comma separated list of destination switch ports.
PAGE 144
H Database tables and fields TABLE 277 Field Definition Format ID The primary key of the table. int FLOW_DEFINITION_ID The id of the flow definition int FEATURE Feature this sub flow is associated with. Feature can be one of the following: Monitor - 0, Generator - 1, Mirror - 2 int SRCDEV Source device port. varchar 32 DSTDEV Destination device port. varchar 32 SRCPORT Switch Source port. varchar 32 DSTPORT Switch Destination port.
PAGE 145
H Database tables and fields TABLE 280 PHANTOM_PORT Field Definition Format ID Unique generated database identifier. 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. smallint PORT_ID The portId of the phantom port. The default value is 000000. varchar SPEED The speed of the phantom port. The default value is 0. int MAX_SPEED The max speed of the phantom port.
PAGE 146
H Database tables and fields TABLE 282 1428 PHYSICAL_INTERFACE Field Definition Format INTERFACE_ID Primary key for this table. int PHYSICAL_PORT_ID Foreign key which refers PHYSICAL_PORT table. int SPEED_IN_MB Interface speed in Mega Bytes. int PHYSICAL_ADDRESS MAC address of this interface. varchar LINK_ID Foreign key which refers LINK table. int DUPLEX_MODE Interface duplex mode. Full/Half/Auto.
PAGE 147
H Database tables and fields TABLE 283 PHYSICAL_PORT Field Definition Format PHYSICAL_PORT_ID Database unique generated identifier. int PORT_NUM Port number from interface identifier. smallint MODULE_ID Database ID of the module which this port is present. int IS_PORT_PRESENT This flag is to indicate whether the port is presented in the device. Unknown-0, Present-1 and Not present -2. smallint TABLE_SUBTYPE PHYSICAL_PORT table sub type.
PAGE 148
H Database tables and fields TABLE 287 1430 PM_DASHBOARD_WIDGET Field Definition Format DASHBOARD_WIDGET_ID Primary key column. int TIME_SCOPE Time in unit of seconds, for which the data has to be fetched from DB going back from now applicable for top N, distribution, and top Flow, time series. int REFRESHING_INTERVAL The widget refreshing interval in seconds, in 11.3 we will fix it at 600 (10 mins) and not expose it to user.
PAGE 149
H Database tables and fields TABLE 287 PM_DASHBOARD_WIDGET (Continued) Field Definition Format LEVEL5_ENABLED Enable / disable the fifth threshold check. This value is applicable only for Top N, Top Flow widgets. Default is 0. smallint LEVEL5_VALUE Limit value for the fifth percentage band. In case of Top N, Top Flow widgets only three percentage band s are available. This value is not applicable. Default is 0. double precision LEVEL5_COLOR RGB color for the fifth percentage band.
PAGE 150
H Database tables and fields TABLE 288 Definition Format Size THRESHOLD_OP Stores the threshold operator value. varchar 10 REARM_OP Stores the rearm operator value. varchar 10 IS_REARM_ABS Whether or not the rearm. Default - 0. smallint THRESHOLD_SEVERITY The severity for the threshold event. smallint REARM_SEVERITY The severity for the rearm event. smallint IS_SYSTEM Indicates whether this is a system built in collector, user cannot delete it. Default - 1.
PAGE 151
H Database tables and fields TABLE 292 PM_WIDGET_MEASURE_TYPE_ENTRY Field Definition Format WIDGET_ID The id of the widget definition. int MEASURE_TYPE stores measure type id of the widget, a widget could map to multiple measure types. int TABLE 293 Size PM_WIDGET_MONITOR_TYPE Field Definition Format Type Primary key column. int NAME Storing the NAME of the monitor type.
PAGE 152
H Database tables and fields TABLE 297 Field Definition Format WIDGET_ID The ID of the widget definition. int USER_ID ID of the user who is using the widget definition. int TABLE 298 Size POE_THRESHOLD Field Definition Format ID Unique generated database identifier. serial TYPE This field indicates if the threshold is defined for product and port level measure. • 0 = product level • 1 = port level smallint DEVICE_ID This is the foreign key reference key to the Device Table.
PAGE 153
H Database tables and fields TABLE 300 PORT_BOTTLENECK_CONFIG Field Definition Format SWITCH_PORT_ID The database ID of the switch port that the configuration belongs to. int BOTTLENECK_DETECT _ENABLED Flag indicates if bottleneck detection is enabled or not. The default value is 0. smallint ALERTS_ENABLED Flag indicates if bottleneck detection alerts is enabled or not.The default value is -1. smallint CONGESTION_ THRESHOLD Value of bottleneck detection congestion threshold in percent.
PAGE 154
H Database tables and fields TABLE 302 Definition Format Size PASSWORD Password to be used for authenticating. Stored in encrypted format. varchar 512 STATUS Status before and after contacting the CIMOM Server. Possible values are 0 - OK, 1- Not Contacted Yet , 2 - Credentials Updated, 3 - Credentials Failed, 4 - Not Reachable. int LAST_CONTACTED_TIME Last time CIMOM server contacted.
PAGE 155
H Database tables and fields TABLE 304 PORT_FENCING_POLICY_MAP (Continued) Field Definition Format Size SUB_LEVEL • • • char 23 NODE WWN of Node which policy assigned. char 23 Directly assigned or inherited from root level. 0 = Directly assigned 1 = Indirectly assigned smallint Field Definition Format ID* Unique generated database identifier. int NAME Privilege Name. varchar AREA Privilege Area.
PAGE 156
H Database tables and fields TABLE 308 Field Definition Format Size TRIGGER_NAME* Name of the trigger. varchar 80 TRIGGER_GROUP* Name of the trigger group. varchar 80 BLOB_DATA The Scheduler info. bytea TABLE 309 QRTZ_CALENDARS Field Definition Format Size CALENDAR_NAME* Name of the Calendar. varchar 80 CALENDAR Calendar object. bytea TABLE 310 QRTZ_CRON_TRIGGERS Field Definition Format Size TRIGGER_NAME* Name of the trigger.
PAGE 157
H Database tables and fields TABLE 312 QRTZ_JOB_DETAILS (Continued) Field Definition Format Size DESCRIPTION Description of the job (optional). varchar 120 JOB_CLASS_NAME The instance of the job that will be executed. varchar 128 IS_DURABLE Whether the job should remain stored after it is orphaned. boolean IS_VOLATILE Whether the job should not be persisted in the JobStore for re-use after program restarts. boolean IS_STATEFUL Whether the job implements the interface StatefulJob.
PAGE 158
H Database tables and fields TABLE 317 Definition Format size REPEAT_INTERVAL interval for first and second job num (13,0) TIMES_TRIGGERED Number of times the corresponding trigger fired num (13,0) TABLE 318 QRTZ_JTRIGGER_LISTENERS Field Definition Format Size TRIGGER_NAME* Name of the trigger. varchar 80 TRIGGER_GROUP* Name of the trigger group. varchar 80 TRIGGER_LISTENER* The listener action.
PAGE 159
H Database tables and fields TABLE 322 REPORT_TYPE (Continued) Field Definition Format Size NAME Report name. varchar 128 DESCRIPTION Report type description. varchar 256 Size TABLE 323 REPORT_TEMPLATE Field Definition Format ID The primary key of the table. int NAME Name of the report and the report names must be descriptive. For example, Wired Device Report. varchar 256 TITLE The title of the report that briefly describes the report contents.
PAGE 160
H Database tables and fields TABLE 326 Definition Format Size NAME Resource group name. varchar 128 DESCRIPTION Resource group description. varchar 512 Size TABLE 327 RESOURCE_HOST_MAP Field Definition Format RESOURCE_GROUP_ID Resource Group ID int HOST_ID HOST_ID,which is in the resource group int Field Definition Format ID* Unique generated database identifier. int NAME Role name. varchar 128 DESCRIPTION Role description.
PAGE 161
H Database tables and fields TABLE 330 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 331 Size SAN_CONNECTION Field Definition Format Size ID Unique generated database identifier.
PAGE 162
H Database tables and fields TABLE 332 Definition Format Size PASSWORD The password to login into the SCOM Server varchar 64 VERSION The version of SCOM. Default is 6.1.7221.0 which is SCOM 2007 R2. The default value is '6.1.7221.0' .
PAGE 163
H Database tables and fields TABLE 335 SENSOR Field Definition Format ID Unique generated database identifier. int CORE_SWITCH_ID Size int 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.
PAGE 164
H Database tables and fields TABLE 335 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.
PAGE 165
H Database tables and fields TABLE 337 SMART_CARD (Continued) 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. The default value is 'now()'.
PAGE 166
H Database tables and fields TABLE 340 Definition Format TIMEOUT Timeout value in seconds for a get/set request to the SNMP agent. Default value is 5. smallint VERSION SNMP agent version running on the switch, as in SNMPv1 or SNMPv3. varchar 6 READ_COMMUNITY_ STRING The SNMP Read-Only Community String is like a password. It is sent along with each SNMP Get-Request and allows (or denies) access to a device. The default value is "public".
PAGE 167
H Database tables and fields TABLE 341 SNMP_DATA (Continued) Field Definition Format Size TARGET_TYPE Target type of the SNMP collector data. The target type for, • device level collector is 0 • port level collector it is 1. num (2,0) TARGET_ID Target id of the SNMP collector data. for device level collector it will use deviceId, and for port level it will use interfaceId. int VALUE Value of the OID retrieved from the corresponding target.
PAGE 168
H Database tables and fields TABLE 344 SNMP_DATA_30MIN Field Definition Format ID Primary key autogenerated ID int MIB_OBJECT_ID MIB OID used for collection int Target or source type can be, device - 0 or interface or ports - 1 num TARGET_ID DB Id of the target which can be device or interface int VALUE Value collected by the engine double precision TIME_IN_SECONDS Time at which collection occured in seconds int COLLECTOR_ID DB Id of the collector object used for collection int MI
PAGE 169
H Database tables and fields TABLE 346 SNMP_EXPR_DATA_1DAY (Continued) Field Definition Format TIME_IN_SECONDS Time, in seconds, at which the record was inserted in seconds. int COLLECTOR_ID DB ID of the collector object used for collection. int TABLE 347 SNMP_EXPR_DATA_2HOUR Field Definition Format ID Unique generated database identifier.
PAGE 170
H Database tables and fields TABLE 350 1452 SNMP_PROFILE Field Definition Format Size NAME* A text string representing a set of SNMP agent profile. When created, one or more virtual switches could refer to this profile for its SNMP credentials unless a unique set of SNMP credentials has been defined in SNMP_CREDENTIAL.
PAGE 171
H Database tables and fields TABLE 350 SNMP_PROFILE (Continued) Field Definition Format Size PRIV_PASSWORD The localized secret key used by the privacy protocol for encrypting and decrypting messages. This is applicable if the agent is configured to operate in SNMPv3. varchar 64 SNMP_INFORMS_ENABLED To denote whether SNMP informs option is enabled or disabled Default value is 0. smallint TABLE 351 SOURCE_OBJECT_TYPE Field Definition Format ID* Unique generated database identifier.
PAGE 172
H Database tables and fields TABLE 354 STATS_AGING (Continued) Field Definition Format ONE_DAY_VALUE Configured maximum samples value for the one day table. int MAX_SAMPLES_VALUE The maximum number of samples value, i.e., 3456. int INTERPOLATE Whether interpolation is enabled or disabled. smallint POLICY_TYPE The type of the aging ploicy.
PAGE 173
H Database tables and fields TABLE 357 SWITCH_BOTTLENECK_CONFIG Field Definition Format LAST_UPDATE_TIME Last update time of the record timestamp LATENCY_SEVERITY The factor by which throughput must drop in a second in order for that second to be considered affected by latency bottlenecking. Range (1 to 1000). int LATENCY_TIME The minimum fraction of a second that must be affected by latency in order for that second to be considered affected by latency bottlenecking. Range (0 to 1).
PAGE 174
H Database tables and fields TABLE 360 Definition Format Size SYS_OID This will represent the sys_oid for each product type. varchar 255 PRODUCT_FAMILY This represents the product family that each OID belongs to. varchar 128 BRIEF_PRODUCT_FAMILY Shorter name for the product family. varchar 32 SPEED Switch max speed. Value 0 represents NotAvailable. smallint MULTI_CP_CAPABLE Switch is multi cp cabable or not. 0 means single CP and 1 means multi.
PAGE 175
H Database tables and fields TABLE 361 SWITCH_PORT (Continued) Field Definition Format Size LOCKED_PORT_TYPE Indicates the locked port type of the port. Ports can be locked down so that they can come up only in that mode. varchar 16 CATEGORY Denotes the category of the switch. 1 denotes FC port and 2 denotes gige port. smallint PROTOCOL The protocol used by the port. FC, FCIP etc. varchar 16 SPEED Actual speed at which the port is currently operating.
PAGE 176
H Database tables and fields TABLE 361 1458 SWITCH_PORT (Continued) Field Definition Format Size RATE_LIMITED Denotes if the port has Rate Limiting Enabled. smallint QOS_CAPABLE Indicates if the port is QOS capable. smallint QOS_ENABLED Indicates if the port is QOS enabled. smallint TUNNEL_CONFIGURED Denotes if the port has a fcip tunnel configured. smallint FCIP_TUNNEL_UP Denotes if the fcip tunnel that is configured is up. smallint FCR_FABRIC_ID Stores the FCR fabric ID.
PAGE 177
H Database tables and fields TABLE 361 SWITCH_PORT (Continued) Field Definition Format LATENCY_DETECT_SUPPOR TED Whether the port supports latency detection. 1 means true and 0 means false smallint PREVIOUS_STATE Fields copies the old state of the port . The field could be used to track the state change information for the switch port . SwitchAssetCollector sets this field during the collection time.
PAGE 178
H Database tables and fields TABLE 361 Definition Format FEATURES_ACTIVE Holds as a bit mask the features that are active. Please note that this is different from the enabled value which is found in the FEATURES_ENABLED column. Each bit would represent features like Encryption, compression etc. The bit mask and their corresponding Features are defined as an enum in the domain model class - SwitchPort.java. int DISABLED_REASON The Switch Port disabled reason.
PAGE 179
H Database tables and fields TABLE 365 TARGET_TYPE Field Definition Format ID Unique generated database identifier. serial TYPE Type of the target device. Some possible values are • Switch • Device • Port • Host • Port Group • Product Group • VLAN • Fabric varchar 64 Size TABLE 366 Size THIRD_PARTY_DEVICE Field Definition Format DEVICE_ID Primary key for this table. int DEVICE_TYPE Type of the third party device.
PAGE 180
H Database tables and fields TABLE 368 Definition Format ME_ID ME_ID of the target. int VALUE 30 mins aggregated data. double precision TABLE 369 Definition Format TIME_IN_SECONDS Time when the record is inserted. int TARGET_TYPE Target type of the PM collector data. For device level collector the target type is 0, for port level it is 1. smallint MEASURE_ID ID of the measure. int TARGET_ID Target ID of the PM collector data.
PAGE 181
H Database tables and fields TABLE 371 TIME_SERIES_DATA_30MIN Field Definition Format TARGET_ID Target ID of the PM collector data. For device level collector it will use deviceId, for port level it will use interfaceId. int COLLECTOR_ID ID of the data_collector. int MEASURE_INDEX Stores the index_map value in case of an expression. varchar ME_ID ME_ID of the target. int VALUE 30 mins aggregated data.
PAGE 182
H Database tables and fields TABLE 373 Field Definition Format TIME_IN_SECONDS Time when value of the measure retrieved from the corresponding target. int TARGET_TYPE Target type of the PM collector data. For IP_DEVICE(0), IP_PORT(1), IP_TRUNK(2), FOS_DEVICE(3), FC_PORT(4), GE_PORT(5), TE_PORT(6), HBA_PORT(7), CNA_PORT(8), VIRTUAL_FCOE_PORT(9), FCIP_TUNNEL(10), EE_MONITOR(11), IP_DEVICE_GROUP(12), IP_PORT_GROUP(13), VIRTUAL_GROUP(14), TRILL_TRUNK(15), ALL_SAN_PRODUCTS(16).
PAGE 183
H Database tables and fields TABLE 374 TIME_SERIES_DATA_1_2HOUR (Continued) Field Definition Format VALUE Stores the 2 hours aggregated data. double precision MIN_VALUE Minimum value in 30 min table while aggregating 2 hours of data. double precision MAX_VALUE Maximum value in 30 min table while aggregating 2 hours of data.
PAGE 184
H Database tables and fields TABLE 376 Field Definition Format TIME_IN_SECONDS Time when value of the measure retrieved from the corresponding target. int TARGET_TYPE Target type of the PM collector data. For IP_DEVICE(0), IP_PORT(1), IP_TRUNK(2), FOS_DEVICE(3), FC_PORT(4), GE_PORT(5), TE_PORT(6), HBA_PORT(7), CNA_PORT(8), VIRTUAL_FCOE_PORT(9), FCIP_TUNNEL(10), EE_MONITOR(11), IP_DEVICE_GROUP(12), IP_PORT_GROUP(13), VIRTUAL_GROUP(14), TRILL_TRUNK(15), ALL_SAN_PRODUCTS(16).
PAGE 185
H Database tables and fields TABLE 377 TIME_SERIES_DATA_2_1DAY (Continued) Field Definition Format VALUE Stores One day aggregated data. double precision MIN_VALUE Minimum value in 2 hour table while aggregating 1 day data. double precision MAX_VALUE Maximum value in 2 hour table while aggregating 1 day data. double precision TABLE 378 Size TIME_SERIES_DATA_2_2HOUR Field Definition Format TIME_IN_SECONDS Time when value of the measure retrieved from the corresponding target.
PAGE 186
H Database tables and fields TABLE 379 Field Definition Format TIME_IN_SECONDS Time when value of the measure retrieved from the corresponding target. int TARGET_TYPE Target type of the PM collector data. For IP_DEVICE(0), IP_PORT(1), IP_TRUNK(2), FOS_DEVICE(3), FC_PORT(4), GE_PORT(5), TE_PORT(6), HBA_PORT(7), CNA_PORT(8), VIRTUAL_FCOE_PORT(9), FCIP_TUNNEL(10), EE_MONITOR(11), IP_DEVICE_GROUP(12), IP_PORT_GROUP(13), VIRTUAL_GROUP(14), TRILL_TRUNK(15), ALL_SAN_PRODUCTS(16).
PAGE 187
H Database tables and fields TABLE 380 TIME_SERIES_DATA_3 (Continued) Field Definition Format VALUE Stores the raw data received from the device. double precision SUM_VALUE Named after SUM_VALUE to be consistent with column names in aggregated data tables.Stores the delta changes for counter values between two samples, only used for counter values, 0 for all other types of measures.
PAGE 188
H Database tables and fields TABLE 382 Definition Format TARGET_ID Target ID of the PM collector data. For device level collector it will use deviceId/virtualSwitchId, for port level it will use interfaceId/switchPortId/ fcipTunnelId/devicePortId. int COLLECTOR_ID DB ID of the pm_data_collector. int MEASURE_INDEX Stores the index_map value in case of an expression. varchar ME_ID ME_ID of the target. int VALUE Stores the 2 hours aggregated data.
PAGE 189
H Database tables and fields TABLE 384 TIME_SERIES_DATA_4 Field Definition Format TIME_IN_SECONDS Time when value of the measure retrieved from the corresponding target. int TARGET_TYPE Target type of the PM collector data. smallint MEASURE_ID ID of the measure (MIB/Expression). int TARGET_ID Target ID of the PM collector data. For device level collector it will use deviceId/virtualSwitchId, for port level it will use interfaceId/switchPortId/ fcipTunnelId/devicePortId.
PAGE 190
H Database tables and fields TABLE 385 Definition Format MAX_VALUE Maximum value in 2 hour table while aggregating 1 day data. double precision SUM_VALUE Named after SUM_VALUE to be consistent with column names in aggregated data tables.Stores the delta changes for counter values between two samples, only used for counter values, 0 for all other types of measures.
PAGE 191
H Database tables and fields TABLE 387 TIME_SERIES_DATA_4_30MIN (Continued) Field Definition Format TARGET_ID Target ID of the PM collector data. For device level collector it will use deviceId/virtualSwitchId, for port level it will use interfaceId/switchPortId/ fcipTunnelId/devicePortId. int COLLECTOR_ID DB ID of the pm_data_collector. int MEASURE_INDEX Stores the index_map value in case of an expression. varchar ME_ID ME_ID of the target.
PAGE 192
H Database tables and fields TABLE 391 TRUNK_GROUP_MEMBER Field Definition Format TRUNK_GROUP_MEMBER_I D Primary key for this table. int INTERFACE_ID Foreign key which refers INTERACE table. int TRUNK_INTERFACE_ID Foreign key which refers TRUNK_GROUP_INTERACE table. int Field Definition Format ID * Unique generated database identifier. int NAME User name. varchar 128 DESCRIPTION User description. varchar 512 PASSWORD User password. varchar 512 EMAIL User e-mail ID.
PAGE 193
H Database tables and fields TABLE 392 USER_ (Continued) Field Definition Format Size IP_PRODUCT_ENABLE_USE R_NAME User CLI credential enable user name. varchar 256 IP_PRODUCT_ENABLE_PAS SWORD User CLI credential enable password. varchar 768 TABLE 393 USER_DEFINED_DEVICE_DETAIL Field Definition Format Size WWN WWN of the device. char 23 NAME 'Name of the device which is updated by the user. varchar 256 TYPE Type of the device (Initiator or Target.
PAGE 194
H Database tables and fields TABLE 395 Definition Format SWITCH_PORT_ID Foreign Key SWITCH_PORT.ID. The ID of the switch Port in the membership. This can be null if user does not include Switch Port in his custom membership. int INTERFACE_ID Foreign Key INTERFACE. INTERFACE_ID. The ID of the Interface in the membership. This can be null if user does not include Interface in his custom membership. int DEVICE_PORT_ID Foreign Key DEVICE_PORT.ID. The ID of the Device Port in the membership.
PAGE 195
H Database tables and fields TABLE 400 V_PORT_DETAIL Field Definition Format DEVICE_PORT_ID Primary key from the owner device port table.
PAGE 196
H Database tables and fields TABLE 403 Field Definition Format ID Unique generated database identifier.
PAGE 197
H Database tables and fields TABLE 404 VIRTUAL_FCOE_PORT_STAT_2HR (Continued) Field Definition Format TX_UTILIZATION double precision RX_UTILIZATION double precision 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 s
PAGE 198
H Database tables and fields TABLE 405 VIRTUAL_FCOE_PORT_STAT_30M (Continued) Field Definition RX_UTILIZATION double precision CREATION_TIME smallint ACTIVE_STATE double precision 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 TABLE 406 1480 Format Data gap in 5 minut
PAGE 199
H Database tables and fields TABLE 406 VIRTUAL_PORT_WWN_DETAILS (Continued) Field Definition Format Size AUTO_VPWWN VPWWN created by Switch. char 23 DEVICE_PORT_WWN Physical port WWN of the device for which VPWWN is assigned. char 23 SLOT_NUMBER Slot number of the switch, This will be -1 for AG. smallint TABLE 407 VIRTUAL_SWITCH Field Definition Format ID* Primary key for the table. int NAME Stores the switch name. varchar 64 WWN WWN of the Switch.
PAGE 200
H Database tables and fields TABLE 407 VIRTUAL_SWITCH (Continued) Field Definition Format Size STATUS Stores the status value here : UNKNOWN(0), MARGINAL(2),DOWN(3),HEALTHY(1). varchar 32 STATUS_REASON Stores the status reason, which states the contributors for the status. varchar 2048 USER_DEFINED_VALUE_1 User defined value used for annotation. varchar 256 USER_DEFINED_VALUE_2 User defined value used for annotation.
PAGE 201
H Database tables and fields TABLE 407 VIRTUAL_SWITCH (Continued) Field Definition Format INSISTENT_DID_MODE Indicates whether persistent domain ID is enabled on the switch. • 1 is enabled • 0 is disabled. smallint LAST_SCAN_TIME Stores the timestamp of the last scan time, the time which the switch was contacted for update. timestamp DOMAIN_MODE_239 Stores the domain mode offset. Its only used in the mixed fabric (FOS+EOS). smallint DOMAIN_ID_OFFSET Stores the domain id offset value.
PAGE 202
H Database tables and fields TABLE 407 Definition Format MANAGED_ELEMENT_ID A unique managed element ID for this virtual switch. Also a foreign key reference to the MANAGED_ELEMENT table. int HIF_ENABLED The HIF Enabled bit on the switch. Values are 1 for enabled and 0 for not enabled. -1 the default, stands for not supported and will be used for older firmwares. Default value is -1. smallint CLUSTER_MODE This column is used to determine whether VCS Cluster is in Standalone mode or Cluster mode.
PAGE 203
H Database tables and fields TABLE 409 VIRTUAL_SWITCH_CHECKSUM Field Definition Format VIRTUAL_SWITCH_ID * DB ID of virtual switch. int CHECKSUM_KEY * Checksum key. varchar 32 CHECKSUM Checksum value. varchar 16 Size TABLE 410 Size VIRTUAL_SWITCH_COLLECTION Field Definition Format VIRTUAL_SWITCH_ID * DB ID of virtual switch. int COLLECTOR_NAME * Collector name. varchar LAST_VIRTUAL_SW_ MODIFICATION Last modified time on switch.
PAGE 204
H Database tables and fields TABLE 415 Field Definition Format VLAN_INTERFACE_RELATION_ID Unique database generated identifier. int VLAN_DB_ID Database ID of the VLAN instance which is associated with the interface. int INTERFACE_ID Database ID of the INTERFACE instance which is associated with the vlan. int TABLE_SUBTYPE Table subtype possible value is VLAN_INTERFACE_RELATION.
PAGE 205
H Database tables and fields TABLE 417 VMOTION_EVENT (Continued) Field Definition Format END_TIME End time of the vmotion event, could be null cause of a failed vmotion. timestamp STATUS VMotion event status. 0 = info, 1 = warning, 2 = failed. smallint DRS_TRIGGERED Identifies whether the events was due to DRS. 0 = No, 1 = Yes. smallint USER_NAME Identifies that user who initiated the vmotion. varchar 80 DESCRIPTION Event message that is received.
PAGE 206
H Database tables and fields TABLE 420 Definition Format ACCESSIBLE The connectivity status of this datastore. If this is set to false, meaning the datastore is not accessible, this datastores capacity and freespace properties cannot be validated. 0 = no 1 = yes. smallint STATUS Status of the datastore could be normal, enteringMaintenance, inMaintenance. varchar 20 FILE_SYSTEM_TYPE Type of file system volume, such as VMFS or NFS.
PAGE 207
H Database tables and fields TABLE 421 VM_DV_PORT (Continued) Field Definition Format CONFLICT Whether the port is a conflict port. A port could be marked as conflict if an entity is discovered connecting to a port that is already occupied, or if the port is created by the host without conferring with Virtual Center Server. A conflict port will not have its runtime state persisted and the port can''t move away from the host, i.
PAGE 208
H Database tables and fields TABLE 422 Definition Format Size DESCRIPTION A description string of the portgroup varchar 256 UPLINK_PORT_GROUP Whether this portgroup is an uplink portgroup smallint KEY The key for the port group varchar MOR_ID The managed object reference number assigned by the hypervisor int TABLE 423 1490 VM_DV_PORT_GROUP (Continued) Field 64 VM_DV_SWITCH Field Definition Format ID Unique generated database identifier.
PAGE 209
H Database tables and fields TABLE 423 VM_DV_SWITCH (Continued) Field Definition Format DVS_OPER_SUPPORTED Whether this switch allow Virtual Center users to modify DVS configuration at switch level, except for host memeber, policy and scope operations smallint CREATION_TIME The create time of the switch timestamp UPLINK_PORT_NAME The uniform name of uplink ports on each host varchar VM_DATA_CENTER_ID A foreign key referencing VM_DATACENTER table instance to which this host is associated wit
PAGE 210
H Database tables and fields TABLE 425 VM_FC_HBA (Continued) Field Definition Format The type of the fiber channel port. One of : Fabric Loop Point to point Unknown smallint SPEED The current operating speed of the adapter in bits per second.
PAGE 211
H Database tables and fields TABLE 427 VM_HOST (Continued) Field Definition Format Size CPU_TYPE Text summary of CPU hardware, such as: Intel(R) Xeon(TM) CPU 2.6 GHz varchar 64 CPU_RESOURCES Text summary of CPU resources, such as "20 GHz total, 15 GHz reserved". May be a different format for different VM vendors varchar 64 MEM_RESOURCES Text summary of memory resources, such as "7 GB total, 5 GB reserved".
PAGE 212
H Database tables and fields TABLE 429 Definition Format Size DVS_NAME The name of the DistributedVirtualSwitch that the HostProxySwitch is part of varchar 256 DVS_UUID The uuid of the DistributedVirtualSwitch that the HostProxySwitch is a part of varchar 256 KEY_ The proxy switch key varchar 256 NUM_PORTS The number of ports that this switch currently has int NUM_PORTS_AVAILABLE The number of ports that are available on this virtual switch int UPLINK_PORT_NAMES varchar 256 Size T
PAGE 213
H Database tables and fields TABLE 431 VM_HOST_VIRTUAL_NIC (Continued) Field Definition Format VM_DV_PORT_ID Foreign key to the vm_dv_port table. DV Port with which this vmknic is associated int MTU The MTU of the port int VM_HOST_ID FOREIGN KEY to the vm_host table int MOR_ID The managed object reference number assigned by the hypervisor int PORT_GROUP_KEY The key for the port group varchar BINARY_MAC MAC address in binary format. bytea BINARY_IP IP address in binary format.
PAGE 214
H Database tables and fields TABLE 433 Definition Format REVERSE_POLICY The flag to indicate whether or not the teaming policy is applied to inbound frames as well. For example, if the policy is explicit failover, a broadcast request goes through uplink1 and comes back through uplink2. Then if the reverse policy is set, the frame is dropped when it is received from uplink2. This reverse policy is useful to prevent the virtual machine from getting reflections.
PAGE 215
H Database tables and fields TABLE 434 VM_PATH (Continued) Field Definition Format FABRIC_ID Identifies the fabric that contains this path. Not a foreign key reference. Copied here for convenience. Determined by locating the HBA port WWN or target port WWN in the DEVICE_PORT table. Zero if the fabric is not managed. The default value is 0. int HBA_PORT The HBAs physical port WWN for this path char 23 VM_PORT_WWN The initiator port WWN used by the VM.
PAGE 216
H Database tables and fields TABLE 435 Definition Format DUPLEX The flag to indicate whether or not the link is capable of full-duplex ("true") or only half-duplex ("false"). smallint MAC_ADDRESS The media access control (MAC) address of the physical network adapter. varchar 17 PCI Device hash of the PCI device corresponding to this physical network adapter. varchar 256 WAKE_ON_LAN_SUPPO RTED Flag indicating whether the NIC is wake-on-LAN capable. 0 - false, 1 - true.
PAGE 217
H Database tables and fields TABLE 437 VM_STANDARD_VIRTUAL_SWITCH Field Definition Format ID Unique generated database identifier. serial NAME The name of the virtual switch. varchar PORTS_COUNT The number of ports that this virtual switch currently has. int PORTS_AVAILABLE The number of ports that are available on this virtual switch. int MTU The maximum transmission unit (MTU) associated with this virtual switch in bytes.
PAGE 218
H Database tables and fields TABLE 439 Definition Format VM_STANDARD_VIRTUA L__SWITCH_ID Foreign Key to the vm_standard_virtual_switch table. The standard virtual swtich on which this port group exists. int MOR_ID The managed object reference number assigned by the hypervisor. int TABLE 440 1500 VM_STD_VSWITCH_PORT_GROUP (Continued) Field Size VM_STORAGE Field Definition Format Size ID Uniquely identifies this LUN. serial HOST_ID Identifies the server that accesses this LUN.
PAGE 219
H Database tables and fields TABLE 441 VM_STORAGE_HBA_REMOTE_PORT_MAP Field Definition Format VM_STORAGE_ID A foreign key referencing VM_STORAGE (ID). int HBA_REMOTE_PORT_ID A foreign key referencing HBA_REMOTE_PORT (ID). int TABLE 442 VM_TRAFFIC_SHAPING_POLICY Field Definition Format ID Unique generated database identifier. serial ENABLED 'The flag to indicate whether or not traffic shaper is enabled on the port.
PAGE 220
H Database tables and fields TABLE 443 VM_VCENTER (Continued) Field Format Size MANAGED_ELEMENT_ID A foreign key referencing MANAGED_ELEMENT(ID). int FAULT_MONITORING_ST ATE Flag to indicate whether fault monitoring is registered or not for a VM Host. Possible values are: 1.Not registered 2.Registered (Default) smallint NAME The name of the VCenter. varchar 64 UUID Unique identifier for vCenter server instance.
PAGE 221
H Database tables and fields TABLE 445 VM_VIRTUAL_ETHERNET_ADAPTER (Continued) Field Definition Format ADDRESS_TYPE MAC address type. Valid values for address type are: • Manual • Statically assigned MAC address. • Generated • Automatically generated MAC address. • Assigned • MAC address assigned by VirtualCenter. smallint MAC_ADDRESS MAC address assigned to the virtual network adapter. Clients can set this property to any of the allowed address types.
PAGE 222
H Database tables and fields TABLE 446 VM_VIRTUAL_MACHINE Field Definition Format ID Uniquely identifies the virtual machine serial HOST_ID Identifies the server that contains this VM int HYPERVISOR_VM_ID The VM number assigned by the hypervisor. Some hypervisors identify VMs by number as well as by name int NAME User-assigned name for the VM varchar 80 DESCRIPTION Optional user-entered notes describing the VM. (Annotation in VMware terminology.
PAGE 223
H Database tables and fields TABLE 446 VM_VIRTUAL_MACHINE (Continued) Field Definition Format Size UNCOMMITTED_STORA GE Additional Provisioned storage for a particular virtual machine. varchar 64 UNSHARED_STORAGE Exclusive storage for a particular virtual machine. varchar 64 Size TABLE 447 VM_VIRTUAL_MACHINE_DATASTORE_MAP Field Definition Format VM_DATASTORE_DETAIL S_ID A foreign key referencing VM_DATASTORE_DETAILS(ID).
PAGE 224
H Database tables and fields TABLE 448 VR_CONN_DOMAIN (Continued) Field Format CREATION_TIME timestamp LAST_UPDATE_TIME timestamp TABLE 449 Size VR_CONN_DOMAIN_GROUP Field Definition Format ID Unique generated database identifier. serial VCEM_PROFILE_ID Foreign key references the ID of the VCEM server that the domain group belongs to. int VCEM_ASSIGNED_ID The ID assigned by the VCEM server.
PAGE 225
Database tables and fields TABLE 451 VR_CONN_MODULE (Continued) Field Definition Format VENDOR Subject to chnage. May not be able to differentiate module maker. Maker of the module. 0: unknown 1: Brocade 2: QLogic int CREATION_TIME timestamp LAST_UPDATE_TIME timestamp TABLE 452 H Size VR_CONN_MODULE_PORT Field Definition Format ID Unique generated database identifier. serial VR_CONN_MODULE_ID The ID of the module that the port belongs to.
PAGE 226
H Database tables and fields TABLE 453 VR_CONN_SERVER_PROFILE (Continued) Field Definition Format LAST_UPDATE_TIME timestamp BAY_ENCLOSURE_UUID TABLE 454 The UUID extracted from the enclosure object inside the bay object inside the server profile. The value matches the domain GUID. varchar 512 VR_CONN_WWN Field Definition Format ID Unique generated database identifier.
PAGE 227
H Database tables and fields TABLE 457 ZONE_ALIAS Field Definition Format ID* Unique generated database identifier. int ZONE_DB_ID PK of the owning ZONE_DB. int NAME The zone alias name. varchar 64 Size TABLE 458 Size ZONE_ALIAS_IN_ZONE Field Definition Format ZONE_ALIAS_ID* PK of the zone alias. int ZONE_ID* PK of the zone. int 23 Size TABLE 459 ZONE_ALIAS_MEMBER Field Definition Format ID* Unique generated database identifier.
PAGE 228
H Database tables and fields TABLE 461 Field Definition Format ID Unique generated database identifier. int ZONE_DB_ID PK of the owning zone DB int DEFINED_CONTENT Defined zone raw config string, wrapped with $ to prevent special char trimming text ACTIVE_CONTENT Active zone raw config string text TI_ZONE_CONTENT TI zone raw config string text TABLE 462 Size ZONE_DB_USERS Field Definition Format ID* Unique generated database identifier. int ZONE_DB_ID PK of the owning zone DB.
PAGE 229
Views H Views ADAPTER_PORT_CONFIG_INFO create or replace view ADAPTER_PORT_CONFIG_INFO as select ADAPTER_PORT_CONFIG.ID, ADAPTER_PORT_CONFIG.NAME as CONFIG_NAME, ADAPTER_PORT_CONFIG.TYPE as TYPE, ADAPTER_PORT_CONFIG_PROPERTY.NAME as PROPERTY_NAME, ADAPTER_PORT_CONFIG_DETAILS.VALUE as PROPERTY_VALUE from ADAPTER_PORT_CONFIG, ADAPTER_PORT_CONFIG_DETAILS, ADAPTER_PORT_CONFIG_PROPERTY where ADAPTER_PORT_CONFIG.ID = ADAPTER_PORT_CONFIG_DETAILS.CONFIG_ID and ADAPTER_PORT_CONFIG_PROPERTY.
PAGE 230
H Views BOOT_IMAGE_DRIVER_MAP.SUPPORTED_DRIVERS from BOOT_IMAGE_FILE_DETAILS, BOOT_IMAGE_DRIVER_MAP where BOOT_IMAGE_FILE_DETAILS.DRIVER_MAPPING_ID= BOOT_IMAGE_DRIVER_MAP.ID; CNA_ETH_PORT_CONFIG_INFO create or replace view CNA_ETH_PORT_CONFIG_INFO as 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_ETH_PORT_CONFIG.
PAGE 231
Views H CNA_ETH_PORT.CREATION_TIME as ETH_PORT_CREATION_TIME, CNA_ETH_PORT.CURRENT_MAC_ADDRESS as CURRENT_MAC_ADDRESS, CNA_ETH_PORT.MAX_BANDWIDTH, CNA_ETH_PORT.PCIF_INDEX, CNA_ETH_PORT.MAX_PCIF, CNA_ETH_PORT.MIN_BANDWIDTH, CNA_ETH_PORT.MTU, CNA_PORT.ALARM_WARNING from CNA_PORT left outer join CNA_ETH_PORT on CNA_PORT.ID = CNA_ETH_PORT.CNA_PORT_ID; CNA_PORT_INFO create or replace view CNA_PORT_INFO as select CNA_PORT.ID, CNA_PORT.PORT_NUMBER, CNA_PORT.PORT_WWN, CNA_PORT.NODE_WWN, CNA_PORT.
PAGE 232
H Views CORE_SWITCH.REACHABLE, CORE_SWITCH.UNREACHABLE_TIME, CORE_SWITCH.OPERATIONAL_STATUS, CORE_SWITCH.CREATION_TIME, CORE_SWITCH.LAST_SCAN_TIME, CORE_SWITCH.LAST_UPDATE_TIME, CORE_SWITCH.SYSLOG_REGISTERED, CORE_SWITCH.CALL_HOME_ENABLED, CORE_SWITCH.SNMP_REGISTERED, CORE_SWITCH.USER_IP_ADDRESS, CORE_SWITCH.NIC_PROFILE_ID, CORE_SWITCH.MANAGING_SERVER_IP_ADDRESS, CORE_SWITCH.VF_ENABLED, CORE_SWITCH.VF_SUPPORTED, CORE_SWITCH.MANAGED_ELEMENT_ID as CORE_MANAGED_ELEMENT_ID, CORE_SWITCH_DETAILS.
PAGE 233
Views H LUN.CRYPTO_HOST_ID, LUN.ID CRYPTO_LUN_ID, LUN.LUN_NUMBER, LUN.CRYPTO_TARGET_CONTAINER_ID, LUN.SERIAL_NUMBER, LUN.ENCRYPTION_STATE, LUN.STATUS, LUN.REKEY_INTERVAL, LUN.VOLUME_LABEL_PREFIX, LUN.LAST_REKEY_DATE, LUN.LAST_REKEY_STATUS, LUN.LAST_REKEY_PROGRESS, LUN.CURRENT_VOLUME_LABEL, LUN.PRIOR_ENCRYPTION_STATE, LUN.ENCRYPTION_FORMAT, LUN.ENCRYPT_EXISTING_DATA, LUN.DECRYPT_EXISTING_DATA, LUN.KEY_ID, LUN.BLOCK_SIZE, LUN.TOTAL_BLOCKS, LUN.LUN_STATE, LUN.LUN_FLAGS, LUN.ENCRYPTION_ALGORITHM, LUN.
PAGE 234
H Views CRYPTO_TARGET_CONTAINER.FRONT_END_N_PORT_NUMBER, ENCRYPTION_ENGINE.STATUS ENCRYPTION_ENGINE_STATUS, ENCRYPTION_ENGINE.HA_CLUSTER_ID, ENCRYPTION_ENGINE.SYSTEM_CARD_STATUS, ENCRYPTION_ENGINE.WWN_POOLS_AVAILABLE, ENCRYPTION_ENGINE.STATE ENCRYPTION_ENGINE_STATE, ENCRYPTION_ENGINE.ID ENCRYPTION_ENGINE_ID, CRYPTO_SWITCH.SWITCH_ID SWITCH_ID, CRYPTO_SWITCH.ENCRYPTION_GROUP_ID ENCRYPTION_GROUP_ID from CRYPTO_TARGET_CONTAINER, ENCRYPTION_ENGINE, CRYPTO_SWITCH where CRYPTO_TARGET_CONTAINER.
PAGE 235
Views H DEPLOYMENT_CONFIGURATION.MANAGEMENT_FLAG, DEPLOYMENT_HANDLER.PRIVILEGE_ID, DEPLOYMENT_HANDLER.HANDLER_CLASS, DEPLOYMENT_HANDLER.CLIENT_ACTION_HANDLER_CLASS, DEPLOYMENT_STATUS.ID as STATUS_ID, DEPLOYMENT_HANDLER.MODULE_DISPLAYNAME, DEPLOYMENT_REPORT_TEMPLATE.HEADER, DEPLOYMENT_REPORT_TEMPLATE.FOOTER from DEPLOYMENT_CONFIGURATION join DEPLOYMENT_HANDLER on DEPLOYMENT_CONFIGURATION.DEPLOYMENT_HANDLER_ID = DEPLOYMENT_HANDLER.ID left outer join DEPLOYMENT_STATUS on (DEPLOYMENT_STATUS.
PAGE 236
H Views on DEPLOYMENT_CONFIGURATION.ID = DEPLOYMENT_STATUS.DEPLOYMENT_CONFIGURATION_ID left outer join DEPLOYMENT_REPORT_TEMPLATE on DEPLOYMENT_REPORT_TEMPLATE.DEPLOYMENT_HANDLER_ID = DEPLOYMENT_HANDLER.ID; DEVICE_CONNECTION_INFO CREATE VIEW device_connection_info AS select DEVICE_CONNECTION.ID, DEVICE_CONNECTION.FABRIC_ID, DEVICE_CONNECTION.DEVICE_PORT_ID, DEVICE_CONNECTION.SWITCH_PORT_ID, DEVICE_CONNECTION.AG_PORT_ID, COALESCE(DEVICE_ENCLOSURE_MEMBER.ENCLOSURE_ID, HBA.
PAGE 237
Views H EE_MONITOR_STATS_30MIN_INFO create or replace view EE_MONITOR_STATS_30MIN_INFO as select VIRTUAL_SWITCH.
PAGE 238
H Views timestamp with time zone 'epoch' + TIME_IN_SECONDS * interval '1 second' as CREATION_TIME, sum(case when MEASURE_ID = 193 then value else 0 end) as RECEIVE_OK_PERCENT_UTIL, sum(case when MEASURE_ID = 194 then value else 0 end) as TRANSMIT_OK_PERCENT_UTIL, sum(case when MEASURE_ID = 196 then value else 0 end) as RECEIVE_OK, sum(case when MEASURE_ID = 195 then value else 0 end) as TRANSMIT_OK, sum(case when MEASURE_ID = 36 then value else 0 end) as RECEIVE_EOF, sum(case when MEASURE_ID = 40 then val
PAGE 239
Views H sum(case when MEASURE_ID = 194 then value else 0 end) as TRANSMIT_OK_PERCENT_UTIL, sum(case when MEASURE_ID = 196 then value else 0 end) as RECEIVE_OK, sum(case when MEASURE_ID = 195 then value else 0 end) as TRANSMIT_OK, sum(case when MEASURE_ID = 36 then value else 0 end) as RECEIVE_EOF, sum(case when MEASURE_ID = 40 then value else 0 end) as UNDERFLOW_ERRORS, sum(case when MEASURE_ID = 41 then value else 0 end) as OVERFLOW_ERRORS, sum(case when MEASURE_ID = 43 then value else 0 end) as ALIGNMEN
PAGE 240
H Views 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.VF_SUPPORTED, CORE_SWITCH.MANAGED_ELEMENT_ID as CORE_MANAGED_ELEMENT_ID, CORE_SWITCH.NAT_PRIVATE_IP_ADDRESS, CORE_SWITCH.ALTERNATE_IP_ADDRESS, CORE_SWITCH.MAC_ADDRESS, VIRTUAL_SWITCH.ID, VIRTUAL_SWITCH.
PAGE 241
Views H 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.MANAGED_ELEMENT_ID, VIRTUAL_SWITCH.HIF_ENABLED, VIRTUAL_SWITCH.AUTO_SNMP, VIRTUAL_SWITCH.RNID_SEQUENCE_NUMBER, VIRTUAL_SWITCH.VCS_ID, VIRTUAL_SWITCH.CLUSTER_TYPE, VIRTUAL_SWITCH.CLUSTER_MODE, VIRTUAL_SWITCH.
PAGE 242
H Views DEVICE_PORT.IP_PORT, DEVICE_PORT.HARDWARE_ADDRESS, DEVICE_PORT.TRUSTED as DEVICE_PORT_TRUSTED, DEVICE_PORT.MISSING as DEVICE_PORT_MISSING, DEVICE_PORT.COS, DEVICE_PORT.NPV_PHYSICAL, 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.
PAGE 243
Views H N2F_PORT_MAP.N_PORT, N2F_PORT_MAP.F_PORT, AG_N_PORT.REMOTE_PORT_WWN as EDGE_SWITCH_PORT_WWN, AG_N_PORT.WWN as AG_N_PORT_WWN, AG_F_PORT.WWN as AG_F_PORT_WWN, AG_F_PORT.REMOTE_NODE_WWN, AG_F_PORT.REMOTE_PORT_WWN as DEVICE_PORT_WWN from N2F_PORT_MAP, SWITCH_PORT AG_N_PORT, SWITCH_PORT AG_F_PORT, VIRTUAL_SWITCH AG_SWITCH 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.
PAGE 244
H Views DEVICE_NODE left outer join USER_DEFINED_DEVICE_DETAIL on DEVICE_NODE.WWN = USER_DEFINED_DEVICE_DETAIL.WWN left outer join FABRIC on DEVICE_NODE.FABRIC_ID = FABRIC.ID left outer join DEVICE_FDMI_DETAILS on DEVICE_NODE.ID = DEVICE_FDMI_DETAILS.DEVICE_NODE_ID; DEVICE_PORT_INFO CREATE VIEW device_port_info AS select DEVICE_PORT.ID, DEVICE_PORT.NODE_ID, DEVICE_PORT.DOMAIN_ID, DEVICE_PORT.WWN, DEVICE_PORT.SWITCH_PORT_WWN, DEVICE_PORT.NUMBER, DEVICE_PORT.PORT_ID, DEVICE_PORT.TYPE, DEVICE_PORT.
PAGE 245
Views H coalesce(VS1.WWN, VS2.WWN) as SWITCH_WWN, coalesce(VS1.MANAGEMENT_STATE, VS2.MANAGEMENT_STATE) as MANAGEMENT_STATE, coalesce(VS1.MONITORED, VS2.MONITORED) as MONITORED, FABRIC.PRINCIPAL_SWITCH_WWN as PRINCIPAL_WWN, FABRIC.ID as FABRIC_ID from DEVICE_PORT left outer join USER_DEFINED_DEVICE_DETAIL on DEVICE_PORT.WWN = USER_DEFINED_DEVICE_DETAIL.WWN left outer join FICON_DEVICE_PORT on DEVICE_PORT.ID = FICON_DEVICE_PORT.DEVICE_PORT_ID left outer join DEVICE_NODE on DEVICE_PORT.NODE_ID = DEVICE_NODE.
PAGE 246
H Views DEVICE_NODE where DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID = DEVICE_PORT.ID and DEVICE_PORT.NODE_ID = DEVICE_NODE.ID; ISL_CONNECTION_INFO create or replace view ISL_CONNECTION_INFO as select distinct ISL_CONNECTION.ID, ISL_CONNECTION.FABRIC_ID, ISL_CONNECTION.SOURCE_SWITCH_PORT_ID, ISL_CONNECTION.TARGET_SWITCH_PORT_ID, ISL_CONNECTION.COST, ISL_CONNECTION.TYPE, ISL_CONNECTION.TRUSTED, ISL_CONNECTION.MISSING, ISL_CONNECTION.MISSING_TIME, ISL_CONNECTION.CREATION_TIME, ISL_CONNECTION.
PAGE 247
Views H SOURCE_VIRTUAL_SWITCH.MONITORED as SOURCE_VIRTUAL_SWITCH_MONITORED, 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.TYPE as PORT_TYPE, SOURCE_SWITCH_PORT.KIND as SOURCE_SWITCH_PORT_KIND, SOURCE_SWITCH_PORT.PHYSICAL_PORT as SOURCE_PHYSICAL_PORT, SOURCE_SWITCH_PORT.TRUNKED as SOURCE_SWITCH_PORT_TRUNKED, ISL.DEST_DOMAIN_ID, ISL.DEST_PORT_NUMBER, DEST_VIRTUAL_SWITCH.
PAGE 248
H Views SOURCE_SWITCH_PORT.VIRTUAL_SWITCH_ID as SOURCE_SWITCH_ID, SOURCE_SWITCH_PORT.USER_PORT_NUMBER as SOURCE_PORT_NUMBER, SOURCE_SWITCH_PORT.TYPE as SOURCE_PORT_TYPE, SOURCE_VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID as SOURCE_VIRTUAL_FABRIC_ID, DEST_SWITCH_PORT.VIRTUAL_SWITCH_ID as DEST_SWITCH_ID, DEST_SWITCH_PORT.USER_PORT_NUMBER as DEST_PORT_NUMBER, DEST_SWITCH_PORT.TYPE as DEST_PORT_TYPE, DEST_VIRTUAL_SWITCH.
PAGE 249
Views H EVENT_DETAILS.PRODUCT_ADDRESS as PRODUCT_ADDRESS, EVENT_DETAILS.CONTRIBUTORS as CONTRIBUTORS, EVENT_DETAILS.NODE_WWN as NODE_WWN, EVENT_DETAILS.PORT_WWN as PORT_WWN, EVENT_DETAILS.OPERATIONAL_STATUS as OPERATIONAL_STATUS, EVENT_DETAILS.FIRST_OCCURRENCE_SWITCH_TIME as FIRST_OCCURRENCE_SWITCH_TIME, EVENT_DETAILS.LAST_OCCURRENCE_SWITCH_TIME as LAST_OCCURRENCE_SWITCH_TIME, EVENT_DETAILS.VIRTUAL_FABRIC_ID as VIRTUAL_FABRIC_ID, EVENT_DETAILS.UNIT as UNIT, EVENT_DETAILS.SLOT as SLOT, EVENT_DETAILS.
PAGE 250
H Views EVENT_DETAILS.VIRTUAL_FABRIC_ID as VIRTUAL_FABRIC_ID, EVENT_DETAILS.USER_NAME as USER_NAME, EVENT_DETAILS.PORT_NAME as PORT_NAME, EVENT_DETAILS.MAC_ADDRESS from EVENT left join EVENT_DETAILS on EVENT.ID = EVENT_DETAILS.EVENT_ID, EVENT_ORIGIN, EVENT_CATEGORY, EVENT_MODULE, EVENT_DESCRIPTION where EVENT.EVENT_ORIGIN_ID = EVENT_ORIGIN.ID and EVENT.EVENT_CATEGORY_ID = EVENT_CATEGORY.ID and EVENT.EVENT_MODULE_ID = EVENT_MODULE.ID and EVENT.EVENT_DESCRIPTION_ID = EVENT_DESCRIPTION.
PAGE 251
Views H select FCIP_TUNNEL_CIRCUIT.ID, FCIP_TUNNEL_CIRCUIT.TUNNEL_ID, FCIP_TUNNEL_CIRCUIT.CIRCUIT_NUMBER, FCIP_TUNNEL_CIRCUIT.COMPRESSION_ENABLED, FCIP_TUNNEL_CIRCUIT.TURBO_WRITE_ENABLED, FCIP_TUNNEL_CIRCUIT.TAPE_ACCELERATION_ENABLED, FCIP_TUNNEL_CIRCUIT.IKE_POLICY_NUM, FCIP_TUNNEL_CIRCUIT.IPSEC_POLICY_NUM, FCIP_TUNNEL_CIRCUIT.PRESHARED_KEY, FCIP_TUNNEL_CIRCUIT.SOURCE_IP, FCIP_TUNNEL_CIRCUIT.DEST_IP, FCIP_TUNNEL_CIRCUIT.VLAN_TAG, FCIP_TUNNEL_CIRCUIT.SELECTIVE_ACK, FCIP_TUNNEL_CIRCUIT.
PAGE 252
H Views FCIP_TUNNEL_INFO create or replace view FCIP_TUNNEL_INFO as select FCIP_TUNNEL.ID, FCIP_TUNNEL.TUNNEL_ID, FCIP_TUNNEL.VLAN_TAG, FCIP_TUNNEL.SOURCE_IP, FCIP_TUNNEL.DEST_IP, FCIP_TUNNEL.LOCAL_WWN, FCIP_TUNNEL.REMOTE_WWN_RESTRICT, FCIP_TUNNEL.COMMUNICATION_RATE, FCIP_TUNNEL.MIN_RETRANSMIT_TIME, FCIP_TUNNEL.SELECTIVE_ACK_ENABLED, FCIP_TUNNEL.KEEP_ALIVE_TIMEOUT, FCIP_TUNNEL.MAX_RETRANSMISSION, FCIP_TUNNEL.WAN_TOV_ENABLED, FCIP_TUNNEL.TUNNEL_STATUS, FCIP_TUNNEL.DESCRIPTION, FCIP_TUNNEL.
PAGE 253
Views H FCIP_TUNNEL.FICON_TERADATA_WRITE_ENABLED, PORT.WWN as VIRTUAL_PORT_WWN, PORT.REMOTE_PORT_WWN as REMOTE_PORT_WWN, PORT.REMOTE_NODE_WWN as REMOTE_NODE_WWN, PORT.ID as SWITCH_PORT_ID, PORT.PORT_NUMBER as SWITCH_PORT_NUMBER, PORT.USER_PORT_NUMBER as USER_PORT_NUMBER, PORT.PORT_INDEX, PORT.STATUS_MESSAGE from FCIP_TUNNEL left outer join FCIP_PORT_TUNNEL_MAP on FCIP_PORT_TUNNEL_MAP.TUNNEL_ID = FCIP_TUNNEL.ID left outer join SWITCH_PORT PORT on FCIP_PORT_TUNNEL_MAP.SWITCHPORT_ID = PORT.
PAGE 254
H Views FRU.PREVIOUS_OP_STATUS, FRU.VENDOR, CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN, VIRTUAL_SWITCH.SWITCH_MODE as VIRTUAL_SWITCH_MODE, VIRTUAL_SWITCH.MANAGEMENT_STATE, VIRTUAL_SWITCH.MONITORED from FRU, CORE_SWITCH, VIRTUAL_SWITCH where FRU.CORE_SWITCH_ID = CORE_SWITCH.ID and FRU.CORE_SWITCH_ID = VIRTUAL_SWITCH.CORE_SWITCH_ID; GIGE_PORT_ECLOUD_LINK_INFO create or replace view GIGE_PORT_ECLOUD_LINK_INFO as select GIGE_PORT_ETHERNET_CLOUD_LINK.ID, GIGE_PORT_ETHERNET_CLOUD_LINK.
PAGE 255
Views H GIGE_PORT.INTERFACE_TYPE, GIGE_PORT.CHECKSUM, GIGE_PORT.FCIP_CAPABLE, coalesce(CARD.FCIP_CIRCUIT_CAPABLE, VIRTUAL_SWITCH.FCIP_CIRCUIT_CAPABLE) as FCIP_CIRCUIT_CAPABLE, GIGE_PORT.ISCSI_CAPABLE, GIGE_PORT.REMOTE_MAC_ADDRESS, GIGE_PORT.INBAND_MANAGEMENT_STATUS, GIGE_PORT.LAST_UPDATE, SWITCH_PORT.VIRTUAL_SWITCH_ID, SWITCH_PORT.USER_PORT_NUMBER, SWITCH_PORT.PORT_INDEX, VIRTUAL_SWITCH.WWN as VIRTUAL_SWITCH_WWN, VIRTUAL_SWITCH.MANAGEMENT_STATE, VIRTUAL_SWITCH.MONITORED, CORE_SWITCH.
PAGE 256
H Views HBA_PORT.MAX_PCIF, 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.FRAME_DATA_FIELD_SIZE, HBA_PORT_DETAIL.HARDWARE_PATH, HBA_PORT_DETAIL.V_PORT_COUNT, HBA_PORT_DETAIL.QUEUE_DEPTH, HBA_PORT_DETAIL.INTERRUPT_CONTROL_COALESCE, HBA_PORT_DETAIL.INTERRUPT_CONTROL_LATENCY, HBA_PORT_DETAIL.
PAGE 257
Views H HBA_PORT_FCOE_DETAILS.FCOE_MAC, HBA_PORT.SYNTHETIC_FC, HBA_PORT_DETAIL.ALARM_WARNING, HBA_PORT_DETAIL.IO_EXEC_THROTTLE_MAX, HBA_PORT_DETAIL.IO_EXEC_THROTTLE_OPERATIONAL, HBA_PORT_DETAIL.IO_EXEC_THROTTLE_CONFIGURED, HBA_PORT_DETAIL.BOOTUP_DELAY, HBA_PORT_DETAIL.FEC_STATE, HBA_PORT_DETAIL.BB_CREDIT_RECOVERY_STATUS, HBA_PORT_DETAIL.CONFIGURED_BB_SCN_COUNT, HBA_PORT_DETAIL.NEGOTIATED_BB_SCN_COUNT from HBA_PORT left outer join HBA_PORT_DETAIL on HBA_PORT.DEVICE_PORT_ID = HBA_PORT_DETAIL.
PAGE 258
H 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.
PAGE 259
Views H HOST_DISCOVERY_OPTION.JSON_PASSWD, HOST_DISCOVERY_OPTION.DISCOVER_CIM, HOST_DISCOVERY_OPTION.CIM_IMPL, HOST_DISCOVERY_OPTION.CIM_USERNAME, HOST_DISCOVERY_OPTION.CIM_PASSWORD, HOST_DISCOVERY_OPTION.CIM_NAMESPACE, HOST_DISCOVERY_OPTION.CIM_PORT, HOST_DISCOVERY_OPTION.DISCOVER_VM, HOST_DISCOVERY_OPTION.VM_USERNAME, HOST_DISCOVERY_OPTION.VM_PASSWORD, HOST_DISCOVERY_OPTION.JSON_PORT, HOST_DISCOVERY_OPTION.VM_PORT, HOST_DISCOVERY_OPTION.Application_Name_USER_NAME, HOST_DISCOVERY_OPTION.
PAGE 260
H Views IFL.EDGE_FABRIC_ID, (select distinct FCR_PORT.VIRTUAL_SWITCH_ID from SWITCH_PORT FCR_PORT where FCR_PORT.WWN = IFL.BB_PORT_WWN) as FCR_SWITCH_ID, IFL.EDGE_PORT_WWN, IFL.BB_FABRIC_ID, IFL.BB_PORT_WWN , IFL.BB_RA_TOV, IFL.BB_ED_TOV, IFL.BB_PID_FORMAT, SWITCH_PORT.VIRTUAL_SWITCH_ID as EDGE_SWITCH_ID, SWITCH_PORT.ID as EDGE_PORT_ID, SWITCH_PORT.USER_PORT_NUMBER as EDGE_PORT_NUMBER, SWITCH_PORT.TYPE as EDGE_PORT_TYPE from IFL left outer join SWITCH_PORT on IFL.EDGE_PORT_WWN = SWITCH_PORT.
PAGE 261
Views H DEST_SWITCH_PORT.TRUNKED as DEST_SWITCH_PORT_TRUNKED, FABRIC.PRINCIPAL_SWITCH_WWN as PRINCIPAL_SWITCH_WWN from ISL, FABRIC_MEMBER SOURCE_FABRIC_MEMBER, VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH, SWITCH_PORT SOURCE_SWITCH_PORT, FABRIC_MEMBER DEST_FABRIC_MEMBER, VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH, SWITCH_PORT DEST_SWITCH_PORT, FABRIC where SOURCE_FABRIC_MEMBER.FABRIC_ID = ISL.FABRIC_ID and SOURCE_VIRTUAL_SWITCH.ID = SOURCE_FABRIC_MEMBER.VIRTUAL_SWITCH_ID and SOURCE_VIRTUAL_SWITCH.DOMAIN_ID = ISL.
PAGE 262
H Views from ISL, DEVICE VCS_DEVICE, VCS_CLUSTER_MEMBER SOURCE_CLUSTER_MEMBER, VCS_CLUSTER_MEMBER DEST_CLUSTER_MEMBER, DEVICE SOURCE_DEVICE, SWITCH_PORT SOURCE_SWITCH_PORT, FABRIC_MEMBER SOURCE_FABRIC_MEMBER, VIRTUAL_SWITCH SOURCE_VIRTUAL_SWITCH, DEVICE DEST_DEVICE, SWITCH_PORT DEST_SWITCH_PORT, FABRIC_MEMBER DEST_FABRIC_MEMBER, VIRTUAL_SWITCH DEST_VIRTUAL_SWITCH, FABRIC where SOURCE_FABRIC_MEMBER.FABRIC_ID = ISL.FABRIC_ID and SOURCE_VIRTUAL_SWITCH.ID = SOURCE_FABRIC_MEMBER.
PAGE 263
Views H ISL_TRUNK_INFO CREATE VIEW isl_trunk_info AS select ISL_TRUNK_GROUP.ID, ISL_TRUNK_GROUP.TRUSTED, ISL_TRUNK_GROUP.MISSING, ISL_TRUNK_GROUP.MISSING_TIME, ISL_TRUNK_GROUP.MEMBER_TRACKING_STATUS, ISL_INFO.COST, ISL_INFO.TYPE, ISL_INFO.SOURCE_PORT_NUMBER, ISL_INFO.SOURCE_SWITCH_ID, ISL_INFO.MISSING_REASON, SOURCE_CORE_SWITCH.IP_ADDRESS as SOURCE_SWITCH_IP_ADDRESS, SOURCE_VIRTUAL_SWITCH.WWN as SOURCE_SWITCH_WWN, SOURCE_VIRTUAL_SWITCH.
PAGE 264
H Views from device RMT_DEVICE, LLDP_DATA, L2_NEIGHBOR, physical_interface PHY_INTF where LLDP_DATA.CHASSIS_ID = L2_NEIGHBOR.LLDP_REM_CHASSIS_ID and LLDP_DATA.CHASSIS_ID_SUBTYPE = L2_NEIGHBOR.LLDP_REM_CHASSIS_ID_SUBTYPE and LLDP_DATA.PORT_ID = L2_NEIGHBOR.LLDP_REM_PORT_ID and LLDP_DATA.PORT_ID_SUBTYPE = L2_NEIGHBOR.LLDP_REM_PORT_ID_SUBTYPE and LLDP_DATA.DEVICE_ID = RMT_DEVICE.device_id and PHY_INTF.interface_id = LLDP_DATA.
PAGE 265
Views H MODULE_INFO CREATE VIEW module_info AS select distinct TEMP_MODULE.MODULE_ID, TEMP_MODULE.NUM_PORTS, TEMP_MODULE.IS_PRESENT, case when TEMP_MODULE.IS_PRESENT = 1 then 'YES' else 'NO' end as IS_PRESENT_TXT, TEMP_MODULE.IS_MANAGEMENT_MODULE, case when TEMP_MODULE.IS_MANAGEMENT_MODULE = 1 then 'YES' else 'NO' end as IS_MANAGEMENT_MODULE_TXT, TEMP_MODULE.NUM_CPUS, TEMP_MODULE.HW_REVISION, TEMP_MODULE.SW_REVISION, TEMP_MODULE.SLOT_NUM, TEMP_MODULE.DEVICE_ID, TEMP_MODULE.PHYSICAL_DEVICE_ID, TEMP_MODULE.
PAGE 266
H Views and DEVICE.DEVICE_ID = PHYSICAL_DEVICE.DEVICE_ID ) TEMP_MODULE left join ( select FOUNDRY_MODULE.MODULE_ID, FOUNDRY_MODULE.SERIAL_NUM, FOUNDRY_MODULE.DRAM_SIZE, FOUNDRY_MODULE.BOOT_FLASH_SIZE, FOUNDRY_MODULE.CODE_FLASH_SIZE, FOUNDRY_MODULE.MODULE_TYPE from FOUNDRY_MODULE ) TEMP_FOUNDRY_MODULE ON TEMP_MODULE.MODULE_ID = TEMP_FOUNDRY_MODULE.MODULE_ID; NPORT_WWN_MAP_INFO This view provides a consolidation between Nport WWN map and AG''s N and F ports.
PAGE 267
Views H 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, VIRTUAL_SWITCH.MANAGEMENT_STATE, VIRTUAL_SWITCH.MONITORED from PHANTOM_PORT, VIRTUAL_SWITCH where PHANTOM_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID; PRODUCT_INFO CREATE VIEW product_info AS select distinct TEMP_DEVICE.DEVICE_ID, TEMP_DEVICE.MANAGED_ELEMENT_ID, TEMP_DEVICE.ALIAS_NAME, TEMP_DEVICE.HOST_NAME, TEMP_DEVICE.
PAGE 268
H Views end as SWITCH_OS, TEMP_DEVICE.IS_ROUTER, TEMP_DEVICE.IS_SLB, TEMP_DEVICE.SERIAL_NUMBER, TEMP_DEVICE.SYS_NAME, case when TEMP_DEVICE.SUB_CATEGORY > 0 then (select distinct VCSD.SYS_NAME from DEVICE as VCSD where VCSD.MANAGED_ELEMENT_ID in (select distinct VM.CLUSTER_ME_ID from VCS_CLUSTER_MEMBER as VM where TEMP_DEVICE.MANAGED_ELEMENT_ID = VM.MEMBER_ME_ID)) else null end as VCS_NAME, case when TEMP_DEVICE.SUB_CATEGORY > 0 then (select distinct VCSD.IP_ADDRESS from DEVICE as VCSD where VCSD.
PAGE 269
Views H case when TEMP_DEVICE.SUB_CATEGORY = 0 then (select distinct SWITCH_MODEL.MODEL from SWITCH_MODEL where TEMP_DEVICE.SYS_OID = SWITCH_MODEL.SYS_OID) else TEMP_DEVICE.BRIEF_PRODUCT_FAMILY end as MODEL, TEMP_FOUNDRY_DEVICE.IMAGE_VERSION as FIRMWARE, TEMP_PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID, TEMP_PHYSICAL_DEVICE.NUM_SLOTS, TEMP_PHYSICAL_DEVICE.UNIT_NUMBER, TEMP_DEVICE.USER_DEFINED_VALUE_1, TEMP_DEVICE.USER_DEFINED_VALUE_2, TEMP_DEVICE.
PAGE 270
H Views Combine port bottleneck configuration and enough info from switch port for the client to identify the port.; PORT_BOTTLENECK_STAT_INFO This view provides combine port bottleneck status and enough information from the switch port for the client to identify the port. create or replace view PORT_BOTTLENECK_STAT_INFO as select PORT_BOTTLENECK_STATUS.SWITCH_PORT_ID, PORT_BOTTLENECK_STATUS.STATUS, SWITCH_PORT.VIRTUAL_SWITCH_ID, SWITCH_PORT.USER_PORT_NUMBER, SWITCH_PORT.
PAGE 271
Views H ROLE.HIDDEN as ROLE_HIDDEN, PRIVILEGE.ID as PRIVILEGE_ID, PRIVILEGE.NAME as PRIVILEGE_NAME, PRIVILEGE.AREA as PRIVILEGE_AREA, ROLE_PRIVILEGE_MAP.PERMISSION from ROLE, ROLE_PRIVILEGE_MAP, PRIVILEGE where ROLE.ID = ROLE_PRIVILEGE_MAP.ROLE_ID and PRIVILEGE.ID = ROLE_PRIVILEGE_MAP.PRIVILEGE_ID; 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.
PAGE 272
H Views SENSOR_INFO create or replace view SENSOR_INFO as select SENSOR.ID, SENSOR.CORE_SWITCH_ID, SENSOR.SENSOR_ID, SENSOR.CURRENT_READING, SENSOR.TYPE, SENSOR.SUB_TYPE, SENSOR.DESCRIPTION, SENSOR.STATUS, SENSOR.OPERATIONAL_STATUS, SENSOR.PART_NUMBER, SENSOR.SERIAL_NUMBER, 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, VIRTUAL_SWITCH.
PAGE 273
Views H and SC.CARD_TYPE = 0 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, -1 ENGINE_ID, EG.ID ENCRYPTION_GROUP_ID, EG.NAME GROUP_NAME, RCGM.POSITION_ CARD_POSITION, -1 CRYPTO_SWITCH_ID, -1 SLOT_NUMBER from 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.
PAGE 274
H Views SWITCH_CONFIG.CONFIG_DATA, SWITCH_CONFIG.CEE_CONFIG_DATA, SWITCH_CONFIG.KEEP_COPY, SWITCH_CONFIG.CREATED_BY, SWITCH_CONFIG.COMMENTS, SWITCH_CONFIG.CONFIG_TYPE, SWITCH_CONFIG_DETAIL.IP_ADDRESS, SWITCH_CONFIG_DETAIL.WWN, SWITCH_CONFIG_DETAIL.PHYSICAL_SWITCH_WWN, SWITCH_CONFIG_DETAIL.MODEL_NUMBER as SWITCH_MODEL_NUMBER from SWITCH_CONFIG, SWITCH_CONFIG_DETAIL where SWITCH_CONFIG.ID= SWITCH_CONFIG_DETAIL.
PAGE 275
Views H VIRTUAL_SWITCH.LAST_UPDATE_TIME, VIRTUAL_SWITCH.USER_NAME, VIRTUAL_SWITCH.PASSWORD, VIRTUAL_SWITCH.MANAGEMENT_STATE, VIRTUAL_SWITCH.STATE, VIRTUAL_SWITCH.STATUS, VIRTUAL_SWITCH.STATUS_REASON, VIRTUAL_SWITCH.FABRIC_IDID_MODE, VIRTUAL_SWITCH.LOGICAL_ID, VIRTUAL_SWITCH.USER_DEFINED_VALUE_1, VIRTUAL_SWITCH.USER_DEFINED_VALUE_2, VIRTUAL_SWITCH.USER_DEFINED_VALUE_3, VIRTUAL_SWITCH.FMS_MODE, VIRTUAL_SWITCH.DYNAMIC_LOAD_SHARING, VIRTUAL_SWITCH.PORT_BASED_ROUTING, VIRTUAL_SWITCH.
PAGE 276
H Views 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.VENDOR_PART_NUMBER, CORE_SWITCH_DETAILS.CONTACT, CORE_SWITCH_DETAILS.LOCATION, CORE_SWITCH_DETAILS.DESCRIPTION, CORE_SWITCH_DETAILS.RNID_SEQUENCE_NUMBER, CORE_SWITCH_DETAILS.FIRMWARE_VERSION as CSD_FIRMWARE_VERSION, CORE_SWITCH_DETAILS.CHASSIS_PACKAGE_TYPE, CORE_SWITCH_DETAILS.
PAGE 277
Views H 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.FC_FAST_WRITE_ENABLED, SWITCH_PORT.
PAGE 278
H Views CORE_SWITCH.IP_ADDRESS as IP_ADDRESS, CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN, CORE_SWITCH.MODEL as SWITCH_MODEL, CORE_SWITCH_DETAILS.MODEL_NUMBER as SWITCH_MODEL_NUMBER FROM SWITCH_PORT, VIRTUAL_SWITCH, CORE_SWITCH LEFT JOIN CORE_SWITCH_DETAILS ON CORE_SWITCH_DETAILS.CORE_SWITCH_ID = CORE_SWITCH.ID where SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID AND VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID; SWITCH_SNMP_INFO create or replace view SWITCH_SNMP_INFO as select CORE_SWITCH.
PAGE 279
Views H coalesce(SNMP_CREDENTIALS.PORT_NUMBER, (select SNMP_PROFILE.PORT_NUMBER from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_PORT_NUMBER, coalesce(SNMP_CREDENTIALS.RETRY_COUNT, (select SNMP_PROFILE.RETRY_COUNT from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_RETRY_COUNT, coalesce(SNMP_CREDENTIALS.TIMEOUT, (select SNMP_PROFILE.TIMEOUT from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_TIMEOUT, coalesce(SNMP_CREDENTIALS.VERSION, (select SNMP_PROFILE.
PAGE 280
H Views TIME_SERIES_DATA_1_2HOUR.MEASURE_ID, TIME_SERIES_DATA_1_2HOUR.TARGET_ID, TIME_SERIES_DATA_1_2HOUR.COLLECTOR_ID, TIME_SERIES_DATA_1_2HOUR.MEASURE_INDEX, TIME_SERIES_DATA_1_2HOUR.ME_ID, TIME_SERIES_DATA_1_2HOUR.VALUE, TIME_SERIES_DATA_1_2HOUR.SUM_VALUE from TIME_SERIES_DATA_1_2HOUR) union all select TIME_SERIES_DATA_1_1DAY.TIME_IN_SECONDS, TIME_SERIES_DATA_1_1DAY.TARGET_TYPE, TIME_SERIES_DATA_1_1DAY.MEASURE_ID, TIME_SERIES_DATA_1_1DAY.TARGET_ID, TIME_SERIES_DATA_1_1DAY.
PAGE 281
Views H ( SELECT de.device_id, cast (de.ip_address as varchar(255)) AS device_ip, tsd.target_type, de.device_id AS target_id, de.sys_name AS target_name, measure.measure_type AS collectible_type, tsd.measure_id AS collectible_id, tsd.collector_id, pdc.name AS collector_name, (measure.name::text || '.'::text) || tsd.measure_index::text AS collectible_name, measure.detail AS collectible_detail, tsd.value, tsd.time_in_seconds, tsd.measure_index FROM time_series_data_info tsd JOIN device de ON tsd.
PAGE 282
H Views tsd.time_in_seconds, tsd.measure_index FROM time_series_data_info tsd JOIN switch_port sp ON (tsd.target_type = 4 OR tsd.target_type = 5 OR tsd.target_type = 6) AND tsd.target_id = sp.id JOIN switch_info vs ON sp.virtual_switch_id = vs.id JOIN pm_data_collector ON pm_data_collector.id = tsd.collector_id JOIN measure ON measure.id = tsd.measure_id UNION ALL SELECT 0 as device_id, cast (de.ip_address as varchar(255)) AS device_ip, tsd.target_type, de.id AS target_id, cast (de.
PAGE 283
Views H 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.INTEROP_MODE as INTEROP_MODE, VIRTUAL_SWITCH.MANAGEMENT_STATE, VIRTUAL_SWITCH.MONITORED, CORE_SWITCH.TYPE as SWITCH_TYPE, CORE_SWITCH.
PAGE 284
H Views and VIRTUAL_PORT_WWN_DETAILS.SLOT_NUMBER = SP1.SLOT_NUMBER and VIRTUAL_PORT_WWN_DETAILS.SWITCH_PORT_NUMBER = SP1.PORT_NUMBER and SP1.TYPE NOT IN ('GigE-Port','TE-Port')) left outer join SWITCH_PORT SP2 on (SP2.VIRTUAL_SWITCH_ID=VS2.ID and VIRTUAL_PORT_WWN_DETAILS.AG_PORT_NUMBER = SP2.PORT_NUMBER and SP2.TYPE NOT IN ('GigE-Port','TE-Port')) left outer join USER_DEFINED_DEVICE_DETAIL UDDD on VIRTUAL_PORT_WWN_DETAILS.AG_NODE_WWN = UDDD.
PAGE 285
Views H VM_PATH.FS_TYPE, VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID, DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID AS HOST_ME_ID, DEVICE_ENCLOSURE.IP_ADDRESS AS HOST_IP_ADDRESS, DEVICE_ENCLOSURE.HOST_NAME AS HYPERVISOR_HOST_NAME, FABRIC.NAME AS FABRIC_NAME, VIRTUAL_SWITCH.NAME AS VIRTUAL_NAME, SWITCH_PORT.STATUS AS SWITCH_PORT_STATUS, SWITCH_PORT.ID as SWITCH_PORT_ID, SWITCH_PORT.PORT_ID, SWITCH_PORT.PORT_NUMBER, SWITCH_PORT.SLOT_NUMBER, USER_DEFINED_DEVICE_DETAIL.NAME AS ADAPTER_PORT_NAME, VM_PATH.FABRIC_ID, VM_PATH.
PAGE 286
H Views DEVICE_ENCLOSURE.IP_ADDRESS as HYPERVISOR_HOST, VM_VIRTUAL_MACHINE.ID as VM_ID, VM_VIRTUAL_MACHINE.IP_ADDRESS AS VM_IP_ADDRESS, VM_VIRTUAL_MACHINE.HOSTNAME AS VM_HOST_NAME, VM_VIRTUAL_MACHINE.UUID as VM_UUID, VM_VIRTUAL_MACHINE.NAME as VM_NAME, VM_PATH.NAME as PATH_NAME, VM_PATH.HBA_PORT as ADAPTER_PORT_WWN, VM_PATH.TARGET_PORT as TARGET_PORT_WWN, VM_STORAGE.NAME as LUN_CAN_NAME, VM_PATH.FS_TYPE, VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID, DEVICE_ENCLOSURE.
PAGE 287
Views H and DEVICE_PORT.NODE_ID = DEVICE_NODE.ID and DEVICE_NODE.FABRIC_ID = FABRIC.ID; comment on view VM_CONNECTIVITY_INFO is 'Combine fabric and VM info to derive end to end connectivity information for the VM'; VM_DATASTORE_DETAILS_INFO create or replace view VM_DATASTORE_DETAILS_INFO as select vm_virtual_machine_datastore_map.virtual_machine_id, vm_virtual_machine_datastore_map.vm_datastore_details_id, vm_datastore_details.datacenter_id, vm_virtual_machine_datastore_map.
PAGE 288
H Views DEVICE_PORT as DEST_PORT, DEVICE_NODE as DEST_NODE, DEVICE_NODE as SOURCE_NODE, EE_MONITOR, EE_MONITOR_STATS where VM_PATH.HBA_PORT::BPCHAR = SOURCE_PORT.WWN and VM_PATH.VM_ID = VM_VIRTUAL_MACHINE.ID and SOURCE_PORT.ID = EE_MONITOR.SOURCE_PORT_ID and EE_MONITOR.ID = EE_MONITOR_STATS.EE_MONITOR_ID and SOURCE_PORT.NODE_ID = SOURCE_NODE.ID and DEST_PORT.ID = EE_MONITOR.DEST_PORT_ID and DEST_PORT.NODE_ID = DEST_NODE.ID and EE_MONITOR_STATS.
PAGE 289
Views H VM_LUN_INFO create or replace view VM_LUN_INFO as select VM_STORAGE.HOST_ID, VM_STORAGE.ID as LUN_ID, VM_STORAGE.NAME as LUN_NAME, VM_STORAGE.TARGET_NODE, VM_STORAGE.VENDOR, VM_STORAGE.MODEL, VM_STORAGE.SERIAL_NUMBER, VM_STORAGE.TYPE, VM_STORAGE.CAPACITY, VM_STORAGE.STATUS as LUN_STATUS, VM_STORAGE.PATH_POLICY, VM_STORAGE.ISCSI_TARGET_ADDRESS, VM_STORAGE.ISCSI_TARGET_PORT, VM_STORAGE.NAS_REMOTE_HOST, VM_STORAGE.NAS_REMOTE_PATH, VM_PATH.FS_TYPE, VM_PATH.ID as PATH_ID, VM_PATH.
PAGE 290
H Views FC_PORT_STATS.INVALIDTRANSMISSIONS, FC_PORT_STATS.CRCERRORS, FC_PORT_STATS.CREATION_TIME, VIRTUAL_SWITCH.NAME as VIRTUAL_NAME, SWITCH_PORT.STATUS as SWITCH_PORT_STATUS, SWITCH_PORT.PORT_ID, SWITCH_PORT.PORT_NUMBER from VM_STORAGE, VM_HOST, DEVICE_ENCLOSURE, VM_VIRTUAL_MACHINE, VM_PATH, DEVICE_PORT, SWITCH_PORT, CORE_SWITCH, FC_PORT_STATS, VIRTUAL_SWITCH where VM_PATH.HBA_PORT::BPCHAR = DEVICE_PORT.WWN and VM_PATH.VM_ID = VM_VIRTUAL_MACHINE.ID and VM_PATH.STORAGE_ID = VM_STORAGE.ID and VM_STORAGE.
PAGE 291
Views H DEVICE_ENCLOSURE, VM_VIRTUAL_MACHINE, VM_PATH, DEVICE_PORT, SWITCH_PORT, CORE_SWITCH, SWITCH_TE_PORT_STATS, VIRTUAL_SWITCH, DEVICE_PORT_MAC_ADDRESS_MAP, DEVICE_PORT_GIGE_PORT_LINK, GIGE_PORT where VM_PATH.HBA_PORT::BPCHAR = DEVICE_PORT.WWN and VM_PATH.VM_ID = VM_VIRTUAL_MACHINE.ID and VM_PATH.STORAGE_ID = VM_STORAGE.ID and VM_STORAGE.HOST_ID = DEVICE_ENCLOSURE.ID and DEVICE_ENCLOSURE.ID = VM_HOST.DEVICE_ENCLOSURE_ID and DEVICE_ENCLOSURE.ID = VM_VIRTUAL_MACHINE.HOST_ID and DEVICE_PORT.
PAGE 292
H Views VR_CONN_DOMAIN on VR_CONN_DOMAIN.ID = VR_CONN_MODULE.VR_CONN_DOMAIN_ID inner join VCEM_PROFILE on VCEM_PROFILE.ID = VR_CONN_DOMAIN.VCEM_PROFILE_ID left outer join VR_CONN_DOMAIN_GROUP on VR_CONN_DOMAIN_GROUP.ID = VR_CONN_DOMAIN.VR_CONN_DOMAIN_GROUP_ID left outer join VIRTUAL_SWITCH on VIRTUAL_SWITCH.WWN = VR_CONN_MODULE.WWN left outer join CORE_SWITCH on CORE_SWITCH.ID = VIRTUAL_SWITCH.CORE_SWITCH_ID inner join FABRIC_MEMBER on FABRIC_MEMBER.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.
PAGE 293
Views H VIRTUAL_SWITCH.WWN = VR_CONN_MODULE.WWN left outer join CORE_SWITCH on CORE_SWITCH.ID = VIRTUAL_SWITCH.CORE_SWITCH_ID left outer join DEVICE_NODE on DEVICE_NODE.WWN = VR_CONN_MODULE.WWN left outer join FABRIC on DEVICE_NODE.FABRIC_ID = FABRIC.ID; VR_CONN_MODULE_PORT_INFO create or replace view VR_CONN_MODULE_PORT_INFO as select VR_CONN_MODULE_PORT.ID, VR_CONN_MODULE_PORT.VR_CONN_MODULE_ID, VR_CONN_MODULE_PORT.WWN, VR_CONN_MODULE_PORT.POSITION_, VR_CONN_MODULE_PORT.
PAGE 294
H Views VR_CONN_SERVER_PROFILE.BAY_NAME, coalesce(VR_CONN_SERVER_PROFILE.BAY_NUMBER, VR_CONN_FC_CONNECTION.CONNECTION_BAY) as BAY_NUMBER, VR_CONN_SERVER_PROFILE.VIRTUAL_SERIAL_NUMBER, VCEM_PROFILE.ID as VCEM_PROFILE_ID, VR_CONN_DOMAIN.ID as VIRTUAL_CONNECT_DOMAIN_ID, VR_CONN_MODULE.ID as VIRTUAL_CONNECT_MODULE_ID, VR_CONN_MODULE_PORT.ID as VIRTUAL_CONNECT_MODULE_PORT_ID, VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID, coalesce(SWITCH_PORT.WWN, VR_CONN_MODULE_PORT.WWN) as UPLINK_PORT_WWN, coalesce(SWITCH_PORT.
PAGE 295
Views H VMM_DISCOVERED_MAC_INFO create or replace view VMM_DISCOVERED_MAC_INFO AS select VM_VIRTUAL_ETHERNET_ADAPTER.MAC_ADDRESS, VM_VIRTUAL_ETHERNET_ADAPTER.DISPLAY_LABEL, VM_VIRTUAL_ETHERNET_ADAPTER.PORT_GROUP_NAME, VM_VIRTUAL_MACHINE.NAME AS VIRTUAL_MACHINE_NAME, VM_VCENTER_MEMBER.HOST_NAME, VM_VCENTER.NAME AS VCENTER_NAME from VM_VIRTUAL_ETHERNET_ADAPTER, VM_VIRTUAL_MACHINE, VM_VCENTER_MEMBER, VM_VCENTER where VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID = VM_VIRTUAL_MACHINE.
PAGE 296
H Views VM_VIRTUAL_ETHERNET_ADAPTER.DISPLAY_LABEL, VM_VIRTUAL_ETHERNET_ADAPTER.PORT_GROUP_NAME, VM_VIRTUAL_MACHINE.NAME as VIRTUAL_MACHINE_NAME, VM_VCENTER_MEMBER.HOST_NAME, VM_VCENTER.NAME as VCENTER_NAME From VM_VIRTUAL_ETHERNET_ADAPTER, VM_VIRTUAL_MACHINE, VM_VCENTER_MEMBER, VM_VCENTER Where VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID = VM_VIRTUAL_MACHINE.ID And VM_VIRTUAL_MACHINE.HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID And VM_VCENTER_MEMBER.VM_VCENTER_ID = VM_VCENTER.
PAGE 297
Views H 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.
PAGE 298
H Views 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 DEVICE_ID, TIME_IN_SECONDS, SRC_MAC, DEST_MAC, IN_VLAN, OUT_VLAN, FRAMES, BYTES from SFLOW_STAGING where SLNUM >= (select MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows only); -- Name: sflow_minute_vlan_view; Type: VIEW; Schema: dcm; Owner: dcmadmin create or replace view SFLOW_MINU
PAGE 299
Views H pi.physical_port_id)) AND (pi.interface_id = i.interface_id)) AND ((i.table_subtype)::text <> 'RADIO_INTERFACE'::text))) l2 LEFT JOIN (SELECT inm_ip_interface.interface_id AS ip_id, inm_ip_interface.ip_interface_id, inm_ip_interface.ip_address, inm_ip_interface.subnet_mask FROM inm_ip_interface) l3 ON ((l2.interface_id = l3.ip_id))); -- Name: wireless_interface; Type: VIEW; Schema: dcm; Owner: dcmadmin CREATE VIEW wireless_interface AS SELECT l2.device_id, l2.device_ip_address, l2.
PAGE 300
H Views SLOT_INFO create or replace view SLOT_INFO as select SLOT.*, PHYSICAL_DEVICE.UNIT_NUMBER, DEVICE.IP_ADDRESS from PHYSICAL_DEVICE, SLOT, DEVICE where DEVICE.DEVICE_ID = PHYSICAL_DEVICE.DEVICE_ID and SLOT.PHYSICAL_DEVICE_ID = PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID; MANAGED_ELEMENT_INFO Common managed element data used by custom DTO methods to identify the managed element type, and provide a link to the details table for the managed element.
PAGE 301
Views H 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 or replace 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.expression_id AS collectible_id, se.
PAGE 302
H Views 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.mib_object_id) AS collectible_name, ( SELECT mib_object.oid AS collectible_detail FROM mib_object WHERE mib_object.mib_object_id = sd.mib_object_id) AS collectible_detail, sd.value, sd.time_in_seconds, sd.mib_index FROM snmp_data_info sd JOIN interface ifs ON sd.
PAGE 303
Views H SELECT de.device_id, de.ip_address AS device_ip, se.target_type, sp.id AS target_id, sp.name AS target_name, 1 AS collectible_type, se.expression_id AS collectible_id, se.collector_id, ( SELECT perf_collector.name AS collector_name FROM perf_collector WHERE perf_collector.collector_id = se.collector_id) AS collector_name, ( SELECT snmp_expression.name AS collectible_name FROM snmp_expression WHERE snmp_expression.expression_id = se.expression_id) AS collectible_name, ( SELECT snmp_expression.
PAGE 304
H Views PNIC_DV_PORT.VM_DV_SWITCH_ID = VM_DV_SWITCH.ID and PNIC_DV_PORT.ID = VM_PHYSICAL_NIC.VM_DV_PORT_ID and VM_PHYSICAL_NIC.ID = VM_HOST_END_DEV_CONNECTIVITY.VM_PHYSICAL_NIC_ID and VM_HOST_END_DEV_CONNECTIVITY.INTERFACE_ID = INTERFACE.INTERFACE_ID and INTERFACE.DEVICE_ID = DEVICE.DEVICE_ID and VM_HOST_END_DEV_CONNECTIVITY.INTERFACE_ID = PHYSICAL_INTERFACE.INTERFACE_ID and PHYSICAL_INTERFACE.PHYSICAL_PORT_ID = PHYSICAL_PORT.PHYSICAL_PORT_ID union all select VM_HOST.
PAGE 305
Views H GIGE_PORT.SWITCH_PORT_ID, GIGE_PORT.PORT_NUMBER, CEE_PORT.ID AS CEE_PORT_ID, CEE_PORT.VIRTUAL_SWITCH_ID, CEE_PORT.IF_INDEX, CEE_PORT.IF_NAME, CEE_PORT.IF_MODE, CEE_PORT.L2_MODE, CEE_PORT.VLAN_ID, CEE_PORT.LAG_ID, CEE_PORT.IP_ADDRESS, CEE_PORT.MAC_ADDRESS, CEE_PORT.PORT_SPEED, CEE_PORT.ENABLED, 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, CEE_PORT.PORT_ROLE, CEE_PORT.