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 Transaction ValueCount tables

This table contains distributions and reference counter metrics for the Soap Transaction and Soap Transaction Step categories 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 = HTT,P 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 Transaction Resource tables

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

Soap Transaction Relation table

These tables contain information about object relationships in the Soap Transaction 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

Subnet database

The Subnet database contains records for the Subnet category.

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