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

User Session database

The Subnet database contains records for the Subnet category.

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

For details, see these topics:

User Session Metric table

This table contains metrics for User Session 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

char(34)

Unique identifier for this resource (object)

datetime

See TimeStamp in Appendix A

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

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 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

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

datetime

Start Time

datetime

Stop Time

varchar(64)

City

varchar(64)

ISP

varchar(32)

Login Name

varchar(64)

User Agent

varchar(64)

Referrer

varchar(64)

Client IP

varchar(128)

Server Name

double

Access Speed

double

Duration

int(10) unsigned

Alarm

varchar(128)

Session Key

varchar(64)

Subnet

int(10) unsigned

Page Alarm

varchar(64)

Session ID Variable

User Session Page Metric table

This table contains metrics for the Pages associated with a User Session

This schema applies to the following table:

* indicates the primary key

¹ indicates an index

int(11)

For internal use only

char(34)

Unique identifier for this resource (object)

datetime

Identifier the page in the sequence

varchar(1024)

URL for the page

char(34)

Unique identifier of Page category object

int(11)

HTTP or HTTPS

datetime

Start Time

datetime

Stop Time

double

End-to-End Time

double

Processing Time

double

Client Time

int(10) unsigned

Page Size

int(10) unsigned

Request Size

int(10) unsigned

Response Size

varchar(40)

Server IP

varchar(128)

Session Key

User Session Hit Metric table

This table contains metrics for the Hit associated with a User Session

This schema applies to the following table:

* indicates the primary key

¹ indicates an index

int(11)

For internal use only

char(34)

Unique identifier for this resource (object)

datetime

Identifier the page in the sequence

varchar(1024)

URL for the page

char(34)

Unique identifier of Page category object.

int(11)

HTTP or HTTPS

int(10) unsigned

Request Code

int(10) unsigned

Response Code

datetime

Start Time

datetime

Stop Time

double

Processing Time

double

Client Time

int(10) unsigned

Page Size

int(10) unsigned

Request Size

int(10) unsigned

Response Size

char(40)

Server IP

varchar(128)

Session Key

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating