HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100
HP Brocade 8/12c Manual
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
HP Brocade 8/12c manual content summary:
- HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 1
53-1002363-03 ® 26 August 2011 Network Advisor Documentation Updates Supporting Network Advisor 11.1.0 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 2
equipment feature, or service offered or to be offered by Brocade. Brocade reserves the right brocade.com/support/oscd. Brocade Communications Systems, Incorporated Corporate and Latin American Headquarters Brocade Communications Systems, Inc. 130 Holger Way San Jose, CA 95134 Tel: 1-408-333-8000 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 3
Guide In this chapter 3 Operating system requirements 3 Network Advisor migration 3 Chapter 3 Brocade Network Advisor SAN User Manual In this chapter 5 Chapter 1, Getting Started 6 Chapter 4, Application Configuration 6 Chapter 8, Third-party tools 7 Chapter 10, SAN Device Configuration - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 4
41 FC Port Stats 44 FCIP 48 FCIP Tunnel Stats 49 GigE Port Stats 53 License 58 Encryption Device 61 Encryption Container 67 Meta SAN 71 Network 73 Others 73 Port Fencing 74 Quartz 75 Reports 78 Role Based Access Control 78 SNMP 82 Stats 85 Switch 88 Switch details 91 Switch port - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 5
203 VM_CONNECTIVITY_INFO 204 VM_EE_MONITOR_INFO 206 VM_HOST_INFO 206 VM_LUN_INFO 207 VM_STATISTICS_INFO 208 ZONE_DB_INFO 209 MANAGED_ELEMENT_INFO 261 SNMP_DATA_INFO 261 SNMP_EXPR_DATA_INFO 262 SNMP_DATA_VIEW 262 Brocade Network Advisor Documentation Updates v 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 6
vi Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 7
Network Advisor 11.1.X Documentation Updates Publication Title Page Number Brocade Network Advisor Installation Guide Brocade Network Advisor Migration Guide Brocade Network Advisor SAN User Manual Virtual Connect Enterprise Manager Guide Updates on page 1 Updates on page 3 Updates on page - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 8
viii Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 9
1 In this chapter The updates in this chapter are for the Brocade Network Advisor Installation Guide, part number: 53-1002320-01, published May 2010. •Operating system requirements 1 Operating system requirements In Table 5, "Server operating system requirements," on page 14, add ESX - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 10
1 Operating system requirements 2 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 11
chapter The updates in this chapter are for the Brocade Network Advisor Migration Guide, part number: 53-1002321-01, published May 2011 Advisor migration The source path of the HP B-Series SAN Network Advisor is not auto detected in HP B-Series SAN Network Advisor 11.1.1 version. This prevents - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 12
2 Network Advisor migration 4 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 13
party tools 7 •Chapter 10, SAN Device Configuration 7 •Chapter 13, Host Management 9 •Chapter 18, SAN Encryption configuration 9 •Chapter 19, Zoning 10 •Chapter 26, Troubleshooting 10 •Chapter 27, Performance Data 10 •Chapter 31, Technical Support 11 •Appendix E, Database Fields 11 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 14
window Chapter 4, Application Configuration In the section "Configuring an internal FTP server," on page 124 change step 4 as follows: 4. Change your password by entering a new password in the Password and Confirm Password fields. The default password is passw0rd (zero). 6 Brocade Network Advisor - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 15
OS HBA or CNA. 2. Select Configure > Element Manager > HCM. HCM Agent displays. Chapter 10, SAN Device Configuration In the section "Restoring a switch configuration for a selected device," on page 253, replace Figure 92 with the following: FIGURE 92 Restore Switch Configuration dialog box Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 16
on page 256, replace Figure 94 with the following: FIGURE 94 Switch Configuration Repository In the section "Viewing configuration file content," on page 257, replace Figure 95 with the following: FIGURE 95 Configuration file content 8 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 17
a boot image from the repository," on page 318, change the title as follows: Deleting a driver file from the repository Chapter 18, SAN Encryption configuration In the section "Adding target disk LUNs for encryption," on page 516, replace Figure 226 with the following: FIGURE 226 Encryption Disk - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 18
size to 2 MB. Chapter 26, Troubleshooting In the section "Configuring IP ping," on page 748, change the second notes as follows: NOTE IP Perf is not supported on the Fabric OS 8 Gbps Extension Switch or Blade. Chapter 27, Performance Data In the section "SAN performance measures," on page 768, add - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 19
graph configuration," on page 783, add the following note to step 5: NOTE Devices with 10GE ports must have the rmon MIB enabled on the switch. For more information about the rmon collection command, refer to the Fabric OS Converged Enhanced Ethernet Command Reference. Chapter 31, Technical Support - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 20
3 Appendix E, Database Fields 12 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 21
-A In the section "VCEM integration support," on page 9, add the following note: NOTE Discovery of TopologyView and SANActiveConnections will be incomplete for VC modules connected to the end devices due to lack off support in the HP SOAP API. Brocade Network Advisor Documentation Updates 13 53 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 22
4 VCEM integration support 14 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 23
Device 61 •Encryption Container 67 •Meta SAN 71 •Network 73 •Others 73 •Port Fencing 74 •Quartz 75 •Reports 78 •Role Based Access Control 78 •SNMP 82 •Stats 85 •Switch 88 •Switch details 91 •Switch port 95 •Switch SNMP info 100 Brocade Network Advisor Documentation Updates 15 53 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 24
189 •HOST_DISCOVERY_REQUEST_INFO 190 •IFL_INFO 191 •ISL_INFO 191 •ISL_TRUNK_INFO 192 •NPORT_WWN_MAP_INFO 193 •PHANTOM_PORT_INFO 194 •PORT_BOTTLENECK_CONF_INFO 194 •PORT_BOTTLENECK_STAT_INFO 194 •PORT_GROUP_INFO 195 16 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 25
Size KEY_ * Key to identify the specific configuration of the Call varchar 256 Center. CALL_CENTER_ID * ID of the Call Center. int VALUE Value of specific configuration identified by Key of the varchar 256 Call Center. Brocade Network Advisor Documentation Updates 17 53-1002363 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 26
which the switch is assigned. SUPPORT_SAVE 1 = Support save is enabled for the switch. 0 = Support save is disabled for the switch. MANAGED_ELEMENT_ID Managed element Id for the device. Default value is 23 Size 256 256 Size 256 512 18 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 27
State of power supply to the blade. varchar ATTN_STATE varchar SERIAL_NUMBER Factory serial port for a given slot with intelligent blade. varchar DEFAULT_GATEWAY Gateway IP address Ethernet management for a given varchar slot with intelligent blade. PRIMARY_FW_VERSION Primary firmware - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 28
of the capability detected on the core switch. 1 = the capability is enabled on the core switch. Default value is 0. Format int varchar int Client_view TABLE 12 Field USER_ ID * NAME DESCRIPTION PASSWORD EMAIL Definition User name. User description. User password. User e-mail ID. Format int - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 29
created when authenticated through external server. Note: At present there is no direct use of this field however this can be referred in future to build certain reports. Default value 512 32 Size 128 128 Size 128 255 255 Size 255 Brocade Network Advisor Documentation Updates 21 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 30
or "product (switch or device)" or "port"; or varchar combination of these 3 basic categories. Default value is 0. 0 SAN table; usually 1 since there is only int one SAN. WWN of the virtual switch used as seed switch to 256 256 256 22 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 31
was last updated. timestamp ACTIVE_ZONESET_NAME Name of the zone configuration which is effective / varchar 256 active in that fabric switch, when the particular HTML page was changed last. Note that this is not when the last time collection was done. timestamp Size 32 16 Size 256 128 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 32
the zone configuration which is effective / varchar 256 active in that fabric. 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. varchar 256 24 Brocade Network Advisor - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 33
undertaken. varchar Collection name, Java class used to collect specific varchar fabric or switch information. When the last successful switch. Collector name. Last modified time on switch. Format int varchar timestamp TABLE 24 Brocade Network Advisor Documentation Updates 25 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 34
Definition FIRMWARE_ID* SWITCH_TYPE* REBOOT_REQUIRED NUMFILES ID for the firmware file. Switch type that supports this firmware file. Reboot required flag for the switch type. Number of files in the firmware. TABLE 29 Field FIRMWARE_FILE_DETAIL Definition ID* FIRMWARE_NAME MAJOR_VERSION - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 35
location. Port on which FTP server is configured. Format int smallint varchar varchar varchar varchar int TABLE 32 Field SWITCH_T YPE_FIRMWARE_VERSION Definition SWITCH_TYPE* MIN_FOS_VERSION* MAX_FOS_VERSION Switch type. Supported minimum firmware version. Supported maximum firmware version - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 36
FC=0 CEE_RUNNING=1 CEE_STARTUP=2 INVALID=-1 Default value is 0. smallint Brief comments about this configuration. varchar 256 Connected end devices TABLE 34 Field CED_APPLICATION Definition Format Size ID* NAME FABRIC_ID int Name of the application. Application represents a varchar 24 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 37
NUMBER Switch port number to which this device is attached. smallint PORT_ID Device port ID. varchar 6 TYPE Device port type, such as N or NL. varchar 32 SYMBOLIC_NAME Device port symbolic name. varchar 256 FC4_TYPE FC payload protocol. varchar 64 COS FC class of service. varchar - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 38
device property string, e.g., Valid channel port. varchar 16 TABLE 39 Field ports of this device node has translated domain. That device port is set as the Proxy Device and this Device Node is treated as virtual by assigning a value of 1 to this field. Default value is 0. smallint 30 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 39
of the HCM agent running on the host varchar 32 OS_VERSION Operating system version for the enclosure varchar 256 CREATED_BY Module which created this enclosure: 0->Manual, int 1->HBA 2->VM. Default value is 0. Brocade Network Advisor Documentation Updates 31 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 40
is null. Also a foreign key reference to the MANAGED_ELEMENT table. TABLE 42 Field FABRIC Definition Format Size ID* int SAN_ID Foreign key to SAN table; usually 1 since there is only int one SAN. SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to char 23 discover the - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 41
for the fabric. TRACK_CHANGES 1 = changes (member switches, ISL and devices) in smallint the fabric are ACTIVE_ZONESET_NAME Name of the zone configuration which is effective / varchar ID* EE_MONITOR_ID References to the ID in EE_MONITOR table. Format Size int int Brocade Network Advisor - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 42
int The Number (Index) given by the switch when user int creates End-End monitor on the switch. References the ID in SWITCH_PORT table. int References the ID in DEVICE_PORT table and this is an int initiator for EE monitor. 34 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 43
References the ID in DEVICE_PORT table and this is a int target for EE monitor. Name of the End_End Monitor. varchar 124 Error code returned from the switch , when enabling int End-End monitor is attempted on the switch. Status of creating the End-End monitor on the switch Switch or Port - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 44
String is like a varchar 64 STRING password. It is sent along with each SNMP Get-Request and allows (or denies) access to a device. The default value is "public". This is applicable if the agent is configured to operate in SNMPv1. 36 Brocade Network Advisor Documentation Updates 53-1002363 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 45
varchar 16 behalf of this user can be authenticated and if so, which authentication protocol to use. Supported values are: usmNoAuthProtocol usmHMACMD5AuthProtocol usmHMACSHAAuthProtocol This is applicable if the agent is configured to operate in SNMPv3. AUTH_PASSWORD The localized secret - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 46
can be a null and hence maintained as a weak reference. SEVERITY Default value is 7. int AREA Indicates whether the event corresponds to SAN/IP/Application/SAN and IP. Default value is 0. smallint ACKNOWLEDGED 0 =Unack. 1 =Ack Default value is 0. smallint SOURCE_NAME Name of the source - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 47
) server name. varchar Reply E-mail address. varchar E-mail address for which a Test E-mail notification is to varchar be sent. SMTP Port number. int Default value is 25. Size 10 255 Size 15 10 10 4096 4096 45 Size 256 50 512 Brocade Network Advisor Documentation Updates 39 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 48
authentication. Password for authentication. Time interval between successive event notifications. Time interval Unit: 0 = Seconds 1 = Minutes 2 = Hours Default value is 0. Time interval Unit: 0 = Send test to configured 0 = Port Offline 1 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 49
State of the Action: 0 = Action Disabled 1 = Action Enabled Default value is 0. Fabric TABLE 64 SAN Field ID* NAME CONTACT LOCATION DESCRIPTION Definition Name of this SAN. Contact person for this SAN. Location of this SAN. Description. Format int varchar varchar timestamp smallint Size 1024 255 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 50
was last updated. Default value is 'now()'. Format Size smallint timestamp timestamp TABLE 65 Field FABRIC Definition Format Size ID* int SAN_ID Foreign key to SAN table; usually 1 since there is only int one SAN. SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to char - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 51
P timestamp LAST_SUCCESSFUL_TIME STAMP timestamp ENHANCED_TI_ZONE_SUP Holds the value if the fabric has enhanced TI Zone PORT support or not. Default: 0 Values: 0|1. smallint TABLE 67 Field FABRIC_MEMBER Definition Format Size FABRIC_ID* VIRTUAL_SWITCH_ID* TRUSTED CREATION_TIME MISSING - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 52
Database tables and fields FC Port Stats TABLE 68 Field FC_PORT_STATS Definition ID* SWITCH_ID PORT_ID TX References the ID in CORE_SWITCH table. References the ID in SWITCH_PORT . Format Size int int int double precision. 44 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 53
CRCERRORS DATA_GAPS_IN5MIN TABLE 70 Field FC_PORT_STATS_2HOUR Definition ID* SWITCH_ID PORT_ID TX RX TX_UTILIZATION RX_UTILIZATION CREATION_TIME ACTIVE_STATE Brocade Network Advisor Documentation Updates 53-1002363-02 Database tables and fields E Format Size double precision. double - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 54
. smallint smallint Format Size int int int double precision. double precision. double precision. double' precision. timestamp smallint double precision. double precision. double precision. double precision. Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 55
INVALIDTRANSMISSIONS CRCERRORS DATA_GAPS_IN5MIN DATA_GAPS_IN30MIN DATA_GAPS_IN2HOUR Database tables and fields E Format Size double precision. double precision. double precision. double precision. smallint smallint smallint Brocade Network Advisor Documentation Updates 47 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 56
int smallint smallint int TABLE 74 Field FCIP_PORT_TUNNEL_MAP Definition SWITCHPORT_ID* TUNNEL_ID* Switch Port ID. FCIP Tunnel ID. Format Size int int TABLE 75 Field is enabled on that smallint _ID_ENABLED tunnel. 48 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 57
RX TX_UTILIZATION RX_UTILIZATION DROPPED_PACKETS COMPRESSION LATENCY LINK_RETRANSMITS References the ID in FCIP_TUNNEL table. References the ID in CORE_SWITCH table. The precision double precision double precision double precision Brocade Network Advisor Documentation Updates 49 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 58
double precision double precision double precision smallint double precision double precision double precision double precision double precision double precision Format Size int int int 50 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 59
double precision double precision double precision double precision double precision double precision double precision double precision smallint double precision double precision double precision double precision Brocade Network Advisor Documentation Updates 51 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 60
E Database tables and fields TABLE 79 Field FCIP_TUNNEL_STATS_1DAY (Continued) Definition TCP_OOO SLOW_START Counter of TCP out of order SlowStart status from stage 1 to 8 Format Size double precision double precision 52 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 61
* int TUNNEL_ID Tunnel ID for that GigE Port. smallint VLAN_TAG VLAN Tag on the tunnel (if present). int Default value is -1. SOURCE_IP Source IP on which Default value is -1. FICON_TAPE_READ_MAX_O The Value for FICON_TAPE_READ_MAX_OPS on the int PS tunnel. Default value is -1. Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 62
Tunnel (i.e. new smallint Tunnel type on the switch). Default value is 0. VIRTUAL_SWITCH_ID Refers to the virtual switch to which the tunnel record int belongs to. CIRCUIT_COUNT The number of circuits configured on the tunnel. Default value is 1. smallint MISMATCHED_CONFIG_DET Details of the - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 63
authentication. CONNECTED_COUNT Active connections count. Default value is 1. smallint TUNNEL_STATUS_STRING Tunnel Status string value from switch COMPRESSION LATENCY BANDWIDTH References the ID in CORE_SWITCH table. References the ID in int timestamp Brocade Network Advisor Documentation Updates - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 64
double precision double precision double precision Format Size int int int timestamp double precision double precision double precision double precision double precision double precision 56 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 65
timestamp TABLE 88 Field FABRIC Definition Format Size ID* int SAN_ID Foreign key to SAN table; usually 1 since there is only int one SAN. SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to char 23 discover the fabric. NAME User-assigned fabric name. varchar 256 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 66
Format Size int smallint TABLE 90 Field ISL_TRUNK_GROUP Definition ID* VIRTUAL_SWITCH_ID MASTER_USER_PORT Virtual switch DB ID. Port number of master port. Format Size int int smallint License TABLE 91 Field LICENSE_FEATURE_MAP Definition Format Size LICENSE_ID* FEATURE_ID* Foreign - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 67
int Refers to the entry in the CORE_SWITCH table. int Stores the license key obtained from the switch. varchar OS. Default value is 0. smallint MODEL Model type of the switch: 0 = Unknown 1 = Not applicable 2 = Fabric OS switch 3 = M-EOS switch smallint FIRMWARE_VERSION Embedded (Fabric OS - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 68
. It does not apply to Fabric OS switches. VF_ENABLED Default value is 0. smallint VF_SUPPORTED Default value is 0 smallint MANAGED_ELEMENT_ID A unique managed element ID for this physical int switch. Also a foreign key reference to the MANAGED_ELEMENT table. NAT_PRIVATE_IP_ADDRESS NAT - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 69
the switch level. This feature has been removed from Fabric OS. Default value is 0. smallint TAPE_KEY_POLICY No longer used. Previously used to configure in the DTO class. Default value is 0. smallint Size 512 4096 64 Size Brocade Network Advisor Documentation Updates 61 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 70
for this encryption group. varchar Foreign key reference to both the VIRTUAL_SWITCH int table and the CRYPTO_SWITCH table (both switch tables use the same primary key values). Identifies the switch that currently provides central configuration and reporting capabilities for the encryption group - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 71
if no backup key vault is configured. GROUP_LEADER_STATUS Stores the status of the Group leader node int TABLE 98 Field ENCRYPTION_TAPE_POOL Definition Format Size ID* SWITCH_ID ENCRYPTION_ENGINE_ID int No longer used. Tape pools used to belong to specific int switches, but are now shared by - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 72
should be used. After the configured number of days, a new reference to the ENCRYPTION_GROUP int record that identifies the encryption group that this member switch belongs to. MEMBER_IP_ADDRESS The management IP address (IPv4, IPv6, or hostname) of the member switch. varchar 128 64 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 73
as seen by the group leader switch. For possible values see the enum definition in the DTO class. Default value is 0. smallint TABLE 101 QUORUM_CARD_GROUP_MAPPING Field Definition Format Size ID* ENCRYPTION_GROUP_ID SMART_CARD_ID int Foreign key reference to the ENCRYPTION_GROUP for int - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 74
STATE SP_CERTIFICATE EE_STATE int Foreign key reference to both the VIRTUAL_SWITCH int table and the CRYPTO_SWITCH table (both switch tables use the same primary key values). Identifies the switch that contains this encryption engine. For chassis switches, the slot or blade that contains - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 75
the DTO class. smallint DEVICE_TYPE Indicates whether the target storage device is a disk smallint (0) or tape (1) device. TARGET_PORT_WWN The Port WWN of key reference to the int CRYPTO_TARGET_CONTAINER that contains the host for which these LUNs are configured. Brocade Network Advisor - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 76
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 Fabric OS. smallint - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 77
SYSTEM_CARD_STATUS WWN_POOLS_AVAILABLE STATE int Foreign key reference to both the VIRTUAL_SWITCH int table and the CRYPTO_SWITCH table (both switch tables use the same primary key values). Identifies the switch that contains this encryption engine. For chassis switches, the slot or blade that - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 78
keys for NetApp LKM key vaults. varchar The operational status of this Encryption Engine. For int possible values, see the enum definition in the DTO class. Size 4096 70 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 79
fabric Proxy device PID State of the device LSAN_DEVICE record reference Format Size int char 6 varchar 128 int TABLE int SAN_ID Foreign key to SAN table; usually 1 since there is only int one SAN. SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to char 23 discover the - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 80
indications smallint for the fabric. TRACK_CHANGES 1 = changes (member switches, ISL and devices) in smallint the fabric are tracked. STATS_COLLECTION BB_PID_FORMAT Definition Edge Fabric ID. Edge Fabric Port WWN. Backbone Fabric ID. Backbone Fabric Port WWN. Backbone RA TOV. Backbone ED TOV - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 81
ETHERNET_PORT_ID GigE Port ID. int PORT_NUMBER Port Number related to the GigE Port. int SLOT_NUMBER Slot Number related to the GigE Port. int zero. Vendor name. Default is 'none'. Format char varchar varchar Size 64 2048 Size 6 64 32 Brocade Network Advisor Documentation Updates 73 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 82
non-default policies. The default port fencing policies are: For ISL - Default Protocol Error Policy For Link Violation type - Default Link Level Policy For Security - Default Security Policy smallint B_THRESHOLD_LIMIT Threshold Limits for B-Model Switch (Not Supported). int B_THRESHOLD_DURATION - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 83
Core Switch Group 3 = Switch 4 = Port Type 5 = Port List smallint 1 = E_Port 2 = F_Port 3 = FL_Port, Fabric WWN, Switch WWN implements the interface StatefulJob. boolean REQUESTS_RECOVERY Instructs the scheduler whether or not the Brocade Network Advisor Documentation Updates 75 53-1002363- - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 84
The job start time. numeric The job end time (-1 means infinite). numeric varchar Instructs the scheduler to execute the misfired job. smallint Persists the job-related info. bytea 13,0 13,0 13,0 size 95 80 80 80 13,0 16 80 80 76 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 85
job. Name of the job group. Job listener action class instance. Format varchar varchar varchar TABLE 131 QRTZ_CRON_TRIGGERS Field Definition the scheduler. Last fired time in milliseconds. Repeat interval. Misfire instruction. Format varchar numeric numeric varchar size Size 80 80 80 Size 80 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 86
Access Control TABLE 140 USER_ROLE_MAP Field Definition USER_NAME* ROLE_ID* User name. Role ID, which is mapped for the user. Format Size varchar 128 int 78 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 87
Users'' Role is hidden and other roles are visible to user. Default value is 0. smallint TABLE 142 ROLE_PRIVILEGE_MAP Field Definition ROLE_ID* PRIVILEGE_ID Name. Privilege Area. 0= Application 1= SAN 2= IP Format Size int varchar 128 128 Brocade Network Advisor Documentation Updates 79 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 88
through Management applciation Client 1= User created when authenticated through external server. Note: At present there is no direct use of this field however this can be referred in future to build certain reports. Default value is 0. smallint TABLE 148 USER_RESOURCE_MAP Field Definition - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 89
Database tables and fields E TABLE 150 RESOURCE_FABRIC_MAP Field Definition RESOURCE_GROUP_ID* FABRIC_ID* Resource group ID. Fabric ID, which is in the resource group. Format Size int int Brocade Network Advisor Documentation Updates 81 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 90
applicable if the agent is configured to operate in SNMPv3. AUTH_PASSWORD The localized secret key used by the authentication varchar 64 protocol for authenticating messages. This is applicable if the agent is configured to operate in SNMPv3. 82 Brocade Network Advisor Documentation Updates - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 91
is applicable if the agent is configured to operate in SNMPv3. TABLE 153 SNMP_PROFILE Field Definition Format Size NAME* A text string representing a set of SNMP agent varchar 256 profile. When created, one or more virtual switches could refer to this profile for its SNMP credentials - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 92
on behalf of this user can be authenticated and if so, which authentication protocol to use. The supported values for this field are: usmNoAuthProtocol, usmHMACMD5AuthProtocol, and usmHMACSHAAuthProtocol. This is applicable if the agent is configured to operate in SNMPv3. AUTH_PASSWORD The - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 93
ports(5,10,15,20). varchar Types of ports (FC reference line. int The measure of FC/FCIP/GE. varchar The additional measures. int TABLE 156 USER_ Field ID * NAME DESCRIPTION PASSWORD invalid login attempts. Note: After successful login this filed will be set to NULL. Default value is 0. - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 94
created through Management applciation Client 1= User created when authenticated through external server. Note: At present there is no direct use of this field however this can be referred in future to build certain reports. Default value is 0. smallint TABLE 157 STATS_AGING Field Definition - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 95
ports (FC/FCIP/GE) and -End Monitors. varchar 40 SELECTION_FILTER The time interval in which the graph is shown. varchar 40 FROM_TIME Always null. The default Additional measures based on the int FAVORITE.MAIN_MEASURE Brocade Network Advisor Documentation Updates 87 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 96
is in AG mode; otherwise, 0. smallint Role of the switch. varchar FCS role of the switch. varchar 1 = switch is AD-capable. smallint Fabric IDID mode. smallint Operation status of switch. varchar Maximum size of zone configuration on the switch. int Time at which this record was created - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 97
is registered smallint with the switch to receive SNMP traps. Default value is 0. USER_IP_ADDRESS User-assigned IP address. This is used for M-EOS varchar 128 switches where Fabric OS seed switch fails to get the IP address of the M-EOS switch. Brocade Network Advisor Documentation Updates - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 98
. It does not apply to Fabric OS switches. VF_ENABLED Default value is 0. smallint VF_SUPPORTED Default value is 0 smallint MANAGED_ELEMENT_ID A unique managed element ID for this physical int switch. Also a foreign key reference to the MANAGED_ELEMENT table. NAT_PRIVATE_IP_ADDRESS NAT - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 99
Field Definition Format Size DESCRIPTION MODEL REMARK Model description, such as FC link speed, port count varchar 256 and whether multi-card (director) class switch or other type of switch. Default is 'Not Available'. Switch model string. varchar 32 Remarks, such as an internal project - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 100
Definition Format Size FC_MASK Subnet mask for FC IP. char 64 FC_IP Fibre Channel IP address. char 64 FC_CERTIFICATE smallint Time zone configured on the switch. varchar 32 MAX_PORT Number of maximum ports physically allowed on the smallint switch. CHASSIS_SERVICE_TAG varchar - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 101
name. varchar 64 TYPE SWBD type number as given by Fabric OS. Default value is 0. smallint MODEL Model type of the switch: 0 = Unknown 1 = Not applicable 2 = Fabric OS switch 3 = M-EOS switch smallint FIRMWARE_VERSION Embedded (Fabric OS or M-EOS) software version. varchar 128 VENDOR - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 102
. It does not apply to Fabric OS switches. VF_ENABLED Default value is 0. smallint VF_SUPPORTED Default value is 0 smallint MANAGED_ELEMENT_ID A unique managed element ID for this physical int switch. Also a foreign key reference to the MANAGED_ELEMENT table. NAT_PRIVATE_IP_ADDRESS NAT - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 103
on which the GigE Port is present. int ENABLED Enabled or disabled. Default value is 0. smallint SPEED Port speed details. Default value is 0. bigint MAX_SPEED Port maximum speed supported. bigint MAC_ADDRESS MAC Address of that port. varchar 64 PORT_NAME GigE Port Name. varchar 64 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 104
smallint MAC_ADDRESS MAC address of this port. varchar 64 PORT_MOD varchar 64 TYPE Port type. The specific mode currently enabled for the varchar 16 port. FULL_TYPE Port type. varchar 128 STATUS The current status of the switch port. varchar 64 HEALTH varchar 16 STATUS_MESSAGE - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 105
. But this will be holding the previous status of the PORT. These values to be populated by switch asset collector. varchar AUTO_DISABLE_CONFIGUR ED To represent auto disable configuration state (set by user). Default value is 0. smallint AUTO_DISABLED To represent auto disabled status (set - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 106
Default Area id of F-Port trunk port. Default value is -1. smallint LOGICAL_PORT_WWN Logical port WWN of F-Port trunk group. char 23 PREVIOUS_TYPE This fields copies the old state of the port type. The varchar 16 field could be used to track the state change information for the switch port - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 107
is in AG mode; otherwise, 0. smallint Role of the switch. varchar FCS role of the switch. varchar 1 = switch is AD-capable. smallint Fabric IDID mode. smallint Operation status of switch. varchar Maximum size of zone configuration on the switch. int Time at which this record was created - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 108
DESCRIPTION References the ID in CORE_SWITCH table. int References the ID in THRESHOLD_POLICY table. int The status of applied to the switch. * POLICY_ID* References the ID in FABRIC table int References the ID in THRESHOLD_POLICY table int 100 Brocade Network Advisor Documentation - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 109
USER_NAME PASSWORD switch supports FCoE. Default value is 0. smallint If the switch supports L2. smallint If the switch supports L3. smallint Logical Fabric Enabled/Disabled for a Virtual Switch. smallint Default value is 0. Size 64 23 32 16 128 128 128 32 32 2048 256 256 256 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 110
ADDRESSING_MODE This column to represent the logical switch addressing modes to assign Port Addresses, There are three different addressing modes supported. Fixed (0), Flat or 10 bit (1), Dynamic (2). Default value is -1. smallint 102 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 111
ID for this virtual switch. int Also a foreign key reference to the MANAGED_ELEMENT table. 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 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 112
default list. Format smallint smallint TABLE 185 SELECTED_FLYOVER_PROPERTY Field Definition Format PROPERTY_ID* USER_NAME* POSITION_ Refers to be displayed for the Tool Menu. A Tool in the TOOL_PATH table where the tools are defined. Default path for launching the tool. Short cut key stroke - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 113
launch a particular tool. Second condition value to be satisfied by a selected varchar 256 product to launch a particular tool. The tool to be used zone configuration. Zoning commands support transaction. McData switch default zoning mode. McData switch safe zoning mode. Zone configuration - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 114
Default value is 0. Format Size int varchar 128 smallint TABLE 192 LSAN_ZONE_MEMBER Field Definition LSAN_ZONE_ID* MEMBER_PORT_WWN* LSAN_ZONE record reference. saved to text switch. TI_CONTENT saved online TI zone content before text offline was saved to switch. text text Zoning - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 115
TI zones only, zone is activated. Default value is 0. Configured Failover state of the TI Zone. Configured active state of the TI Zone. saved to switch timestamp. Created by user name. Last modified by user name. Last saved to switch user name Brocade Network Advisor Documentation Updates 107 53-1002363 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 116
configuration. Zoning commands support transaction. McData switch default zoning mode. McData switch safe zoning mode. Zone configuration string length. Available zone DB size in the switch. Default value 256 Size 256 1024 255 Size 108 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 117
of AOR HOST ID which is in the AOR Format Size int int TABLE 210 AOR_INM_PORT_GROUP_MAP Field Definition AOR_ID PORT_GROUP_ID ID of AOR IP of port group Format Size int int Brocade Network Advisor Documentation Updates 109 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 118
IP_ADDRESS USER_NAM LOCATION PASSWORD int The enabled/disabled state of automatic trace dump smallint transfer on the switch The protocol Unknown(0)/ date of Boot Image file RELEASE_DATE Release date of Boot Image file RELEASE_NOTES_LOCATI Release notes location in Management applciation ON - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 119
, 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. The default value is 0. int ENABLED State. The - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 120
Map set on the port Indicate if 802.1x authentication is enabled on this port. The default value is 0. default value is 0. varchar 64 HARDWARE_PATH Hardware path of the port varchar 256 STATUS Status of the Eth port. The default value is -1. varchar 64 CNA_PORT_ID ID of the parent port - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 121
of the CNA port int Port WWN of the port char Node WWN of the port char Port type CNA/FC varchar Name of the port varchar MAC address of the port. varchar Media of the port varchar State of the port. varchar ID of the port. int timestamp Factory configured Port WWN defined for - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 122
key reference to the default value is 0. REKEY_INTERVAL The number of days that data encryption keys should int be used before automatically generated a new key. 0 = infinite, i.e., no re-keying. VOLUME_LABEL_PREFIX A user-configured string used to construct the varchar 256 Brocade-specific - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 123
LUN data. This property does not need to be persisted. smallint 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 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 124
Configuration. Feature available only from 6.4 release onwards and for RSA key vaults. CryptoLun collector and CryptoLunBean fills in this value. The default value VT_PORT_WWN The Port WWN of the Virtual Target that represents the char 23 real physical target device. 116 Brocade Network Advisor - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 125
class. Default value is 0. smallint DEVICE_TYPE Indicates whether the target storage device is a disk (0) or tape (1) device. Default value is 0. smallint TARGET_PORT_WWN The Port information varchar 256 CONFIGURATION_STATUS Configuration status. Default value is 0. smallint - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 126
switches with a single embedded encryption engine. Not used. Previously used to indicate the engine''s operational status. Replaced by EE_STATE. The default value is 0. smallint Foreign key reference feature is not yet supported. The default value is 'disabled'. the DTO class The default value - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 127
deployment mode. Only Transparent mode is currently supported. All switches in the Encryption Group share the same configured on the Encryption Engine. In manual mode, encryption continues running on the backup encryption engines until manually changed. The default value is 0. smallint Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 128
(RKM), 2 = Brocade internal key storage (for demo use only). The default value is 0. smallint PRIMARY_KEY_VAULT_ID Foreign key reference to the KEY_VAULT record that int describes the primary key vault for this Encryption Group. Null if no primary key vault is configured. BACKUP_KEY_VAULT_ID - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 129
a part of call home messages. Call home customers(Connect EMC, IGS Cather) are using this field. The default value is 0. This column was introduced to handle Call home use int cases for MEOS switches. ACH module will be depending on this value to create call home messages and dispatch it to call - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 130
NODE_WWN Populated only for SAN events PORT_WWN Populated only for SAN events OID VIRTUAL_FABRIC_ID Virtual Fabric Id of the switch UNIT From INM EVENT_MAIN table SLOT From INM EVENT_MAIN table PORT From INM EVENT_MAIN table PRODUCT_ADDRESS RAS_LOG_ID Reference to RAS_LOG table. This - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 131
Field Definition FILTER_ID RECIPIENT_ID Format Size int int TABLE 241 EVENT_FWD_FILTER_TRAP_OID Field Definition ID FILTER_ID OID_VALUE OID_NAME Format Size int int varchar 256 varchar 64 Brocade Network Advisor Documentation Updates 123 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 132
Alert 3- Critical 4- Error 5- Warning 6- Notice 7- Info 8- Debug. The default value is 0. smallint The sequence number of an event instance that''s specific to the policy. The default value is 0. smallint Stores the Message ID(s) configured for Custom Event varchar Type TABLE 243 EVENT_MODULE - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 133
Group int Do not maintain it as a foreign key constraints. The default value is 0. A reference key to the Port Group int Do not maintain it as a foreign key constraints. The default value is 0. Size 256 1024 256 2048 Size Brocade Network Advisor Documentation Updates 125 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 134
selected from available list of sources. The default value is 0. IP address of source EVENT_ID The fully qualified processor class name which will be invoked int config in the fabric.The default value is 0. TABLE 249 Field Circuit smallint from the switch COMPRESSION_ ENABLED Whether Compression - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 135
value is 0. smallint Circuit metric to set priority. int The default value is -1 Class of service as defined by int IEEE 802.1p for circuit. The default value is -1. DiffServe marking for Data int Frame. The default value is -1 Brocade Network Advisor Documentation Updates 127 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 136
the list of such mismatched configurations. varchar CIRCUIT_STATUS_STRING Circuit Status string value from switch for the tunnel varchar 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 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 137
Primary key of the Switch int Port The number of octets or int bytes that have been transmitted by this port. One second periodic polling of the port. This value is saved and compared with the next polled value to compute net throughput. Note, for Fibre Channel, ordered sets are not - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 138
whether the fcoe device is directly attached to smallint the switch''s TE port or to a cloud. ATTACH_ID The primary key of the port (if direct attached) or cloud int (if not by SMIA and values filled in by Switch Asset Collector 130 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 139
the FRU element, int requested by SMIA and values filled in by Switch Asset Collector will be available only from FOS 6.4 switches and above. The default value is -1. TOTAL_OUTPUT_POWER provides the total power output of the power supply FRU element, requested by SMIA and values filled in by - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 140
id of the switch TE port that this member connects to. int int int smallint timestamp smallint timestamp TABLE 255 HBA Field Definition Format Size ID int HOST_ID Primary key. int NAME User defined name of the HBA varchar 128 POWER_MODE Power mode of the HBA varchar 256 MODEL - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 141
varchar 32 The default value is 'FC'. WWN WWN of the adapter varchar 23 HCM_AGENT_VERSION Version of HCM agent used to varchar 128 managed the HBA MAC_ADDRESS Adapter mac address varchar 64 MAX_SPEED_SUPPORTED The maximum port speed that is int supported on the port, in Gb/s. The - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 142
of VM Discovery indicating int VM_MANAGEMENT_STA success or failure. The default value TE is 0. The status of HBA discovery using int JSON_MANAGEMENT_ST JSON agent, indicating success or ATE failure. The default value is 0. 134 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 143
of HBA Discovery using int CIM_MANAGEMENT_STA CIM, indicating success or failure. TE The default vault varchar( The TCP port number for the key vault int The key vault''s public key certificate. Switches use this to establish a Brocade Network Advisor Documentation Updates 135 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 144
Static or dynamic (1=dynamic, 2=static) LACP active or passive (1=active, 2=passive) valid if mode=dynamic Trunking type (1=standard, 2=brocade, 3=hybrid) L2 or L3 mode Type of L2 mode (default=access stores the MAC ACL policy information of the LAG Comma separated vlan id list. Primary IPAddress of - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 145
CATEGORY ENABLE Description of the rule Scope of the rule - is it applicable to Fabric, switch or ports Category of the rule - is it used by unknown - 0, asset collection - 1, or 2 - the license manager service Whether the rule needs to be considered or not. 1 consider, 0 - do not consider for - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 146
password varchar 512 TABLE 268 PHANTOM_PORT Field Definition Format Size ID int WWN The Wwn of the phantom port. char 23 VIRTUAL_SWITCH_ID The id of the phantom switch. int PORT_NUMBER The port number of the phantom port. The default the switch port that the int configuration - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 147
default value is 0. CREATION_TIME LAST_UPDATE_TIME Creation time of the record. Last update time of the record. TABLE 270 PORT_BOTTLENECK_STATUS Field Definition SWITCH_PORT_ID STATUS The database ID of the switch port 80 80 80 Brocade Network Advisor Documentation Updates 139 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 148
, which can be either normal or trial. Values are: permanent(1), trial(2).The default value is 1. smallint Expiry Date of the trial license. For normal license, the value is 0. varchar Size Size 16 256 Size Size 24 64 24 19 140 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 149
is the foreign key reference key to the Device the Real Server REAL_SERVER_IP_ADDRES S REAL_SERVER_PORT The Port Number for the Real Server TABLE 279 Format int smallint DEVICE_ID IP_ADDRESS NAME This is the foreign key reference key to the Device Table The IP Address for the Virtual - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 150
WT_ARCHIVE Field Definition Format FIRMWARE_VERSION JAR_LIST Firmware version for which jar files are port; for example, FCP Initiator varchar IP of the switch, the V port is connected to varchar VF ID for the V port smallint Size 128 Size Size Size 128 256 Size 32 256 128 142 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 151
port of the VCENTER server on the host. int The default value is 443 . The username to login into the VCENTER varchar 64 The password to switch the virtual fcoe port belongs int to. PORT_WWN WWN of port varchar 64 PORT_SPEED Will be 10G. varchar 32 PORT_TYPE Will be Virtual-FCoE-Port - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 152
port (for MarchingAnts) double precision The time this stats record was created timestamp Used for error scenario smallint Link failures double precision TX Link resets double precision RX link resets double precision 144 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 153
precision double precision double precision double precision double precision smallint smallint smallint Format Size int int int double precision double precision double precision double precision Brocade Network Advisor Documentation Updates 145 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 154
double precision double precision smallint smallint Format Size int int int double precision double precision double precision double precision smallint double precision double precision 146 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 155
OS default value is 0. User-assigned name for the VM varchar 80 Optional user-entered notes describing default value is 0. Number of virtual CPUs used by the VM. int The default value is 0. Summary of CPU resource configuration Brocade Network Advisor Documentation Updates 147 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 156
swap file, and configuration data varchar DATASTORE_LOCATION The location of the VMs datastore May be a SAN target disk or a Reached 2: Password Expired 3: Password History Policy Violated 4: Password Format Policy Violated Note: This numeric Brocade Network Advisor Documentation Updates 53-1002363 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 157
key of Virtual Switch which this port is int present The number of octets or bytes that have been transmitted by this port. One second periodic polling of the port. This value is saved and compared with the next polled value to compute net throughput. Note, for Fibre Channel, ordered sets are - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 158
Count of Link resets. This is the number LRs transmitted. Note, this is a Fibre Channel only stat double precision Count of instances of synchronization loss detected at port. This count is part of the Link Error Status Block (LESB). (FC-PH 29.8). Note, this is a Fibre Channel only stat. double - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 159
The number of octets or bytes that have been received by this port. One second periodic polling of the port. This value is saved and compared with the next polled value to compute net throughput. Note, for Fibre Channel, ordered sets are not included in the count double precision The computed - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 160
switch int PORT_ID The primary key of the port int TRANSMIT_OK 'The number of valid frames sent from the port including FCS octets) of between 64 and 1518 octets and had a bad FrameCheck Sequence (FCS) with either an FCS Error or Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 161
timestamp smallint double precision double precision double precision double precision double precision double precision double precision double precision double precision double precision smallint smallint smallint Brocade Network Advisor Documentation Updates 153 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 162
precision double precision double precision double precision double precision double precision double precision double precision double precision double precision smallint smallint Format Size int int Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 163
ID int ENCRYPTION_ENGINE_ID Foreign key reference to the ENCRYPTION_ENGINE int for which a system card is registered SMART_CARD_ID Foreign key reference to the SMART_CARD that is int registered as a system card for the encryption engine. Brocade Network Advisor Documentation Updates 155 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 164
NOTES PUBLIC_CERTIFICATE CERTIFICATE_LABEL GROUP_NAME CREATION_TIME int Indicates how this smart card is configured: 0 = authorization card. The default varchar card User-supplied notes about the card. up a secure communications channel to the card. varchar the card. The default value is 'now()'. - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 165
ID MIB OID used for collection Target/Source type can be device:0 or interface/ports:1 DB Id of the target which can be device or interface Value collected by double precision Size 256 Size (2,0) 256 Size (2,0) 256 Size Brocade Network Advisor Documentation Updates 157 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 166
type can be device:0 or interface/ports:1' DB Id of the target which authentication password for v3 traps varchar 64 PRIV_PROTOCOL privacy protocol used for v3 traps varchar 16 PRIV_PASSWORD varchar 64 POSITION_ order of credentials to authenticate v1/v2c or v3 int traps 158 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 167
FRU_TYPE provides the type of the sensor, requested by SMIA int and values filled in by Switch Asset Collector will be available only from FOS 6.4 switches and above. The values represents FAN,PS, SLOT etc. The default value is -1. Brocade Network Advisor Documentation Updates 159 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 168
Asset Collector will be available only from FOS 6.4 switches and above. This gives the value whether the FRU is On or Off . The default value is -1. TABLE 314 SCOM_HOST Field Definition Format ID HOST DOMAIN USER_NAME PASSWORD VERSION TOKEN_ID STATUS int The FQDN or the ip address of the - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 169
device as reported by each HBA port. The default value is 0. Format int int Port The logical unit number of Fibre Channel Protocol (FCP) device. The default value is 0. The capacity of the logical unit. The default value is 0. int int varchar int Size 128 128 512 255 50 size size 16 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 170
256 FC_ADDRESS FC Address for the port in hex varchar 6 FRAME_DATA_SIZE The frame size, in bytes, of the device. int The default value is 512. SPEED The default value is rate varchar 256 limiting on the remote port 162 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 171
in the PCI Bus. The default value is varchar 32 0. FCP_IM_STATE Indicates whether the Fibre Channel Protocol Input varchar 128 Method (FCP-IM) is online or offline. IO_LATENCY_MIN Minimum IO Latency value (< 79) in milliseconds and varchar 32 is calculated when HBA port starts SCSI (FCP - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 172
the principal switch of the fabric, HBA is varchar 128 connected to HBA_ID HBA ID of the HBA this port belongs to int PORT_NUMBER The default value is -1. smallint NAME Name defined for the HBA port in HCM varchar FACTORY_PORT_WWN Factory configured Port WWN defined for the HBA port in - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 173
0. smallint PATH_TIME_OUT The value between 0 to 60 that specifies the time out int session. Note you can only enable or edit the path time out when MPIO is disabled. LOGGING_LEVEL The default value is 0. The port logging level. Values include Log Critical, Log Error, Log Warning, and Log Info - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 174
configured authentication algorithm. The default value is 'MD5'. varchar 64 FCSP_GROUP The DH Group (DH Null, group 0 is the only option). The default value is 0. smallint FCSP_ERROR_STATUS The health status of the Fibre Channel if port was disabled during smallint preboot.. The default value - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 175
type varchar 32 ADAPTER_NODE_WWN char 23 FABRIC_ID int ADAPTER_PORT_TYPE The type of the port eg. 1 for vport, 0 for physical int port. The default value is 0. STORAGE_VENDOR varchar 128 STORAGE_MODEL varchar 128 Brocade Network Advisor Documentation Updates 167 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 176
CAPACITY STATUS Definition Format Size Identifies a server running a supported hypervisor. int The ID value is the same as VMware, 2 = Hyper-V. The default value is 0. smallint Number of CPUs in the server. int The default value is 0. Text summary of CPU hardware, such as: Intel(R) varchar - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 177
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. HBA_PORT_WWN The HBAs physical port WWN for this path char 23 VM_PORT_WWN The initiator port WWN used by the VM. If NPIV - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 178
is the same as the node WWN of one of the HBAs in the host. TARGET_NODE_WWN The node WWN of the destination target char 23 HBA_NAME The hypervisor CEE_PORT.IP_ADDRESS, CEE_PORT.MAC_ADDRESS, CEE_PORT.PORT_SPEED, CEE_PORT.ENABLED, 170 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 179
as ETH_PORT_CREATION_TIME, CNA_ETH_PORT.CURRENT_MAC_ADDRESS as CURRENT_MAC_ADDRESS 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 Brocade Network Advisor Documentation Updates 171 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 180
.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.ETHERNET_MASK, CORE_SWITCH_DETAILS.FC_MASK, CORE_SWITCH_DETAILS.FC_IP, 172 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 181
, 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, Brocade Network Advisor Documentation Updates 53-1002363-02 Views E 173 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 182
= ENCRYPTION_ENGINE.SWITCH_ID; SWITCH_INFO create or replace view SWITCH_INFO as select CORE_SWITCH.ID as PHYSICAL_SWITCH_ID, CORE_SWITCH.NAME as PHYSICAL_SWITCH_NAME, CORE_SWITCH.IP_ADDRESS, CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN, 174 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 183
VIRTUAL_SWITCH.LAST_UPDATE_TIME, VIRTUAL_SWITCH.USER_NAME, VIRTUAL_SWITCH.PASSWORD, VIRTUAL_SWITCH.MANAGEMENT_STATE, VIRTUAL_SWITCH.STATE, VIRTUAL_SWITCH PORT_BASED_ROUTING, VIRTUAL_SWITCH.IN_ORDER_DELIVERY, VIRTUAL_SWITCH.INSISTENT_DID_MODE, Brocade Network Advisor Documentation Updates 175 53- - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 184
as DEVICE_PORT_SYMBOLIC_NAME, DEVICE_PORT.FC4_TYPE, 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, 176 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 185
.VIRTUAL_SWITCH_ID, N2F_PORT_MAP.N_PORT, N2F_PORT_MAP.F_PORT, AG_N_PORT.REMOTE_PORT_WWN as EDGE_SWITCH_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 Brocade Network Advisor Documentation Updates 53-1002363-02 Views E 177 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 186
; DEVICE_PORT_INFO create or replace 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, 178 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 187
VS1 on SWITCH_PORT.VIRTUAL_SWITCH_ID = VS1.ID left outer join VIRTUAL_SWITCH VS2 on VIRTUAL_FCOE_PORT.VIRTUAL_SWITCH_ID = VS2.ID left outer join FABRIC on DEVICE_NODE.FABRIC_ID = FABRIC.ID; Brocade Network Advisor Documentation Updates 179 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 188
, 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.VIRTUAL_FABRIC_ID as DEST_VIRTUAL_FABRIC_ID from 180 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 189
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.PORT as PORT, EVENT_DETAILS.OID, EVENT_CALL_HOME.EVENT_NUMBER as EVENT_NUMBER, EVENT_CALL_HOME.FRU_CODE as FRU_CODE, EVENT_CALL_HOME.REASON_CODE as - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 190
view FABRIC_INFO as select FABRIC.ID, FABRIC.SAN_ID, FABRIC.SEED_SWITCH_WWN, FABRIC.NAME, FABRIC.ACTIVE_ZONESET_NAME, FABRIC.MANAGEMENT_STATE, FABRIC.LAST_FABRIC_CHANGED, FABRIC.SECURE, FABRIC.AD_ENVIRONMENT, FABRIC.MANAGED, 182 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 191
.ADMIN_STATUS, FCIP_TUNNEL_CIRCUIT.METRIC, FCIP_TUNNEL_CIRCUIT.DATA_L2_COS, FCIP_TUNNEL_CIRCUIT.DSCP_DATA, FCIP_TUNNEL_CIRCUIT.MAX_RETRANSMISSIONS, FCIP_TUNNEL_CIRCUIT.SLOT_NUMBER, FCIP_TUNNEL_CIRCUIT.VE_PORT_NUMBER, Brocade Network Advisor Documentation Updates 183 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 192
, FCIP_TUNNEL.FICON_TAPE_READ_MAX_OPS, FCIP_TUNNEL.FICON_TAPE_WRITE_TIMER, FCIP_TUNNEL.FICON_TAPE_MAX_WRITE_CHAIN, FCIP_TUNNEL.FICON_OXID_BASE, FCIP_TUNNEL.FICON_XRC_EMULATION_ENABLED, FCIP_TUNNEL.FICON_TW_EMUL_ENABLED, 184 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 193
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 = DEVICE_NODE.ID; Brocade Network Advisor Documentation - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 194
.VIRTUAL_SWITCH_ID, SWITCH_PORT.USER_PORT_NUMBER, VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID from GIGE_PORT_ETHERNET_CLOUD_LINK, GIGE_PORT, SWITCH_PORT, VIRTUAL_SWITCH where GIGE_PORT_ETHERNET_CLOUD_LINK.SWITCH_PORT_ID = GIGE_PORT.ID and 186 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 195
, HBA_PORT.SUPPORTED_COS, HBA_PORT.TRUSTED as HBA_PORT_TRUSTED, HBA_PORT.CREATION_TIME as HBA_PORT_CREATION_TIME, HBA_PORT.MISSING as HBA_PORT_MISSING, HBA_PORT.MISSING_TIME as HBA_PORT_MISSING_TIME, HBA_PORT.OPERATING_SPEED, Brocade Network Advisor Documentation Updates 53-1002363-02 Views E 187 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 196
.FCF_FCMAP, HBA_PORT_FCOE_DETAILS.FCF_FPMA_MAC, HBA_PORT_FCOE_DETAILS.FCF_MAC, HBA_PORT_FCOE_DETAILS.FCF_MODE, HBA_PORT_FCOE_DETAILS.FCF_NAMEID, HBA_PORT_FCOE_DETAILS.FCPIM_MPIO_MODE, HBA_PORT_FCOE_DETAILS.PORT_LOG_ENABLED, Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 197
.CAPACITY, HBA_REMOTE_PORT_LUN.BLOCK_SIZE, HBA_REMOTE_PORT_LUN.VENDOR as LUN_VENDOR, HBA_REMOTE_PORT_LUN.PRODUCT_ID as LUN_PRODUCT_ID, HBA_REMOTE_PORT_LUN.PRODUCT_VERSION as LUN_PRODUCT_VERSION, HBA_REMOTE_PORT_LUN.PRODUCT_SERIAL_NO, Brocade Network Advisor Documentation Updates 189 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 198
, DEVICE_ENCLOSURE.OS, DEVICE_ENCLOSURE.APPLICATIONS, DEVICE_ENCLOSURE.DEPARTMENT, DEVICE_ENCLOSURE.CONTACT, DEVICE_ENCLOSURE.LOCATION, DEVICE_ENCLOSURE.DESCRIPTION, DEVICE_ENCLOSURE.COMMENT_, DEVICE_ENCLOSURE.IP_ADDRESS, DEVICE_ENCLOSURE.VENDOR, DEVICE_ENCLOSURE.MODEL, 190 Brocade Network Advisor - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 199
Views E DEVICE_ENCLOSURE.SERIAL_NUMBER, DEVICE_ENCLOSURE.FIRMWARE, DEVICE_ENCLOSURE.USER_DEFINED_VALUE1, DEVICE_ENCLOSURE.USER_DEFINED_VALUE2, or replace view ISL_INFO as select distinct ISL.ID, ISL.FABRIC_ID, ISL.COST, ISL.TYPE, Brocade Network Advisor Documentation Updates 191 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 200
DEST_SWITCH_PORT.CATEGORY = 1 and DEST_SWITCH_PORT.USER_PORT_NUMBER = ISL.DEST_PORT_NUMBER and FABRIC.ID = ISL.FABRIC_ID; ISL_TRUNK_INFO create or replace view ISL_TRUNK_INFO as select ISL_TRUNK_GROUP.ID, ISL_INFO.COST, 192 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 201
yet online and if a device is connected to AG through some F-Port that is mapped to some other N-Port that is online then AG will use that mapping. create or replace and NPORT_WWN_MAP.DEVICE_PORT_WWN = AG_F_PORT.REMOTE_PORT_WWN; Brocade Network Advisor Documentation Updates 193 53-1002363 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 202
.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID; PORT_BOTTLENECK_CONF_INFO This view provides combine port bottleneck configuration and enough information from switch port for the client to identify the port. create or replace view PORT_BOTTLENECK_CONF_INFO as select PORT_BOTTLENECK_CONFIG.SWITCH_PORT_ID - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 203
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; Brocade Network Advisor Documentation Updates 195 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 204
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, 196 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 205
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 .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 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 206
, SC.CARD_TYPE, SC.CARD_INFO, SC.CARDCN_ID, SC.FIRST_NAME, SC.LAST_NAME, SC.NOTES, SC.CREATION_TIME, EE.ID ENGINE_ID, -1 ENCRYPTION_GROUP_ID, '' GROUP_NAME, -1 CARD_POSITION, CORE_SWITCH.MANAGED_ELEMENT_ID as CORE_MANAGED_ELEMENT_ID, 198 Brocade Network Advisor Documentation Updates 53 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 207
VIRTUAL_SWITCH.LAST_UPDATE_TIME, VIRTUAL_SWITCH.USER_NAME, VIRTUAL_SWITCH.PASSWORD, VIRTUAL_SWITCH.MANAGEMENT_STATE, VIRTUAL_SWITCH.STATE, MANUFACTURER, CORE_SWITCH_DETAILS.PLANT_OF_MANUFACTURER, CORE_SWITCH_DETAILS.SEQUENCE_NUMBER, Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 208
.LOCKED_PORT_TYPE, SWITCH_PORT.CATEGORY, SWITCH_PORT.PROTOCOL, SWITCH_PORT.SPEED, SWITCH_PORT.SPEEDS_SUPPORTED, SWITCH_PORT.MAX_PORT_SPEED, SWITCH_PORT.DESIRED_CREDITS, SWITCH_PORT.BUFFER_ALLOCATED, SWITCH_PORT.ESTIMATED_DISTANCE, 200 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 209
from SWITCH_PORT, CORE_SWITCH, VIRTUAL_SWITCH, CORE_SWITCH_DETAILS where SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and CORE_SWITCH_DETAILS.CORE_SWITCH_ID = CORE_SWITCH.ID; Brocade Network Advisor Documentation Updates 201 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 210
.USER_NAME, VIRTUAL_SWITCH.PASSWORD, VIRTUAL_SWITCH.MANAGEMENT_STATE, default')) as SNMP_VERSION, coalesce(SNMP_CREDENTIALS.READ_COMMUNITY_STRING, (select SNMP_PROFILE.READ_COMMUNITY_STRING from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_READ_COMMUNITY_STRING, 202 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 211
SNMP_PROFILE.AUTH_PASSWORD from SNMP_PROFILE where SNMP_PROFILE.NAME='default')) as SNMP_AUTH_PASSWORD, coalesce(SNMP_CREDENTIALS.PRIV_PROTOCOL, .VIRTUAL_SWITCH_ID, VIRTUAL_FCOE_PORT.PORT_WWN, VIRTUAL_FCOE_PORT.PORT_SPEED, Brocade Network Advisor Documentation Updates 203 53-1002363 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 212
FABRIC.NAME as FABRIC_NAME, VIRTUAL_SWITCH.NAME as VIRTUAL_NAME, SWITCH_PORT.STATUS as SWITCH_PORT_STATUS, SWITCH_PORT.PORT_ID, SWITCH_PORT.PORT_NUMBER, USER_DEFINED_DEVICE_DETAIL.NAME as ADAPTER_PORT_NAME, VM_CONNECTIVITY.FABRIC_ID 204 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 213
.ADAPTER_PORT_WWN = DEVICE_PORT.WWN and DEVICE_PORT.ID = DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID and DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS = GIGE_PORT.REMOTE_MAC_ADDRESS and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID Brocade Network Advisor Documentation Updates 205 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 214
EE_MONITOR_STATS group by EE_MONITOR_ID); VM_HOST_INFO create or replace view VM_HOST_INFO as select VM_HOST.ID as HOST_ID, VM_HOST.NODE_WWN as HOST_NODE_WWN, VM_HOST.HYPERVISOR_NAME, VM_HOST.HYPERVISOR_TYPE, 206 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 215
as VM_NAME, VIRTUAL_MACHINE.DESCRIPTION as VM_DESCRIPTION, VIRTUAL_MACHINE.OS as VM_OS, VIRTUAL_MACHINE.STATUS as VM_STATUS, VIRTUAL_MACHINE , VM_PATH.HBA_NAME, VM_PATH.USAGE as PATH_USAGE, VM_PATH.ENABLED as PATH_ENABLED, Brocade Network Advisor Documentation Updates 207 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 216
join VM_PATH on VM_LUN.ID = VM_PATH.LUN_ID; VM_STATISTICS_INFO This view gets the FC port statistics for the VM Connectivity data. create or replace view VM_STATISTICS_INFO as , VM_CONNECTIVITY.VM_NAME, CORE_SWITCH.IP_ADDRESS, 208 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 217
, ZONE_DB.ZONE_CONFIG_SIZE, ZONE_DB.ZONE_AVAILABLE_SIZE, ZONE_DB_CONFIG.ID AS CONFIG_ID, ZONE_DB_CONFIG.DEFINED_CONTENT, ZONE_DB_CONFIG.ACTIVE_CONTENT, ZONE_DB_CONFIG.TI_ZONE_CONTENT from ZONE_DB, ZONE_DB_CONFIG where Brocade Network Advisor Documentation Updates 209 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 218
: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE accessible_entity ( accessible_entity_id integer NOT NULL, type character varying(8), table_subtype character varying(32) NOT NULL, require_update numeric(1,0) 210 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 219
; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE address_group_subnet_entry ( address_group_subnet_entry_id integer NOT NULL, ip_subnet_definition_id integer NOT NULL, address_group_id integer NOT NULL ); Brocade Network Advisor Documentation Updates 211 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 220
integer NOT NULL, device_id integer NOT NULL, scenario_id integer DEFAULT 2 NOT NULL, ip_address_pool character varying(4096), other character ap_ids ( sqnum integer NOT NULL, time_stamp bigint, device_id integer NOT NULL, 212 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 221
Views E macaddr character varying(17), authenticated smallint, associated smallint, forwarding smallint, lastkeytype smallint, manualblock integer NOT NULL, sys_up_time integer, ifindex integer, stationaddres character varying(40), Brocade Network Advisor Documentation Updates 213 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 222
E Views authenticated smallint, associated smallint, isforwarding smallint, rxbytecount bigint, time_interval bigint, radio smallint, channel smallint ); -- Name: ap_station_last_saved; Type: NULL, uiengine_realm_security_device_config_id integer 214 Brocade Network Advisor Documentation Updates - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 223
varying(32), product_type character varying(32), file_name character varying(512) NOT NULL, file_type character varying(8) NOT NULL, revision_num numeric(4,0) NOT NULL, description character varying(64) ); Brocade Network Advisor Documentation Updates 215 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 224
name character varying(128), description character varying(128), class character varying(32), hw_revision character varying(64), fw_revision NULL, deployment_execution_id integer, user_id integer, is_available numeric(1,0), 216 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 225
; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE collector_snmp_expression_entry ( collector_snmp_expression_entry_id integer NOT NULL, collector_id integer, expression_id integer ); Brocade Network Advisor Documentation Updates 217 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 226
integer, user_id numeric(10,0) DEFAULT 1 NOT NULL ); -- Name: deployment_port_list; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE deployment_port_list ( deployment_port_list_id integer NOT NULL, 218 Brocade Network Advisor Documentation Updates 53 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 227
snmpv3_rw_auth_type character varying(1), snmpv3_rw_auth_username character varying(512), snmpv3_rw_auth_password character varying(512), snmpv3_rw_priv_protocol character varying(1), snmpv3_rw_priv_password character varying(512), Brocade Network Advisor Documentation Updates 219 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 228
default '', SYSLOG_REGISTERED numeric(1) default 0, TRAP_REGISTERED numeric(1) default 0, PORT_COUNT integer default 0, SERIAL_NUMBER character varying(32) default '', CATEGORY integer default 0 not null, MPLS_MANAGE_STATE integer default NOT NULL, 220 Brocade Network Advisor Documentation Updates - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 229
is_ap_group numeric(1,0) DEFAULT 0 NOT NULL, is_sensor_group numeric(1,0) DEFAULT 0 NOT NULL, view_mask numeric(1,0), GROUP_TYPE integer default 0 not ( discovery_cycle_id integer NOT NULL, discovery_profile_id integer NOT NULL, Brocade Network Advisor Documentation Updates 221 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 230
smallint, is_ack numeric(1,0), log_type character(1), slot smallint, port smallint, device_id integer, event_action_id integer, device_group_id integer ( messages character varying(512) NOT NULL, messages_id integer NOT NULL ); 222 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 231
, emain.log_type, emain.slot, emain.port, emain.device_id, emain.event_action_id, emain. numeric(1,0), management_vlan_id smallint, is_sensor numeric(1,0) DEFAULT 0, bssids character varying(128) ); varying(32), feature_mask bytea, Brocade Network Advisor Documentation Updates 223 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 232
NOT NULL ); -- Name: hostname_spec; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE hostname_spec ( address_spec_id integer NOT NULL, name character varying(64) NOT NULL ); 224 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 233
ip_address_range_id integer NOT NULL, address_group_id integer NOT NULL, ip_address_low character varying(40), ip_address_high character varying(40) ); -- Name: ip_address_spec; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: Brocade Network Advisor Documentation Updates 225 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 234
) NOT NULL, subnet_mask character varying(40) NOT NULL ); -- Name: ipx_network_vlan; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE ipx_network_vlan ( vlan_db_id integer NOT NULL, 226 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 235
: l3_roaming_peer_config; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE l3_roaming_peer_config ( l3_roaming_peer_config_id integer NOT NULL, l3_roaming_domain_device_id integer, ip_address character varying(64), Brocade Network Advisor Documentation Updates 227 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 236
, location_ap_id integer ); -- Name: location_name; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE location_name ( location_name_id integer NOT NULL, name character varying(64) NOT NULL, 228 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 237
NOT NULL, is_permit numeric(1,0), src_mac_address character varying(24) NOT NULL, src_address_mask character varying(24), table_subtype character varying(32) NOT NULL character varying(128) NOT NULL, user_id integer NOT NULL, Brocade Network Advisor Documentation Updates 229 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 238
NOT NULL, is_present numeric(1,0), is_management_module numeric(1,0), num_cpus smallint DEFAULT 0 NOT NULL, hw_revision character varying(64), fw_revision ( mpls_admin_group_interface_relation_db_id integer NOT NULL, 230 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 239
: CREATE TABLE mpls_rsvp_lsp_admin_group ( mpls_rsvp_lsp_admin_group_db_id integer NOT NULL, affinity_type smallint NOT NULL, mpls_admin_group_db_id integer NOT NULL, mpls_rsvp_lsp_admin_group_container_db_id integer NOT NULL Brocade Network Advisor Documentation Updates 231 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 240
NOT NULL, path_type smallint NOT NULL, is_standby numeric(1,0) NOT NULL default 0, mpls_lsp_db_id integer NOT NULL, mpls_path_db_id integer NOT NULL ); -- , mean_rate integer, max_burst integer, mpls_rsvp_lsp_parameters_db_id integer 232 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 241
; Tablespace: CREATE TABLE mrp_ring ( mrp_ring_id integer NOT NULL, ring_id numeric(8,0) NOT NULL, ring_name character varying(255), status smallint DEFAULT 1 NOT NULL, last_updated bigint NOT NULL ); -- Name: mrp_ring_device; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 242
integer NOT NULL, tc_bpdu_rc integer NOT NULL, status smallint DEFAULT 1 NOT NULL, last_updated bigint NOT NULL ); -- Name DEFAULT 0 ); -- Name: physical_port; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE physical_port ( physical_port_id integer NOT NULL, 234 Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 243
port_group_id integer NOT NULL, slot_num smallint, port_num smallint, unit_num smallint DEFAULT 0 NOT NULL ); -- Name: port_range_spec; Type: TABLE; ( port_spec_id integer NOT NULL, table_subtype character varying(32) NOT NULL ); Brocade Network Advisor Documentation Updates 235 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 244
; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE pseudo_event ( pseudo_event_id integer NOT NULL, status character(1), policy_type character varying(32), severity smallint, user_id integer NOT NULL, 236 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 245
integer NOT NULL, device_id integer, device_group_id integer, interface_id integer, port_group_id integer, object_id integer, object_class_name character varying(256), object_id2 integer, object_class_name2 character varying(256) Brocade Network Advisor Documentation Updates 237 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 246
not null, other_recipients character varying(255) default '' not null, replyto character varying(255) default '' not null, subject character varying( rogue_down integer, managed_total integer, managed_up integer, managed_down integer, 238 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 247
, mgmtpktstx integer, ucastpktstx integer, mcastpktstx integer, bcastpktstx integer, octetstx integer, dtimcount integer, dtimperiod integer, onexeaptype integer, rsnencrypttype integer, totalframestx integer, totalframesrx integer, Brocade Network Advisor Documentation Updates 239 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 248
( sqnum integer NOT NULL, time_stamp bigint, device_id integer NOT NULL, sys_up_time integer, macaddress character varying(17), channelnumber integer, apmacaddress character varying(17), apchannelnumber smallint, 240 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 249
; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE rl_access_control_entry ( rl_access_control_entry_id integer NOT NULL, rl_access_control_list_id integer, table_subtype character varying(32) NOT NULL ); Brocade Network Advisor Documentation Updates 241 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 250
) NOT NULL, description character varying(64), is_device_access_role numeric(1,0) DEFAULT 0 NOT NULL ); -- Name: role_accessible_entity; Type: TABLE ; Tablespace: CREATE TABLE role_privilege ( role_privilege_id integer NOT NULL, 242 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 251
creation_time character varying(16) NOT NULL, type_num integer DEFAULT 1 NOT NULL, mark_internal numeric(1,0) DEFAULT 0, is_wireless numeric(1,0) ); -- Name: scenario_binding; integer NOT NULL, group_type numeric(2,0) NOT NULL ); Brocade Network Advisor Documentation Updates 243 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 252
bigint DEFAULT 0 NOT NULL, table_name character varying(128) ); -- Name: service; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE service ( integer NOT NULL, child_service_group_id integer NOT NULL 244 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 253
default 0, OUT_SLOT smallint, OUT_PORT smallint, IN_VLAN smallint, OUT_VLAN smallint, IN_PRIORITY smallint, OUT_PRIORITY smallint, SRC_MAC bytea, DEST_MAC bytea, L3_SRC_ADDR bytea, L3_DEST_ADDR bytea, L3_PROTOCOL integer not null, IP_TOS smallint, L4_PROTOCOL smallint, L4_SRC_PORT integer, Brocade - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 254
DEVICE_ID integer not null, IN_UNIT smallint default 0, IN_SLOT smallint, IN_PORT smallint, OUT_UNIT smallint default 0, OUT_SLOT smallint, OUT_PORT smallint, FRAMES bigint not null, BYTES bigint not null, TCP_FLAGS smallint ); 246 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 255
null, SRC_AS bigint, SFLOW_IP_ROUTE_INFO_ID integer, IN_VLAN smallint, OUT_VLAN smallint, FRAMES bigint not null, BYTES bigint not null ); create table SFLOW_MINUTE_BGP_SLNUM ( MAX_SLNUM bigint ) with (autovacuum_vacuum_threshold=4); Brocade Network Advisor Documentation Updates 247 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 256
; Tablespace: create table SFLOW_MINUTE_MAC ( SLNUM bigserial not null, TIME_IN_SECONDS integer not null, DEVICE_ID integer not null, FRAMES bigint not null, BYTES bigint not null, 248 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 257
, FRAMES, BYTES from SFLOW_MINUTE_VLAN where SLNUM - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 258
time_in_seconds integer NOT NULL, collector_id integer NOT NULL, mib_index character varying(256) default '', constraint PK_SNMP_DATA primary key (ID) ); -- Name: snmp_expr_data; Type: integer NOT NULL, collector_id integer NOT NULL, 250 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 259
(512), is_enable character varying(8) DEFAULT 'Yes'::character varying NOT NULL, user_id integer NOT NULL, severity smallint, inm_event_flag integer DEFAULT 0 NOT NULL ); -- Name: snmp_fwd_targets; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: Brocade Network Advisor Documentation Updates - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 260
DEFAULT 162 NOT NULL, snmp_version character varying(8) DEFAULT 'v2/v3'::character varying NOT NULL, snmp_notify_type character varying(1) DEFAULT '1'::character varying NOT NULL, snmp_to_nnm character varying(8) DEFAULT integer ); 252 Brocade Network Advisor Documentation - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 261
varying(2), password character varying(255), description character varying(1024), strength integer NOT NULL DEFAULT 0, private_key text NOT NULL DEFAULT '' ); -- Name: stp_entry; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: Brocade Network Advisor Documentation Updates 253 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 262
: CREATE TABLE switch_service ( service_id integer NOT NULL, vlan_8021q_tag integer, default_vlan_id smallint ); -- Name: syslog_file_info; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE syslog_file_info ( 254 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 263
numeric(1,0), demo_expiration_datetime character varying(32), is_full_install numeric(1,0) DEFAULT 0, serial_number character varying(64), system_id character varying( (255), topo_mapcell_coord_x integer, topo_mapcell_coord_y integer ); Brocade Network Advisor Documentation Updates 255 53-1002363- - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 264
: users; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE users ( user_id integer NOT NULL, user_name character varying(32), login_name character varying(255) NOT NULL, password character varying(512), 256 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 265
previous_passwords_used character varying(2500), nbi_identity_key character varying(255) DEFAULT ''::character varying NOT NULL, nbi_access_key character varying(512 character varying(32), table_subtype character varying(32) NOT NULL Brocade Network Advisor Documentation Updates 257 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 266
-- Name: vpls_device_relation; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: CREATE TABLE vpls_device_relation ( mpls_service_device_relation_db_id integer NOT NULL, vpls_config_index integer NOT NULL, mac_limit integer ); 258 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 267
integer NOT NULL, time_in_seconds integer NOT NULL, event_type smallint NOT NULL, ip character varying(40) NOT NULL, mac character varying(12), auth_type character varying(10), Brocade Network Advisor Documentation Updates 259 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 268
NULL, dest_mac_address character varying(24) NOT NULL, dest_address_mask character varying(24), ether_type character varying(24), operator character varying(5), tx_power, radio_interface.channel_number, radio_interface.max_data_rate, 260 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 269
outer join DEVICE_ENCLOSURE on MANAGED_ELEMENT.ID = DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID; SNMP_DATA_INFO create or replace view SNMP_DATA_INFO as select * from SNMP_DATA union all select * from SNMP_DATA_30MIN union all Brocade Network Advisor Documentation Updates 261 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 270
collectible_detail, sd.value, sd.time_in_seconds, sd.mib_index FROM snmp_data_info sd JOIN device de ON sd.target_id = de.device_id WHERE sd.target_type = 0::numeric) UNION ALL 262 Brocade Network Advisor Documentation Updates 53-1002363-02 - HP Brocade 8/12c | Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 271
.time_in_seconds, '' AS mib_index FROM snmp_expr_data_info se JOIN interface ifs ON se.target_type = 1 AND se.target_id = ifs.interface_id JOIN device de ON ifs.device_id = de.device_id; Brocade Network Advisor Documentation Updates 263 53-1002363-02
53-1002363-03
26 August 2011
®
Network Advisor
Documentation Updates
Supporting Network Advisor 11.1.0