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

Server by Port Resource table

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

This schema applies to the following table:

* 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

Service database

The Service database contains records for the Application categories:

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

For details, see these topics:

Service Metric tables

These tables contain metrics for Service 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

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

Service Count

bigint(20) unsigned

Service Abort Count

bigint(20) unsigned

Service Timeout Count

bigint(20) unsigned

Service Duration – Count

double

Service Duration – Sum

double

Service Duration – Sum Sq

double

Service Duration – Min

double

Service Duration – Max

double

Service Duration – Perc

double

Service Duration – Mean

double

Service Duration – Std Dev

bigint(20) unsigned

Service End-to-End Time – Count

double

Service End-to-End Time – Sum

double

Service End-to-End Time – Sum Sq

double

Service End-to-End Time – Min

double

Service End-to-End Time – Max

double

Service End-to-End Time – Perc

double

Service End-to-End Time – Mean

double

Service End-to-End Time – Std Dev

bigint(20) unsigned

Service Think Time – Count

double

Service Think Time – Sum

double

Service Think Time – Sum Sq

double

Service Think Time – Min

double

Service Think Time – Max

double

Service Think Time – Perc

double

Service Think Time – Mean

double

Service Think Time – Std Dev

bigint(20) unsigned

Service Command Initial Response Time – Count

double

Service Command Initial Response Time – Sum

double

Service Command Initial Response Time – Sum Sq

double

Service Command Initial Response Time – Min

double

Service Command Initial Response Time – Max

double

Service Command Initial Response Time – Perc

double

Service Command Initial Response Time – Mean

double

Service Command Initial Response Time – Std Dev

bigint(20) unsigned

Service Processing Time – Count

double

Service Processing Time – Sum

double

Service Processing Time – Sum Sq

double

Service Processing Time – Min

double

Service Processing Time – Max

double

Service Processing Time – Perc

double

Service Processing Time – Mean

double

Service Processing Time – Std Dev

bigint(20) unsigned

Service Client Time – Count

double

Service Client Time – Sum

double

Service Client Time – Sum Sq

double

Service Client Time – Min

double

Service Client Time – Max

double

Service Client Time – Perc

double

Service Client Time – Mean

double

Service Client Time – Std Dev

bigint(20) unsigned

Service Network Latency – Count

double

Service Network Latency – Sum

double

Service Network Latency – Sum Sq

double

Service Network Latency – Min

double

Service Network Latency – Max

double

Service Network Latency – Perc

double

Service Network Latency – Mean

double

Service Network Latency – Std Dev

int(10) unsigned

Service Peak Count per Second

int(10) unsigned

Service Request Peak Count per Second

bigint(20) unsigned

Service Processing Load – Pass

bigint(20) unsigned

Service Processing Load – Total

double

Service Processing Load

bigint(20) unsigned

Service Processing Time Service Level – Pass

bigint(20) unsigned

Service Processing Time Service Level – Total

double

Service Processing Time Service Level

bigint(20) unsigned

Service Started Count

Service Step Metric tables

These tables contain metrics for Service Step 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

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

Page Download Attempts

bigint(20) unsigned

Page Redirect Ratio – Pass

bigint(20) unsigned

Page Redirect Ratio – Total

double

Page Redirect Ratio

bigint(20) unsigned

Page End-to-End Time – Count

double

Page End-to-End Time – Sum

double

Page End-to-End Time – Sum Sq

double

Page End-to-End Time – Min

double

Page End-to-End Time – Max

double

Page End-to-End Time – Perc

double

Page End-to-End Time – Mean

double

Page End-to-End Time – Std Dev

bigint(20) unsigned

Page Processing Time – Count

double

Page Processing Time – Sum

double

Page Processing Time – Sum Sq

double

Page Processing Time – Min

double

Page Processing Time – Max

double

Page Processing Time – Perc

double

Page Processing Time – Mean

double

Page Processing Time – Std Dev

bigint(20) unsigned

Page Client Time – Count

double

Page Client Time – Sum

double

Page Client Time – Sum Sq

double

Page Client Time – Min

double

Page Client Time – Max

double

Page Client Time – Perc

double

Page Client Time – Mean

double

Page Client Time – Std

bigint(20) unsigned

Page Think Time – Count

double

Page Think Time – Sum

double

Page Think Time – Sum Sq

double

Page Think Time – Min

double

Page Think Time – Max

double

Page Think Time – Perc

double

Page Think Time – Mean

double

Page Think Time – Std Dev

bigint(20) unsigned

Page Stop Time – Count

double

Page Stop Time – Sum

double

Page Stop Time – Sum Sq

double

Page Stop Time – Min

double

Page Stop Time – Max

double

Page Stop Time – Perc

double

Page Stop Time – Mean

double

Page Stop Time – Std Dev

bigint(20) unsigned

Page Stop Rate – Pass

bigint(20) unsigned

Page Stop Rate – Total

double

Page Stop Rate

bigint(20) unsigned

Page Network Latency – Count

double

Page Network Latency – Sum

double

Page Network Latency – Sum Sq

double

Page Network Latency – Min

double

Page Network Latency – Max

double

Page Network Latency – Perc

double

Page Network Latency – Mean

double

Page Network Latency – Std Dev

bigint(20) unsigned

Page Connection Count – Count

double

Page Connection Count – Sum

double

Page Connection Count – Sum Sq

double

Page Connection Count – Min

double

Page Connection Count – Max

double

Page Connection Count – Perc

double

Page Connection Count – Mean

double

Page Connection Count – Std Dev

bigint(20) unsigned

Page Element Count – Count

double

Page Element Count – Sum

double

Page Element Count – Sum Sq

double

Page Element Count – Min

double

Page Element Count – Max

double

Page Element Count – Perc

double

Page Element Count – Mean

double

Page Element Count – Std Dev

bigint(20) unsigned

Page Download Size – Count

double

Page Download Size – Sum

double

Page Download Size – Sum Sq

double

Page Download Size – Min

double

Page Download Size – Max

double

Page Download Size – Perc

double

Page Download Size – Mean

double

Page Download Size – Std Dev

bigint(20) unsigned

Page Timeout Count

bigint(20) unsigned

Step Started Count

bigint(20) unsigned

Step Completion Count

bigint(20) unsigned

Step Abort Count

bigint(20) unsigned

Step Timeout Count

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating