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


SampleCount represents the number of finer granularity records that were aggregated to create the current record. For 5-minute interval data, this field is always 1. For hourly data, this field will typically be 12 since an hour consists of 12 5-minute periods. If this field is less than 12 that indicates that some 5-minute intervals within the hour had no metrics.

For daily data, SampleCount would normally be 24. For weekly data, it would be 7 and for monthly data it would normally be 28 to 31 depending on the number of days in the month. Again, if the SampleCount is less than these values that indicates that the finer granularity metrics used to aggregate the current record had some gaps. This is to be expected for many categories of data since most monitored applications have some periods of inactivity.


Appendix: Example queries

The section provides examples of sample queries:


This query searches for alarms from January 30 12:00 to 12:20 UTC.


This query searches for a 5-minute interval record of metrics for a specific city from January 30 12:45 UTC.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating