Chat now with support
Chat with Support

Foglight Experience Monitor 5.8.1 - SQL Reference Guide

Foglight Experience Monitor SQL reference
Database Tables Alarm database Application database Enterprise database HTTP Fault database Location database Instrumented Application database Page database Protocol database Server database Service database Site database Soap Database Soap Consumer database Soap Fault database Soap Transaction database Subnet database System database User Agent database User Session database
Appendix: Column description Appendix: Example queries

TCP Protocol Metric tables

This table contains metrics for TCP Protocol category objects for a specific time interval.

This schema applies to the following tables:

* indicates the primary key

¹ indicates an index

int(11)

For internal use only

bigint(20) unsigned

Connection Duration – Count

double

Connection Duration – Sum

double

Connection Duration – Sum Sq

double

Connection Duration – Min

double

Connection Duration – Max

double

Connection Duration – Perc

double

Connection Duration – Mean

double

Connection Duration – Std Dev

bigint(20) unsigned

Connection Count

bigint(20) unsigned

Connection Open Wait Count

bigint(20) unsigned

Connection Established Count

bigint(20) unsigned

Connection Closed Count

bigint(20) unsigned

Connection Timeout Count

bigint(20) unsigned

Connection Reset Count

int(11)

1 = HTTP, 2 = HTTPS, 0 = None

tinyint(1)

1 = this record does not include all probes

char(34)

Unique identifier for this resource (object)

bigint(20) unsigned

See SampleCount in Appendix A

bigint(20) unsigned

TCP Command Client Time – Count

double

TCP Command Client Time – Sum

double

TCP Command Client Time – Sum Sq

double

TCP Command Client Time – Min

double

TCP Command Client Time – Max

double

TCP Command Client Time – Perc

double

TCP Command Client Time – Mean

double

TCP Command Client Time – Std Dev

bigint(20) unsigned

TCP Command Completion Time – Count

double

TCP Command Completion Time – Sum

double

TCP Command Completion Time – Sum Sq

double

TCP Command Completion Time – Min

double

TCP Command Completion Time – Max

double

TCP Command Completion Time – Perc

double

TCP Command Completion Time – Mean

double

TCP Command Completion Time – Std Dev

bigint(20) unsigned

TCP Command Count

bigint(20) unsigned

TCP Command Processing Time - Count

double

TCP Command Processing Time – Sum

double

TCP Command Processing Time – Sum Sq

double

TCP Command Processing Time – Sum Sq

double

TCP Command Processing Time – Max

double

TCP Command Processing Time – Perc

double

TCP Command Processing Time – Mean

double

TCP Command Processing Time – Std Dev

bigint(20) unsigned

TCP Control Segment Count - Client

double

Segment Size - Client - Max

double

Segment Size - Client - Mean

double

Segment Size - Client - Min

double

Segment Size - Client - Perc

double

Segment Byte Volume - Client

double

Segment Size - Client - SumSq

double

Segment Size - Client - Std Dev

bigint(20) unsigned

TCP Control Segment Count - Server

double

Segment Size - Server - Max

double

Segment Size - Server - Mean

double

Segment Size - Server - Min

double

Segment Size - Server - Perc

double

Segment Size - Server - Std Dev

double

Segment Byte Volume - Server

double

Segment Size - Server - SumSq

bigint(20) unsigned

TCP Data Segment Count - Client

double

Segment Size - Client - Max

double

Segment Size - Client - Mean

double

Segment Size - Client - Min

double

Segment Size - Client - Perc

double

Segment Size - Client - Std Dev

double

TcpDataSegmentsClientSum

double

Data Segment Size - Client - SumSq

bigint(20) unsigned

TCP Data Segment Count - Server

double

TCP Data Segment Size - Server - Max

double

TCP Data Segment Size - Server - Mean

double

TCP Data Segment Size - Server - Min

double

TCP Data Segment Size - Server - Perc

double

TCP Data Segment Size - Server - Std Dev

double

TCP Data Segment Byte Volume - Server

double

TCP Data Segment Size - Server - SumSq

bigint(20) unsigned

TCP Duplicate Resend Segment Count - Client

double

TCP Duplicate Resend Segment Size - Client - Max

double

TCP Duplicate Resend Segment Size - Client - Mean

double

TCP Duplicate Resend Segment Size - Client - Min

double

TCP Duplicate Resend Segment Size - Client - Perc

double

TCP Duplicate Resend Segment Size - Client - Std Dev

double

TCP Duplicate Resend Segment Byte Volume - Client

double

TCP Duplicate Resend Segment Size - Client - SumSq

bigint(20) unsigned

TCP Duplicate Resend Segment Count - Server

double

TCP Duplicate Resend Segment Size - Server - Max

double

TCP Duplicate Resend Segment Size - Server - Mean

double

TCP Duplicate Resend Segment Size - Server - Min

double

TCP Duplicate Resend Segment Size - Server - Perc

double

TCP Duplicate Resend Segment Size - Server - Std Dev

double

TCP Duplicate Resend Segment Byte Volume - Server

double

TCP Duplicate Resend Segment Size - Server - SumSq

bigint(20) unsigned

TCP Fragmented Segment Count – Client

double

TCP Fragmented Segment Byte Volume – Client

double

TCP Fragmented Segment Size – Client – Sum Sq

double

TCP Fragmented Segment Size – Client – Max

double

TCP Fragmented Segment Size – Client – Perc

bigint(20) unsigned

TCP Fragmented Segment Count – Server

double

TCP Fragmented Segment Byte Volume – Server

double

TCP Fragmented Segment Size – Server – Sum Sq

double

TCP Fragmented Segment Size – Server – Min

double

TCP Fragmented Segment Size – Server – Max

double

TCP Fragmented Segment Size – Server – Perc

bigint(20) unsigned

TCP Invalid Checksum Segment Count – Client

double

TCP Invalid Checksum Segment Byte Volume – Client

double

TCP Invalid Checksum Segment Size – Client – Sum Sq

double

TCP Invalid Checksum Segment Size – Client – Min

double

TCP Invalid Checksum Segment Size – Client – Max

double

TCP Invalid Checksum Segment Size – Client – Perc

bigint(20) unsigned

TCP Invalid Checksum Segment Count – Server

double

TCP Invalid Checksum Segment Byte Volume – Server

double

TCP Invalid Checksum Segment Size – Server – Sum Sq

double

TCP Invalid Checksum Segment Size – Server – Min

double

TCP Invalid Checksum Segment Size – Server – Max

double

TCP Invalid Checksum Segment Size – Server – Perc

bigint(20) unsigned

TCP Network Latency - Count

double

 

TCP Network Latency – Sum

double

 

TCP Network Latency – Sum Sq

double

 

TCP Network Latency – Min

double

 

TCP Network Latency – Max

double

 

TCP Network Latency – Perc

double

 

TCP Network Latency – Mean

double

 

TCP Network Latency – Std Dev

int(10) unsigned

TCP Open Connection Peak Count per Second

int(10) unsigned

TCP Payload Byte Volume - Client

int(10) unsigned

TCP Payload Byte Volume – Server

bigint(20) unsigned

TCP Queue Size - Count

double

TCP Queue Size - Max

double

TCP Queue Size - Mean

double

TCP Queue Size - Min

double

TCP Queue Size - Perc

double

TCP Queue Size - Std Dev

double

TCP Queue Size - Sum

double

TCP Queue Size - SumSq

bigint(20) unsigned

TCP Resend Segment Count - Client

double

TCP Resend Segment Size - Client - Max

double

TCP Resend Segment Size - Client - Mean

double

TCP Resend Segment Size - Client - Min

double

TCP Resend Segment Size - Client - Perc

double

TCP Resend Segment Size - Client - Std Dev

double

TCP Resend Segment Byte Volume - Client

double

TCP Resend Segment Size - Client - SumSq

bigint(20) unsigned

TCP Resend Segment Count - Server

double

TCP Resend Segment Size - Server - Max

double

TCP Resend Segment Size - Server - Mean

double

TCP Resend Segment Size - Server - Min

double

TCP Resend Segment Size - Server - Perc

double

TCP Resend Segment Size - Server - Std Dev

double

TCP Resend Segment Byte Volume - Server

double

TCP Resend Segment Size - Server - SumSq

double

TCP Response Time – Sum

double

TCP Response Time – Sum Sq

double

TCP Response Time – Min

double

TCP Response Time – Max

double

TCP Response Time – Perc

double

TCP Response Time – Mean

double

TCP Response Time – Std Dev

bigint(20) unsigned

TCP Segment Count – Client

double

TCP Segment Byte Volume – Client

double

TCP Segment Size – Client – Sum Sq

double

TCP Segment Size – Client – Min

double

TCP Segment Size – Client – Max

double

TCP Segment Size – Client – Perc

double

TCP Segment Size – Client – Mean

double

TCP Segment Size – Client – Std Dev

bigint(20) unsigned

TCP Segment Count – Server

double

TCP Segment Byte Volume – Server

double

TCP Segment Size – Server – Sum Sq

double

TCP Segment Size – Server – Min

double

TCP Segment Size – Server – Max

double

TCP Segment Size – Server – Perc

double

TCP Segment Size – Server – Mean

double

TCP Server Time – Min

bigint(20) unsigned

TCP Timeout Count - Half-Open

bigint(20) unsigned

TCP Timeout Count - Idle

bigint(20) unsigned

TCP Timeout Count - Syn

bigint(20) unsigned

TCP Urgent Segment Count - Client

double

TCP Urgent Segment Size - Client - Max

double

TCP Urgent Segment Size - Client - Mean

double

TCP Urgent Segment Size - Client - Min

double

TCP Urgent Segment Size - Client - Perc

double

TCP Urgent Segment Size - Client - Std Dev

double

TCP Urgent Segment Byte Volume - Client

double

TCP Urgent Segment Size - Client - SumSq

bigint(20) unsigned

TCP Urgent Segment Count - Server

double

TCP Urgent Segment Size - Server - Max

double

TCP Urgent Segment Size - Server - Mean

double

TCP Urgent Segment Size - Server - Min

double

TCP Urgent Segment Size - Server - Perc

double

TCP Urgent Segment Size - Server - Std Dev

double

TCP Urgent Segment Byte Volume - Server

double

TCP Urgent Segment Size - Server - SumSq

tinyint(3) unsigned

See TimePeriod in Appendix A

datetime

See TimeStamp in Appendix A

tinyint(4)

See TimeType in Appendix A

TCP Protocol Resource table

These tables contain information about the resources (or objects) in the TCP Protocol category.

This schema applies to the following tables:

* indicates the primary key

¹ indicates an index

tinyint(1)

1 = resource is inactive; configuration has been deleted

char(34)

Unique identifier for this resource (object)

text

Name of the resource

text

Displayable name of the resource

Server database

The Server database contains records for the Server category.

The tables in this database contain metrics and resource (or object) names.

For details, see these topics:

Server Metric table

This table contains metrics for Server category objects for a specific time interval.

This schema applies to the following table:

* indicates the primary key

¹ indicates an index

int(11)

For internal use only

tinyint(4)

See TimeType in Appendix A

tinyint(3) unsigned

See TimePeriod in Appendix A

char(34)

Unique identifier for this resource (object)

bigint(20) unsigned

See SampleCount in Appendix A

datetime

See TimeStamp in Appendix A

int(11)

1 = HTTP, 2 = HTTPS, 0 = None

tinyint(1)

1 = this record does not include all probes

bigint(20) unsigned

IP Packet Count – User

double

IP Packet Byte Volume – User

double

IP Packet Size – User – Sum Sq

double

IP Packet Size – User – Min

double

IP Packet Size – User – Max

double

IP Packet Size – User – Perc

double

IP Packet Size – User – Mean

double

IP Packet Size – User – Std Dev

bigint(20) unsigned

IP Packet Count – Server

double

IP Packet Byte Volume – Server

double

IP Packet Size – Server – Sum Sq

double

IP Packet Size – Server – Min

double

IP Packet Size – Server – Max

double

IP Packet Size – Server – Perc

double

IP Packet Size – Server – Mean

double

IP Packet Size – Server – Std Dev

bigint(20) unsigned

Command Data Size – User – Count

double

Command Byte Volume – User

double

Command Data Size – User – Sum Sq

double

Command Data Size – User – Min

double

Command Data Size – User – Max

double

Command Data Size – User – Perc

double

Command Data Size – User – Mean

double

Command Data Size – User – Std Dev

bigint(20) unsigned

Command Data Size – Server – Count

double

Command Byte Volume – Server

double

Command Data Size – Server – Sum Sq

double

Command Data Size – Server – Min

double

Command Data Size – Server – Max

double

Command Data Size – Server – Perc

double

Command Data Size – Server – Mean

double

Command Data Size – Server – Std Dev

bigint(20) unsigned

Hit Count

bigint(20) unsigned

Hit End-to-End Time – Count

double

Hit End-to-End Time – Sum

double

Hit End-to-End Time – Sum Sq

double

Hit End-to-End Time – Min

double

Hit End-to-End Time – Max

double

Hit End-to-End Time – Perc

double

Hit End-to-End Time – Mean

double

Hit End-to-End Time – Std Dev

bigint(20) unsigned

Command Completion Time – Count

double

Command Completion Time – Sum

double

Command Completion Time – Sum Sq

double

Command Completion Time – Min

double

Command Completion Time – Max

double

Command Completion Time – Perc

double

Command Completion Time – Mean

double

Command Completion Time – Std Dev

bigint(20) unsigned

Command Processing Time – Count

double

Command Processing Time – Sum

double

Command Processing Time – Sum Sq

double

Command Processing Time – Min

double

Command Processing Time – Max

double

Command Processing Time – Perc

double

Command Processing Time – Mean

double

Command Processing Time – Std Dev

bigint(20) unsigned

Command Initial Response Time – Count

double

Command Initial Response Time – Sum

double

Command Initial Response Time – Sum Sq

double

Command Initial Response Time – Min

double

Command Initial Response Time – Max

double

Command Initial Response Time – Perc

double

Command Initial Response Time – Mean

double

Command Initial Response Time – Std Dev

bigint(20) unsigned

Command Timeout Count

bigint(20) unsigned

Command Client Time – Count

double

Command Client Time – Sum

double

Command Client Time – Sum Sq

double

Command Client Time – Min

double

Command Client Time – Max

double

Command Client Time – Perc

double

Command Client Time – Mean

double

Command Client Time – Std Dev

bigint(20) unsigned

Command Network Latency – Count

double

Command Network Latency – Sum

double

Command Network Latency – Sum Sq

double

Command Network Latency – Min

double

Command Network Latency – Max

double

Command Network Latency – Perc

double

Command Network Latency – Mean

double

Command Network Latency – Std Dev

bigint(20) unsigned

Hit Redirect Ratio – Pass

bigint(20) unsigned

Hit Redirect Ratio – Total

double

Hit Redirect Ratio

bigint(20) unsigned

Connection Duration

double

Connection Duration – Sum

double

Connection Duration – Sum Sq

double

Connection Duration – Min

double

Connection Duration – Max

double

Connection Duration – Perc

double

Connection Duration – Mean

double

Connection Duration – Std Dev

bigint(20) unsigned

Connection Count

bigint(20) unsigned

Connection Open Wait Count

bigint(20) unsigned

Connection Established Count

bigint(20) unsigned

Connection Closed Count

bigint(20) unsigned

Connection Timeout Count

bigint(20) unsigned

Connection Reset Count

bigint(20) unsigned

Error Count (HTTP 4xx client errors)

bigint(20) unsigned

Error Count (HTTP 5xx server errors)

bigint(20) unsigned

Client Success Ratio – Pass

bigint(20) unsigned

Client Success Ratio – Total

double

Client Success Ratio

bigint(20) unsigned

Server Success Ratio – Pass

bigint(20) unsigned

Server Success Ratio – Total

double

Server Success Ratio

bigint(20) unsigned

Success Ratio – Pass

bigint(20) unsigned

Success Ratio – Total

double

Success Ratio

bigint(20) unsigned

Response Code Count

bigint(20) unsigned

Request Code Count

bigint(20) unsigned

Processing Load – Pass

bigint(20) unsigned

Processing Load – Total

Double

Processing Load

bigint(20) unsigned

Command Processing Time Service Level – Pass

bigint(20) unsigned

Command Processing Time Service Level – Total

double

Command Processing Time Service Level

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating