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 Operation Metric table

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

bigint(20) unsigned

Soap Operation Timeout Count

bigint(20) unsigned

Soap Operation Count

bigint(20) unsigned

Soap Operation Success Ratio – Pass

bigint(20) unsigned

Soap Operation Success Ratio – Total

double

Soap Operation Success Ratio

bigint(20) unsigned

Soap Operation Provider Overhead – Pass

bigint(20) unsigned

Soap Operation Provider Overhead – Total

double

Soap Operation Provider Overhead

bigint(20) unsigned

Soap Operation Consumer Overhead – Pass

bigint(20) unsigned

Soap Operation Consumer Overhead – Total

double

Soap Operation Consumer Overhead

bigint(20) unsigned

ResponseCodeCount

bigint(20) unsigned

SOAP Operation Think Time - Count

double

SOAP Operation Think Time – Sum

double

SOAP Operation Think Time – Sum Sq

double

SOAP Operation Think Time – Min

double

SOAP Operation Think Time – Max

double

SOAP Operation Think Time – Perc

double

SOAP Operation Think Time – Mean

double

SOAP Operation Think Time – Std Dev

Soap Application Metric table

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

This schema applies to the following table:

* Soap Application

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

bigint(20) unsigned

Soap Operation Timeout Count

bigint(20) unsigned

Soap Operation Count

bigint(20) unsigned

Soap Operation Success Ratio – Pass

bigint(20) unsigned

Soap Operation Success Ratio – Total

double

Soap Operation Success Ratio

bigint(20) unsigned

Soap Operation Provider Overhead – Pass

bigint(20) unsigned

Soap Operation Provider Overhead – Total

double

Soap Operation Provider Overhead

bigint(20) unsigned

Soap Operation Consumer Overhead – Pass

bigint(20) unsigned

Soap Operation Consumer Overhead – Total

double

Soap Operation Consumer Overhead

bigint(20) unsigned

ResponseCodeCount

bigint(20) unsigned

SOAP Operation Think Time - Count

double

SOAP Operation Think Time – Sum

double

SOAP Operation Think Time – Sum Sq

double

SOAP Operation Think Time – Min

double

SOAP Operation Think Time – Max

double

SOAP Operation Think Time – Perc

double

SOAP Operation Think Time – Mean

double

SOAP Operation Think Time – Std Dev

bigint(20) unsigned

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

double

SOAP Operation End-to-End Time Service Level

bigint(20) unsigned

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

bigint(20) unsigned

SOAP Operation Processing Time Service Level - Pass

double

SOAP Operation Processing Time Service Level

bigint(20) unsigned

SOAP Operation Processing Time Service Level - Total

int(11)

SOAP Operation Request Peak Count per Second

Soap Server Metric table

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

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

bigint(20) unsigned

Soap Operation Timeout Count

bigint(20) unsigned

Soap Operation Count

bigint(20) unsigned

Soap Operation Success Ratio – Pass

bigint(20) unsigned

Soap Operation Success Ratio – Total

double

Soap Operation Success Ratio

bigint(20) unsigned

SOAP Operation Think Time - Count

double

SOAP Operation Think Time – Sum

double

SOAP Operation Think Time – Sum Sq

double

SOAP Operation Think Time – Min

double

SOAP Operation Think Time – Max

double

SOAP Operation Think Time – Perc

double

SOAP Operation Think Time – Mean

double

SOAP Operation Think Time – Std Dev

bigint(20) unsigned

SOAP Operation Consumer Overhead - Pass

double

SOAP Operation Consumer Overhead

bigint(20) unsigned

SOAP Operation Consumer Overhead – Total

bigint(20) unsigned

SOAP Operation Provider Overhead - Pass

double

SOAP Operation Provider Overhead

bigint(20) unsigned

SOAP Operation Provider Overhead – Total

bigint(20) unsigned

Total Response Codes

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

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

Soap Web Service Metric table

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

bigint(20) unsigned

Soap Operation Timeout Count

bigint(20) unsigned

Soap Operation Count

bigint(20) unsigned

Soap Operation Success Ratio – Pass

bigint(20) unsigned

Soap Operation Success Ratio – Total

double

Soap Operation Success Ratio

int(11)

Soap Operation Request Peak Count per Second

int(11)

Soap Operation Peak Count per Second

bigint(20) unsigned

SOAP Operation Think Time - Count

double

SOAP Operation Think Time – Sum

double

SOAP Operation Think Time – Sum Sq

double

SOAP Operation Think Time – Min

double

SOAP Operation Think Time – Max

double

SOAP Operation Think Time – Perc

double

SOAP Operation Think Time – Mean

double

SOAP Operation Think Time – Std Dev

bigint(20) unsigned

SOAP Operation Consumer Overhead - Pass

double

SOAP Operation Consumer Overhead

bigint(20) unsigned

SOAP Operation Consumer Overhead – Total

bigint(20) unsigned

SOAP Operation Provider Overhead - Pass

double

SOAP Operation Provider Overhead

bigint(20) unsigned

SOAP Operation Provider Overhead – Total

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating