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

Enterprise ValueCount table

This table contains distributions and reference counter metrics for an Enterprise object for a specific time interval.

This schema applies to 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

Enterprise Resource table

This table contains information about the resources (or objects) in the Enterprise category.

This schema applies for the following table:

* indicates the primary key

¹ indicates an index

tinyint(1)

Unused

char(34)

Unique identifier for this resource (object)

text

Name of the resource

text

Displayable name of the resource

HTTP Fault database

The HttpFault database contains records for the HTTP 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)

URL that triggered the fault

char(34)

Unique identifier for Server where fault occurred

char(34)

Unique identifier for User session that triggered fault

char(34)

Unique identifier for Hit that fault occurred on

int(10) unsigned

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

datetime

Date and time the fault occurred

varchar(1024)

Referring URL

Location database

The Location database contains records for the Location categories:

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

For details, see these topics:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating