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

Server ValueCount table

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

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

Server Resource table

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

Server Relation table

These tables contain information about object relationships in the Page categories whose metrics have been recorded. 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

Server by Port Metric table

This table contains metrics for a Server By Port object 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

SSL Connections Started

bigint(20) unsigned

SSL Connections Released

bigint(20) unsigned

SSL Connection Errors

bigint(20) unsigned

SSL Connection Error Rate – Pass

bigint(20) unsigned

SSL Connection Error Rate – Total

bigint(20) unsigned

SSL Connection Error Rate

bigint(20) unsigned

Missing SSL Key

bigint(20) unsigned

Invalid SSL Handshake Type

bigint(20) unsigned

Cipher Suite Not Found

bigint(20) unsigned

Unknown Key Exchange

bigint(20) unsigned

Missing Reusable Secret

bigint(20) unsigned

Unexpected ClientHello Message

bigint(20) unsigned

Unexpected ServerHello Message

bigint(20) unsigned

Invalid SSL Content

bigint(20) unsigned

Invalid SSL Record Length

bigint(20) unsigned

Field out of Range

bigint(20) unsigned

Invalid SSL Version Number

bigint(20) unsigned

SSL Memory Error

bigint(20) unsigned

Incomplete SSL Key

bigint(20) unsigned

Invalid SSL Key

bigint(20) unsigned

Invalid SSL State

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating