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

Instrumented Application Metric tables

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

Custom Standard Metric #1 - Count

double

Custom Standard Metric #1 - Sum

double

Custom Standard Metric #1 - Sum Sq

double

Custom Standard Metric #1 - Min

double

Custom Standard Metric #1 - Max

double

Custom Standard Metric #1 - Perc

double

Custom Standard Metric #1 - Mean

double

Custom Standard Metric #1 - Std Dev

bigint(20) unsigned

Custom Standard Metric #2 - Count

double

Custom Standard Metric #2 - Sum

double

Custom Standard Metric #2 - Sum Sq

double

Custom Standard Metric #2 - Min

double

Custom Standard Metric #2 - Max

double

Custom Standard Metric #2 - Perc

double

Custom Standard Metric #2 - Mean

double

Custom Standard Metric #2 - Std Dev

bigint(20) unsigned

Custom Standard Metric #3 - Count

double

Custom Standard Metric #3 - Sum

double

Custom Standard Metric #3 - Sum Sq

double

Custom Standard Metric #3 - Min

double

Custom Standard Metric #3 - Max

double

Custom Standard Metric #3 - Perc

double

Custom Standard Metric #3 - Mean

double

Custom Standard Metric #3 - Std Dev

bigint(20) unsigned

Custom Standard Metric #4 - Count

double

Custom Standard Metric #4 - Sum

double

Custom Standard Metric #4 - Sum Sq

double

Custom Standard Metric #4 - Min

double

Custom Standard Metric #4 - Max

double

Custom Standard Metric #4 - Perc

double

Custom Standard Metric #4 - Mean

double

Custom Standard Metric #4 - Std Dev

bigint(20) unsigned

Custom Standard Metric #5 - Count

double

Custom Standard Metric #5 - Sum

double

Custom Standard Metric #5 - Sum Sq

double

Custom Standard Metric #5 - Min

double

Custom Standard Metric #5 - Max

double

Custom Standard Metric #5 - Perc

double

Custom Standard Metric #5 - Mean

double

Custom Standard Metric #5 - Std Dev

double

Custom Count Metric #1

double

Custom Count Metric #2

double

Custom Count Metric #3

double

Custom Count Metric #4

double

Custom Count Metric #5

bigint(20) unsigned

Load Time - Count

double

Load Time - Sum

double

Load Time - Sum Sq

double

Load Time - Min

double

Load Time - Max

double

Load Time - Perc

double

Load Time - Mean

double

Load Time - Std Dev

bigint(20) unsigned

Unload Time - Count

double

Unload Time - Sum

double

Unload Time - Sum Sq

double

Unload Time - Min

double

Unload Time - Max

double

Unload Time - Perc

double

Unload Time - Mean

double

Unload Time - Std Dev

bigint(20) unsigned

Page Views

bigint(20) unsigned

Session Count

Instrumented Application Resource tables

These tables contain information about the resources (or objects) in the Instrumented Application categories.

This schema applies to the following tables:

* indicates the primary key

tinyint(1)

For internal use only

char(34)

Unique identifier for this resource (object)

text

Name of the resource

text

Displayable name of the resource

bigint(20)

Configuration database identifier for the Instrumented Application

Page database

The Page database contains records for the Page categories:

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

For details, see these topics:

Content Type Metric table

This table contains metrics for Content Type 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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating