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 Consumer Metric tables

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

bigint(20) unsigned

Soap Operation Failure 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

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

Soap Consumer ValueCount table

This table contains distributions and reference counter metrics for the Soap Consumer category 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

datetime

See TimeStamp in Appendix A

smallint(6)

Distribution configuration identifier

smallint(6)

See MeasureID in Appendix A

tinyint(4)

1 = HTTP, 2 = HTTPS, 0 = None

char(34)

Unique identifier for this resource (object)

int(10) unsigned

Described in Metric tables

bigint(20) unsigned

Described in Metric tables

Soap Consumer Resource table

These tables contain information about the resources (or objects) in the Soap Consumer 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

Soap Consumer Relation table

These tables contain information about object relationships in the Soap Consumer category. The ResourceID and ChildResourceID columns identify the parent and child objects respectively.

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

datetime

See TimeStamp in Appendix A

char(34)

Unique identifier for this resource (object)

char(34)

Unique identifier for this resource (object)

smallint(6)

See MeasureID in Appendix A

int(11)

1 = HTTP, 2 = HTTPS, 0 = None

smallint(6)

Ordinal position in a sequence if applicable

tinyint(4)

1 = HTTP, 2 = HTTPS, 0 = None

bigint(20)

Count for the relationship if applicable

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating