summary_applications Table
The summary_application table summarizes the aggregated data from the Exinda. The following table describes the schema of the summary_applications SQL table.
| Field | Type | Description |
|---|---|---|
|
in_port |
unsigned 24-bit integer |
The TCPTransmission Control Protocol or UDPUser Datagram Protocol port number on the internal side (the LANLocal area network side of the Exinda appliance)1 |
|
ex_port |
unsigned 24-bit integer |
The TCP or UDP port number on the external side (the WANWide Area Network side of the Exinda appliance)1 |
|
protocol |
unsigned 24-bit integer |
The IANA assigned IPInternet protocol protocol number of the flowthe network traffic between network objects. See http://www.iana.org/assignments/protocol-numbers/ for more information. |
|
app_id |
unsigned 24-bit integer |
The internal Exinda Application ID assigned to this flow. This represents Exinda's classification of the flow. A zero value should be interpreted as unclassified. |
|
bytes_in |
unsigned 64-bit integer |
The number of inbound (WAN -> LAN) bytes recorded for this flow over the sample period. |
|
bytes_out |
unsigned 64-bit integer |
The number of outbound (LAN -> WAN) bytes recorded for this flow over the sample period. |
|
packets_in |
unsigned 64-bit integer |
The number of inbound (WAN -> LAN) packets recorded for this flow over the sample period. |
|
packets_out |
unsigned 64-bit integer |
The number of outbound (LAN -> WAN) packets recorded for this flow over the sample period. |
|
intervals_in |
unsigned 24-bit integer |
The number of 10 second intervals there was inbound (WAN -> LAN) traffic observed for this flow during the sample period. |
|
intervals_out |
unsigned 24-bit integer |
The number of 10 second intervals there was outbound (LAN -> WAN) traffic observed for this flow during the sample period. |
|
timestamp |
unsigned 32-bit integer |
A UNIX timestamp (number of seconds since epoch - 1st Jan 1970) that represents the start of the sample period. |
|
max_tput_in |
unsigned 64-bit integer |
The maximum inbound (WAN -> LAN) throughput observed for this flow during the sample period (bps). |
|
max_tput_out |
unsigned 64-bit integer |
The maximum outbound (LAN -> WAN) throughput observed for this flow during the sample period (bps). |
|
rtt |
unsigned 32-bit integer |
Round Trip Time in milliseconds. A measure of the time a packet takes to leave a device, cross a network and return.2 |
|
network_delay |
unsigned 32-bit integer |
A normalized measure of the time taken for transaction data to traverse the network.2 |
|
network_jitter |
unsigned 32-bit integer |
A normalized measure of the network_delay variability.2 |
|
server_delay |
unsigned 32-bit integer |
A normalized measure of the time taken for a server to respond to a transaction request.2 |
|
bytes_lost_in |
unsigned 64-bit integer |
The number of bytes lost due to retransmissions (WAN -> LAN).2 |
|
bytes_lost_out |
unsigned 64-bit integer |
The number of bytes lost due to retransmissions (LAN -> WAN).2 |
in_portandex_portare only defined when the IP protocol is TCP (6) or UDP (17) and the Exinda was unable to classify the flow (so the app_id is 0).- For more information refer to Using Application Performance reports.