Foglight Experience Monitor 5.8.1

Table 38. Server by Port Resource table schema
Column	Type	Comment
Inactive	tinyint(1)	1 = resource is inactive; configuration has been deleted
ResourceID *	char(34)	Unique identifier for this resource (object)
Name	text	Name of the resource
DisplayName	text	Displayable name of the resource

Service database

The Service database contains records for the Application categories:

•

•

•

•

•

•

The tables in this database contain metrics and resource (or object) names.

For details, see these topics:

•

Service Metric tables

•

Service Step Metric tables

•

Service ValueCount tables

•

Service Resource tables

•

Service Relation tables

Service Metric tables

These tables contain metrics for Service category objects for a specific time interval.

This schema applies to the following tables:

•

•

•

•

•

•

* indicates the primary key

¹ indicates an index

Table 39. service Metric tables schema
Column	Type	Comment
BucketID *	int(11)	For internal use only
TimeType *	tinyint(4)	See TimeType in Appendix A
TimePeriod *	tinyint(3) unsigned	See TimePeriod in Appendix A
ResourceID *	char(34)	Unique identifier for this resource (object)
SampleCount	bigint(20) unsigned	See SampleCount in Appendix A
TimeStamp *	datetime	See TimeStamp in Appendix A
GroupID	int(11)	1 = HTTP, 2 = HTTPS, 0 = None
MissingData	tinyint(1)	1 = this record does not include all probes
ClientPacketCnt	bigint(20) unsigned	IP Packet Count – User
ClientPacketSum	double	IP Packet Byte Volume – User
ClientPacketSumSq	double	IP Packet Size – User – Sum Sq
ClientPacketMin	double	IP Packet Size – User – Min
ClientPacketMax	double	IP Packet Size – User – Max
ClientPacketPerc	double	IP Packet Size – User – Perc
ClientPacketMean	double	IP Packet Size – User – Mean
ClientPacketStd	double	IP Packet Size – User – Std Dev
ServerPacketCnt	bigint(20) unsigned	IP Packet Count – Server
ServerPacketSum	double	IP Packet Byte Volume – Server
ServerPacketSumSq	double	IP Packet Size – Server – Sum Sq
ServerPacketMin	double	IP Packet Size – Server – Min
ServerPacketMax	double	IP Packet Size – Server – Max
ServerPacketPerc	double	IP Packet Size – Server – Perc
ServerPacketMean	double	IP Packet Size – Server – Mean
ServerPacketStd	double	IP Packet Size – Server – Std Dev
RequestDataCnt	bigint(20) unsigned	Command Data Size – User – Count
RequestDataSum	double	Command Byte Volume – User
RequestDataSumSq	double	Command Data Size – User – Sum Sq
RequestDataMin	double	Command Data Size – User – Min
RequestDataMax	double	Command Data Size – User – Max
RequestDataPerc	double	Command Data Size – User – Perc
RequestDataMean	double	Command Data Size – User – Mean
RequestDataStd	double	Command Data Size – User – Std Dev
ResponseDataCnt	bigint(20) unsigned	Command Data Size – Server – Count
ResponseDataSum	double	Command Byte Volume – Server
ResponseDataSumSq	double	Command Data Size – Server – Sum Sq
ResponseDataMin	double	Command Data Size – Server – Min
ResponseDataMax	double	Command Data Size – Server – Max
ResponseDataPerc	double	Command Data Size – Server – Perc
ResponseDataMean	double	Command Data Size – Server – Mean
ResponseDataStd	double	Command Data Size – Server – Std Dev
ServiceCount	bigint(20) unsigned	Service Count
ServiceAbortCount	bigint(20) unsigned	Service Abort Count
ServiceTimeoutCount	bigint(20) unsigned	Service Timeout Count
ServiceDurationCnt	bigint(20) unsigned	Service Duration – Count
ServiceDurationSum	double	Service Duration – Sum
ServiceDurationSumSq	double	Service Duration – Sum Sq
ServiceDurationMin	double	Service Duration – Min
ServiceDurationMax	double	Service Duration – Max
ServiceDurationPerc	double	Service Duration – Perc
ServiceDurationMean	double	Service Duration – Mean
ServiceDurationStd	double	Service Duration – Std Dev
ServiceEndToEndTimeCnt	bigint(20) unsigned	Service End-to-End Time – Count
ServiceEndToEndTimeSum	double	Service End-to-End Time – Sum
ServiceEndToEndTimeSumSq	double	Service End-to-End Time – Sum Sq
ServiceEndToEndTimeMin	double	Service End-to-End Time – Min
ServiceEndToEndTimeMax	double	Service End-to-End Time – Max
ServiceEndToEndTimePerc	double	Service End-to-End Time – Perc
ServiceEndToEndTimeMean	double	Service End-to-End Time – Mean
ServiceEndToEndTimeStd	double	Service End-to-End Time – Std Dev
ServiceThinkTimeCnt	bigint(20) unsigned	Service Think Time – Count
ServiceThinkTimeSum	double	Service Think Time – Sum
ServiceThinkTimeSumSq	double	Service Think Time – Sum Sq
ServiceThinkTimeMin	double	Service Think Time – Min
ServiceThinkTimeMax	double	Service Think Time – Max
ServiceThinkTimePerc	double	Service Think Time – Perc
ServiceThinkTimeMean	double	Service Think Time – Mean
ServiceThinkTimeStd	double	Service Think Time – Std Dev
ServiceCommandInitialResponseTimeCnt	bigint(20) unsigned	Service Command Initial Response Time – Count
ServiceCommandInitialResponseTimeSum	double	Service Command Initial Response Time – Sum
ServiceCommandInitialResponseTimeSumSq	double	Service Command Initial Response Time – Sum Sq
ServiceCommandInitialResponseTimeMin	double	Service Command Initial Response Time – Min
ServiceCommandInitialResponseTimeMax	double	Service Command Initial Response Time – Max
ServiceCommandInitialResponseTimePerc	double	Service Command Initial Response Time – Perc
ServiceCommandInitialResponseTimeMean	double	Service Command Initial Response Time – Mean
ServiceCommandInitialResponseTimeStd	double	Service Command Initial Response Time – Std Dev
ServiceProcessingTimeCnt	bigint(20) unsigned	Service Processing Time – Count
ServiceProcessingTimeSum	double	Service Processing Time – Sum
ServiceProcessingTimeSumSq	double	Service Processing Time – Sum Sq
ServiceProcessingTimeMin	double	Service Processing Time – Min
ServiceProcessingTimeMax	double	Service Processing Time – Max
ServiceProcessingTimePerc	double	Service Processing Time – Perc
ServiceProcessingTimeMean	double	Service Processing Time – Mean
ServiceProcessingTimeStd	double	Service Processing Time – Std Dev
ServiceClientTimeCnt	bigint(20) unsigned	Service Client Time – Count
ServiceClientTimeSum	double	Service Client Time – Sum
ServiceClientTimeSumSq	double	Service Client Time – Sum Sq
ServiceClientTimeMin	double	Service Client Time – Min
ServiceClientTimeMax	double	Service Client Time – Max
ServiceClientTimePerc	double	Service Client Time – Perc
ServiceClientTimeMean	double	Service Client Time – Mean
ServiceClientTimeStd	double	Service Client Time – Std Dev
ServiceNetworkLatencyCnt	bigint(20) unsigned	Service Network Latency – Count
ServiceNetworkLatencySum	double	Service Network Latency – Sum
ServiceNetworkLatencySumSq	double	Service Network Latency – Sum Sq
ServiceNetworkLatencyMin	double	Service Network Latency – Min
ServiceNetworkLatencyMax	double	Service Network Latency – Max
ServiceNetworkLatencyPerc	double	Service Network Latency – Perc
ServiceNetworkLatencyMean	double	Service Network Latency – Mean
ServiceNetworkLatencyStd	double	Service Network Latency – Std Dev
ServicePeakCount	int(10) unsigned	Service Peak Count per Second
ServiceRequestPeakCount	int(10) unsigned	Service Request Peak Count per Second
ServiceProcessingLoadPass	bigint(20) unsigned	Service Processing Load – Pass
ServiceProcessingLoadTotal	bigint(20) unsigned	Service Processing Load – Total
ServiceProcessingLoadPerc	double	Service Processing Load
ServiceProcessingTimeServiceLevelPass	bigint(20) unsigned	Service Processing Time Service Level – Pass
ServiceProcessingTimeServiceLevelTotal	bigint(20) unsigned	Service Processing Time Service Level – Total
ServiceProcessingTimeServiceLevelPerc	double	Service Processing Time Service Level
ServiceStartCount	bigint(20) unsigned	Service Started Count

Service Step Metric tables

These tables contain metrics for Service Step category objects for a specific time interval.

This schema applies to the following tables:

•

•

•

•

•

•

* indicates the primary key

¹ indicates an index

Table 40. Service Step Metric tables schema
Column	Type	Comment
BucketID *	int(11)	For internal use only
TimeType *	tinyint(4)	See TimeType in Appendix A
TimePeriod *	tinyint(3) unsigned	See TimePeriod in Appendix A
ResourceID *	char(34)	Unique identifier for this resource (object)
SampleCount	bigint(20) unsigned	See SampleCount in Appendix A
TimeStamp *	datetime	See TimeStamp in Appendix A
GroupID	int(11)	1 = HTTP, 2 = HTTPS, 0 = None
MissingData	tinyint(1)	1 = this record does not include all probes
ClientPacketCnt	bigint(20) unsigned	IP Packet Count – User
ClientPacketSum	double	IP Packet Byte Volume – User
ClientPacketSumSq	double	IP Packet Size – User – Sum Sq
ClientPacketMin	double	IP Packet Size – User – Min
ClientPacketMax	double	IP Packet Size – User – Max
ClientPacketPerc	double	IP Packet Size – User – Perc
ClientPacketMean	double	IP Packet Size – User – Mean
ClientPacketStd	double	IP Packet Size – User – Std Dev
ServerPacketCnt	bigint(20) unsigned	IP Packet Count – Server
ServerPacketSum	double	IP Packet Byte Volume – Server
ServerPacketSumSq	double	IP Packet Size – Server – Sum Sq
ServerPacketMin	double	IP Packet Size – Server – Min
ServerPacketMax	double	IP Packet Size – Server – Max
ServerPacketPerc	double	IP Packet Size – Server – Perc
ServerPacketMean	double	IP Packet Size – Server – Mean
ServerPacketStd	double	IP Packet Size – Server – Std Dev
RequestDataCnt	bigint(20) unsigned	Command Data Size – User – Count
RequestDataSum	double	Command Byte Volume – User
RequestDataSumSq	double	Command Data Size – User – Sum Sq
RequestDataMin	double	Command Data Size – User – Min
RequestDataMax	double	Command Data Size – User – Max
RequestDataPerc	double	Command Data Size – User – Perc
RequestDataMean	double	Command Data Size – User – Mean
RequestDataStd	double	Command Data Size – User – Std Dev
ResponseDataCnt	bigint(20) unsigned	Command Data Size – Server – Count
ResponseDataSum	double	Command Byte Volume – Server
ResponseDataSumSq	double	Command Data Size – Server – Sum Sq
ResponseDataMin	double	Command Data Size – Server – Min
ResponseDataMax	double	Command Data Size – Server – Max
ResponseDataPerc	double	Command Data Size – Server – Perc
ResponseDataMean	double	Command Data Size – Server – Mean
ResponseDataStd	double	Command Data Size – Server – Std Dev
PageDownloadAttemptCount	bigint(20) unsigned	Page Download Attempts
PageRedirectRatioPass	bigint(20) unsigned	Page Redirect Ratio – Pass
PageRedirectRatioTotal	bigint(20) unsigned	Page Redirect Ratio – Total
PageRedirectRatioPerc	double	Page Redirect Ratio
PageEndToEndTimeCnt	bigint(20) unsigned	Page End-to-End Time – Count
PageEndToEndTimeSum	double	Page End-to-End Time – Sum
PageEndToEndTimeSumSq	double	Page End-to-End Time – Sum Sq
PageEndToEndTimeMin	double	Page End-to-End Time – Min
PageEndToEndTimeMax	double	Page End-to-End Time – Max
PageEndToEndTimePerc	double	Page End-to-End Time – Perc
PageEndToEndTimeMean	double	Page End-to-End Time – Mean
PageEndToEndTimeStd	double	Page End-to-End Time – Std Dev
PageProcessingTimeCnt	bigint(20) unsigned	Page Processing Time – Count
PageProcessingTimeSum	double	Page Processing Time – Sum
PageProcessingTimeSumSq	double	Page Processing Time – Sum Sq
PageProcessingTimeMin	double	Page Processing Time – Min
PageProcessingTimeMax	double	Page Processing Time – Max
PageProcessingTimePerc	double	Page Processing Time – Perc
PageProcessingTimeMean	double	Page Processing Time – Mean
PageProcessingTimeStd	double	Page Processing Time – Std Dev
PageClientTimeCnt	bigint(20) unsigned	Page Client Time – Count
PageClientTimeSum	double	Page Client Time – Sum
PageClientTimeSumSq	double	Page Client Time – Sum Sq
PageClientTimeMin	double	Page Client Time – Min
PageClientTimeMax	double	Page Client Time – Max
PageClientTimePerc	double	Page Client Time – Perc
PageClientTimeMean	double	Page Client Time – Mean
PageClientTimeStd	double	Page Client Time – Std
PageThinkTimeCnt	bigint(20) unsigned	Page Think Time – Count
PageThinkTimeSum	double	Page Think Time – Sum
PageThinkTimeSumSq	double	Page Think Time – Sum Sq
PageThinkTimeMin	double	Page Think Time – Min
PageThinkTimeMax	double	Page Think Time – Max
PageThinkTimePerc	double	Page Think Time – Perc
PageThinkTimeMean	double	Page Think Time – Mean
PageThinkTimeStd	double	Page Think Time – Std Dev
PageStopTimeCnt	bigint(20) unsigned	Page Stop Time – Count
PageStopTimeSum	double	Page Stop Time – Sum
PageStopTimeSumSq	double	Page Stop Time – Sum Sq
PageStopTimeMin	double	Page Stop Time – Min
PageStopTimeMax	double	Page Stop Time – Max
PageStopTimePerc	double	Page Stop Time – Perc
PageStopTimeMean	double	Page Stop Time – Mean
PageStopTimeStd	double	Page Stop Time – Std Dev
PageStopRatePass	bigint(20) unsigned	Page Stop Rate – Pass
PageStopRateTotal	bigint(20) unsigned	Page Stop Rate – Total
PageStopRatePerc	double	Page Stop Rate
PageNetworkLatencyCnt	bigint(20) unsigned	Page Network Latency – Count
PageNetworkLatencySum	double	Page Network Latency – Sum
PageNetworkLatencySumSq	double	Page Network Latency – Sum Sq
PageNetworkLatencyMin	double	Page Network Latency – Min
PageNetworkLatencyMax	double	Page Network Latency – Max
PageNetworkLatencyPerc	double	Page Network Latency – Perc
PageNetworkLatencyMean	double	Page Network Latency – Mean
PageNetworkLatencyStd	double	Page Network Latency – Std Dev
PageConnectionCountCnt	bigint(20) unsigned	Page Connection Count – Count
PageConnectionCountSum	double	Page Connection Count – Sum
PageConnectionCountSumSq	double	Page Connection Count – Sum Sq
PageConnectionCountMin	double	Page Connection Count – Min
PageConnectionCountMax	double	Page Connection Count – Max
PageConnectionCountPerc	double	Page Connection Count – Perc
PageConnectionCountMean	double	Page Connection Count – Mean
PageConnectionCountStd	double	Page Connection Count – Std Dev
PageElementCountCnt	bigint(20) unsigned	Page Element Count – Count
PageElementCountSum	double	Page Element Count – Sum
PageElementCountSumSq	double	Page Element Count – Sum Sq
PageElementCountMin	double	Page Element Count – Min
PageElementCountMax	double	Page Element Count – Max
PageElementCountPerc	double	Page Element Count – Perc
PageElementCountMean	double	Page Element Count – Mean
PageElementCountStd	double	Page Element Count – Std Dev
PageDownloadSizeCnt	bigint(20) unsigned	Page Download Size – Count
PageDownloadSizeSum	double	Page Download Size – Sum
PageDownloadSizeSumSq	double	Page Download Size – Sum Sq
PageDownloadSizeMin	double	Page Download Size – Min
PageDownloadSizeMax	double	Page Download Size – Max
PageDownloadSizePerc	double	Page Download Size – Perc
PageDownloadSizeMean	double	Page Download Size – Mean
PageDownloadSizeStd	double	Page Download Size – Std Dev
PageTimeoutCount	bigint(20) unsigned	Page Timeout Count
StepStartedCount	bigint(20) unsigned	Step Started Count
StepCompletionCount	bigint(20) unsigned	Step Completion Count
StepAbortCount	bigint(20) unsigned	Step Abort Count
StepTimeoutCount	bigint(20) unsigned	Step Timeout Count

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight Experience Monitor 5.8.1 - SQL Reference Guide

Server by Port Resource table

Service database

Service Metric tables

Service Step Metric tables