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

MeasureID

Table 80. MeasureID

Command Initial Response Time Distribution

Request Codes

Response Codes

Page List

Hit List

Site List

Server List

Path List

Access Speed Distribution

Page Access Speed Distribution

Page End-to-End Time Distribution

Service End-to-End Time Distribution

Soap Web Service List

Soap Operation List

Soap Consumer List

Soap Server List

Page Processing Time Distribution

Service Processing Time Distribution

SOAP Operation Processing Time Distribution

SOAP Operation Completion Time Distribution

SOAP Transaction Processing Time Distribution

SOAP Transaction Completion Time Distribution

SOAP Operation End-to-End Time Distribution

SOAP Transaction End-to-End Time Distribution

TimeType

Table 81. TimeType

5-Minute Interval

Hourly

Daily

Weekly

Monthly

Hourly baseline

Daily baseline

Weekly baseline

Monthly baseline

TimeStamp

Timestamps are datetime fields that contain the starting time for the metrics contained in the record. To determine the entire range of time encompassed by the data you will need to evaluate the TimeType in conjunction with the TimeStamp. Note that all timestamps are in UTC (Universal Coordinated Time) and not in the local time zone.

To illustrate by way of example consider this timestamp:

This timestamp indicates the date and time of January 10, 2008 at 12:00 UTC. If the TimeType field for this record is 2 indicating this is hourly data then this record represents metrics for 12:00 to 13:00 on January 10, 2008.

Note that for other time frames the TimeStamp field will always indicate the starting time of the interval. For example, monthly data for January would have the timestamp:

Note that the timestamp indicates the 5:00 hour which is the UTC time that corresponds with midnight in the Eastern US time zone. Daily and weekly data timestamps will also have this UTC offset.

TimePeriod

TimePeriod fields are only useful for hourly and daily data. For those time frames, the TimePeriod field represents the period associated with the time range the data represents.

For hourly data, this is the local time zone hour ranging from 0-23.

For daily data, this is the day of the week ranging from 0 to 6 where 0 is Sunday, 1 is Monday and so on.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating