Foglight Experience Monitor 5.8.1

Table 41. Service ValueCount 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
TimeStamp *	datetime	See TimeStamp in Appendix A
Version	smallint(6)	Distribution configuration identifier
MeasureID	smallint(6)	See MeasureID in Appendix A
GroupID	tinyint(4)	1 = HTTP, 2 = HTTPS, 0 = None
ResourceID *	char(34)	Unique identifier for this resource (object)
Value	int(10) unsigned	Described in Metric tables
Count	bigint(20) unsigned	Described in Metric tables

Service Resource tables

These tables contain information about the resources (or objects) in the Service categories.

This schema applies to the following tables:

•

ServiceResource

•

ServiceByCityResource

•

ServiceByCountryResource

•

ServiceByIspResource

•

ServiceByRegionResource

•

ServiceBySubnetResource

•

ServiceStepResource

•

ServiceStepByCityResource

•

ServiceStepByCountryResource

•

ServiceStepByIspResource

•

ServiceStepByRegionResource

•

ServiceStepBySubnetResource

* indicates the primary key

¹ indicates an index

Table 42. Service Resource tables 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
ConfigurationID	bigint(20)	Configuration database identifier for the Service

Service Relation tables

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

•

ServiceRelation

•

ServiceByCityRelation

•

ServiceByCountryRelation

•

ServiceByIspRelation

•

ServiceByRegionRelation

•

ServiceBySubnetRelation

* indicates the primary key

¹ indicates an index

Table 43. Service Relation 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
TimeStamp *	datetime	See TimeStamp in Appendix A
ResourceID *	char(34)	Unique identifier for this resource (object)
ChildResourceID *	char(34)	Unique identifier for this resource (object)
MeasureID	smallint(6)	See MeasureID in Appendix A
GroupID	int(11)	1 = HTTP, 2 = HTTPS, 0 = None
SequenceID	smallint(6)	Ordinal position in a sequence if applicable
ChildGroupID	tinyint(4)	1 = HTTP, 2 = HTTPS, 0 = None
ChildCount	bigint(20)	Count for the relationship if applicable