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

This table contains distributions and reference counter metrics for the SOAP Application, Soap Operation, Soap Server and Soap Web Service 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 = 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 Resource tables

These tables contain information about the resources (or objects) in the Soap Application, Soap Operation, Soap Server and Soap Web Service 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 Relation tables

These tables contain information about object relationships in the Soap Web Service and Soap Server 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

Soap Consumer database

This database contains records for the Soap Consumer 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