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

Soap Fault database

The SoapFault database contains records for the Soap Fault category.

This table contains records for each Http Fault object.

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

varchar(1024)

SOAP fault code

varchar(1024)

SOAP fault sub-code

varchar(1024)

SOAP fault string

varchar(1024)

SOAP fault actor

varchar(1024)

SOAP fault details

char(34)

Unique identifier for Soap Web Service where fault occurred

char(34)

Unique identifier for the Soap Operation that had the fault

char(34)

Unique identifier for the Soap Server where the fault occurred

char(34)

Unique identifier for the Soap Consumer that triggered the fault

int(10) unsigned

HTTP response code that was returned (4xx, 5xx)

datetime

Date and time the fault occurred

Soap Transaction database

The Site database contains records for the following categories:

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

For details, see these topics:

Soap Transaction Metric table

This table contains metrics for Soap Transaction 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

SOAP Transaction End-to-End Time Service Level - Pass

double

SOAP Transaction End-to-End Time Service Level

bigint(20) unsigned

SOAP Transaction End-to-End Time Service Level - Total

bigint(20) unsigned

SOAP Transaction End-to-End Time - Count

double

SOAP Transaction End-to-End Time – Sum

double

SOAP Transaction End-to-End Time – Sum Sq

double

SOAP Transaction End-to-End Time – Min

double

SOAP Transaction End-to-End Time – Max

double

SOAP Transaction End-to-End Time – Perc

double

SOAP Transaction End-to-End Time – Mean

double

SOAP Transaction End-to-End Time – Std Dev

bigint(20) unsigned

Soap Transaction Service Count

bigint(20) unsigned

SOAP Transaction Timeout Count

bigint(20) unsigned

SOAP Transaction Think Time - Count

double

SOAP Transaction Think Time – Sum

double

SOAP Transaction Think Time – Sum Sq

double

SOAP Transaction Think Time – Min

double

SOAP Transaction Think Time – Max

double

SOAP Transaction Think Time – Perc

SOAP Transaction Think Time – Mean

SOAP Transaction Think Time – Std Dev

bigint(20) unsigned

Soap Transaction Duration – Count

double

Soap Transaction Duration – Sum

double

Soap Transaction Duration – Sum Sq

double

Soap Transaction Duration – Min

double

Soap Transaction Duration – Max

double

Soap Transaction Duration – Perc

double

Soap Transaction Duration – Mean

double

Soap Transaction Duration – Std Dev

bigint(20) unsigned

Soap Transaction Completion Time – Count

double

Soap Transaction Completion Time – Sum

double

Soap Transaction Completion Time – Sum Sq

double

Soap Transaction Completion Time – Min

double

Soap Transaction Completion Time – Max

double

Soap Transaction Completion Time – Perc

double

Soap Transaction Completion Time – Mean

double

Soap Transaction Completion Time – Std Dev

bigint(20) unsigned

Soap Transaction Abort Count

bigint(20) unsigned

Soap Transaction Processing Time – Count

double

Soap Transaction Processing Time – Sum

double

Soap Transaction Processing Time – Sum Sq

double

Soap Transaction Processing Time – Min

double

Soap Transaction Processing Time – Max

double

Soap Transaction Processing Time – Perc

double

Soap Transaction Processing Time – Mean

double

Soap Transaction Processing Time – Std Dev

bigint(20) unsigned

Soap Transaction Initial Response Time – Count

double

Soap Transaction Initial Response Time – Sum

double

Soap Transaction Initial Response Time – Sum Sq

double

Soap Transaction Initial Response Time – Min

double

Soap Transaction Initial Response Time – Max

double

Soap Transaction Initial Response Time – Perc

double

Soap Transaction Initial Response Time – Mean

double

Soap Transaction Initial Response Time – Std Dev

bigint(20) unsigned

Soap Transaction Client Time – Count

double

Soap Transaction Client Time – Sum

double

Soap Transaction Client Time – Sum Sq

double

Soap Transaction Client Time – Min

double

Soap Transaction Client Time – Max

double

Soap Transaction Client Time – Perc

double

Soap Transaction Client Time – Mean

double

Soap Transaction Client Time – Std Dev

bigint(20) unsigned

Soap Transaction Network Latency – Count

double

Soap Transaction Network Latency – Sum

double

Soap Transaction Network Latency – Sum Sq

double

Soap Transaction Network Latency – Min

double

Soap Transaction Network Latency – Max

double

Soap Transaction Network Latency – Perc

double

Soap Transaction Network Latency – Mean

double

Soap Transaction Network Latency – Std Dev

bigint(20) unsigned

Soap Transaction Processing Time Service Level – Pass

bigint(20) unsigned

Soap Transaction Processing Time Service Level – Total

bigint(20) unsigned

Soap Transaction Processing Time Service Level

int(11)

Soap Transaction Peak Count per Second

int(11)

Soap Transaction Request Peak Count per Second

Soap Transaction Step Metric table

This table contains metrics for Soap Transaction Step 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

Soap Operation Completion Time – Count

double

Soap Operation Completion Time – Sum

double

Soap Operation Completion Time – Sum Sq

double

Soap Operation Completion Time – Min

double

Soap Operation Completion Time – Max

double

Soap Operation Completion Time – Perc

double

Soap Operation Completion Time – Mean

double

Soap Operation Completion Time – Std Dev

bigint(20) unsigned

Soap Operation Processing Time – Count

double

Soap Operation Processing Time – Sum

double

Soap Operation Processing Time – Sum Sq

double

Soap Operation Processing Time – Min

double

Soap Operation Processing Time – Max

double

Soap Operation Processing Time – Perc

double

Soap Operation Processing Time – Mean

double

Soap Operation Processing Time – Std Dev

bigint(20) unsigned

Soap Operation Initial Response Time – Count

double

Soap Operation Initial Response Time – Sum

double

Soap Operation Initial Response Time – Sum Sq

double

Soap Operation Initial Response Time – Min

double

Soap Operation Initial Response Time – Max

double

Soap Operation Initial Response Time – Perc

double

Soap Operation Initial Response Time – Mean

double

Soap Operation Initial Response Time – Std Dev

bigint(20) unsigned

Soap Operation Client Time – Count

double

Soap Operation Client Time – Sum

double

Soap Operation Client Time – Sum Sq

double

Soap Operation Client Time – Min

double

Soap Operation Client Time – Max

double

Soap Operation Client Time – Perc

double

Soap Operation Client Time – Mean

double

Soap Operation Client Time – Std Dev

bigint(20) unsigned

Soap Operation Network Latency – Count

double

Soap Operation Network Latency – Sum

double

Soap Operation Network Latency – Sum Sq

double

Soap Operation Network Latency – Min

double

Soap Operation Network Latency – Max

double

Soap Operation Network Latency – Perc

double

Soap Operation Network Latency – Mean

double

Soap Operation Network Latency – Std Dev

bigint(20) unsigned

Soap Operation End-to-End Time – Count

double

Soap Operation End-to-End Time – Sum

double

Soap Operation End-to-End Time – Sum Sq

double

Soap Operation End-to-End Time – Min

double

Soap Operation End-to-End Time – Max

double

Soap Operation End-to-End Time – Perc

double

Soap Operation End-to-End Time – Mean

double

Soap Operation End-to-End Time – Std Dev

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating