Switch management port table
| Column Name | Column Datatype | Column Null Option | Column Comment |
| uuid | byte(16) | not null | Unique identifier of this object |
| name | varchar(200) | not null | The name of the port. |
| description | varchar(255) | with null | The description of the port from the IF Mib. |
| status_no | integer | with null | The status number for use by TND status monitoring |
| status | varchar(255) | with null | The port status from the IF MIB - such as up, down, disabled |
| propagate_status | integer1 | not null | TRUE if this port is to propagate status to the DSM monitoring this object. |
| mac_address | varchar(12) | with null | The physical or MAC address of this port |
| if_index | integer | not null | The unique If index from the IF mib for this port. |
| port_index | integer | with null | The port index which is unique to ports and not interfaces. |
| module_index | integer | with null | The module index of the module this port is connected to. |
| dot1d_port_index | integer | with null | The port index as used by the bridge MIB |
| speed | integer | with null | The physical speed at which the port sends/receives data. |
| port_type | integer | with null | The port type as defined in the IANA port types. |
| managed_bits | integer | with null | Non-zero if the port is being managed manually. |
| pbnc_type | integer | with null | Local storage for some specific switch types. |
| vlan_index | integer | with null | The VLAN number of the VLAN this port belongs to - if it belongs to a VLAN. |
| vlan_admin_status | integer | with null | The administrative status of the VLAN the port belongs to. |
| is_trunk | integer1 | with null | TRUE (checked) if this port is considered a trunk on the switch. |
| vlans_allowed | varchar(255) | with null | List of all VLANS allowed to use this port. |
| priority_vlans | varchar(255) | with null | List of those VLANS that are considered as priority when on this port. |
| parent_uuid | byte(16) | not null | UUID of the ssmodule this port belongs to. |
| switch_uuid | byte(16) | not null | UUID of the device in the repository that this port is part of. |
| switch_class | varchar(30) | not null | The class of the device in the repository that this port is on. |
| switch_address | varchar(25) | not null | The IP address of the device in the repository that this port is on. |
| port_ip_address | varchar(25) | with null | The unique IP address if this port has it's own IP address assigned to it. |
| port_mode | integer | with null | The port mode - 1 for switching and 2 for non-switching. |
| upper_if | integer | with null | If this port is layered in the IF MIB table, this is the if index of the port above this one. |
| remote_ip_address | varchar(25) | with null | The IP address of the device connected to this port via BGP. |
| bgp_peer_id | varchar(25) | with null | The unique BGP identification number for those ports with BGP on them. |
Product Name: Unicenter Network and System Management/Worldview
Table Type: Table