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

Synthetic Service Metric table

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

Path Duration – Count

double

I Path Duration – Sum

double

Path Duration – Sum Sq

double

Path Duration – Min

double

Path Duration – Max

double

Path Duration – Perc

double

Path Duration – Mean

double

Path Duration – Std Dev

bigint(20) unsigned

Path End-to-End Time – Count

double

Path End-to-End Time – Sum

double

Path End-to-End Time – Sum Sq

double

Path End-to-End Time – Min

double

Path End-to-End Time – Max

double

Path End-to-End Time – Perc

double

Path End-to-End Time – Mean

double

Path End-to-End Time – Std Dev

Page ValueCount tables

These tables contain distributions and reference counter metrics for Page category objects for a specific time interval.

This schema applies to the following tables:

* 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

Page Resource tables

These tables contain information about the resources (or objects) in the Page categories.

This schema applies to the following tables:

* 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

tinyint(1)

1 = resource has HTTP metrics

tinyint(1)

1 = resource has HTTPS metrics

This schema applies to the following tables:

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

Page Relation tables

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 tables:

* 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