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

System Database Metric table

This table contains metrics for System Database category objects for a specific time interval.

This schema applies to the following table:

* indicates the primary key

¹ indicates an index

int(11)

For internal use only

char(34)

Unique identifier for this resource (object)

tinyint(4)

See TimeType in Appendix A

tinyint(3) unsigned

See TimePeriod in Appendix A

datetime

See TimeStamp in Appendix A

bigint(20) unsigned

The number of bytes consumed on the file system by the category’s baseline data partition

bigint(20) unsigned

The number of bytes consumed on the file system by the category’s day data partition

int(11)

1 = HTTP, 2 = HTTPS, 0 = None

bigint(20) unsigned

The number of bytes consumed on the file system by the category’s hour data partition

bigint(20) unsigned

Metric Table Entries

bigint(20) unsigned

The number of bytes consumed on the file system by the category’s metric table

bigint(20) unsigned

The number of bytes consumed on the file system by the category’s 5-minute interval data partitions

tinyint(1)

1 = this record does not include all probes

bigint(20) unsigned

The number of bytes consumed on the file system by the category’s month data partition

bigint(20) unsigned

Resource Table Entries

bigint(20) unsigned

The number of bytes consumed on the file system by the category’s resource table

bigint(20) unsigned

Relation Table Entries

bigint(20) unsigned

The number of bytes consumed on the file system by the category’s relation table

bigint(20) unsigned

See SampleCount in Appendix A

bigint(20) unsigned

The number of bytes consumed on the file system by all category’s metric tables

bigint(20) unsigned

Value Count Table Entries

bigint(20) unsigned

The number of bytes consumed on the file system by the category’s value count table

bigint(20) unsigned

The number of bytes consumed on the file system by the category’s week data partition

System Database Resource table

These tables contain information about the resources (or objects) in the System Database category.

This schema applies to the following table:

* indicates the primary key

¹ indicates an index

int(11)

Integer value that uniquely identifies the category

varchar (255)

The name of the database in which the category’s table resides

text

Displayable name of the resource

tinyint(1)

1 = resource is inactive; configuration has been deleted

text

Name of the resource

char(34)

Unique identifier for this resource (object)

System Health Metric table

This table contains metrics for System Health category objects for a specific time interval.

This schema applies to the following table:

* 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

char(34)

Unique identifier for this resource (object)

bigint(20) unsigned

See SampleCount in Appendix A

datetime

See TimeStamp in Appendix A

int(11)

1 = HTTP, 2 = HTTPS, 0 = None

tinyint(1)

1 = this record does not include all probes

bigint(20) unsigned

Packets Captured

bigint(20) unsigned

Packets Processed

bigint(20) unsigned

Packets Dropped

bigint(20) unsigned

Packets Captured – Port 1

bigint(20) unsigned

Packets Processed – Port 1

bigint(20) unsigned

Packets Dropped – Port 1

bigint(20) unsigned

Packets Captured – Port 2

bigint(20) unsigned

Packets Processed – Port 2

bigint(20) unsigned

Packets Dropped – Port 2

bigint(20) unsigned

Packets Captured – Port 3

bigint(20) unsigned

Packets Processed – Port 3

bigint(20) unsigned

Packets Dropped – Port 3

bigint(20) unsigned

Packets Captured – Port 4

bigint(20) unsigned

Packets Processed – Port 4

bigint(20) unsigned

Packets Dropped – Port 4

bigint(20) unsigned

Packets Captured – Port 5

bigint(20) unsigned

Packets Processed – Port 5

bigint(20) unsigned

Packets Dropped – Port 5

bigint(20) unsigned

Packets Captured – Port 6

bigint(20) unsigned

Packets Processed – Port 6

bigint(20) unsigned

Packets Dropped – Port 6

bigint(20) unsigned

Packets Captured – Port 7

bigint(20) unsigned

Packets Processed – Port 7

bigint(20) unsigned

Packets Dropped – Port 7

bigint(20) unsigned

Packets Captured – Port 8

bigint(20) unsigned

Packets Processed – Port 8

bigint(20) unsigned

Packets Dropped – Port 8

bigint(20) unsigned

SSL Connections Released

bigint(20) unsigned

SSL Connections Started

bigint(20) unsigned

Connections Started

bigint(20) unsigned

Connections Dropped

bigint(20) unsigned

Connection Errors

bigint(20) unsigned

Checksum Errors

bigint(20) unsigned

Client Segments Count

bigint(20) unsigned

Server Segments Count

bigint(20) unsigned

Clients Segments Missing

bigint(20) unsigned

Server Segments Missing

bigint(20) unsigned

Database Records Loaded

bigint(20) unsigned

Database Load Time

bigint(20) unsigned

Agent Restarts

bigint(20) unsigned

Memory Consumption Warnings

bigint(20) unsigned

Agent Memory Consumption Warnings

bigint(20) unsigned

SOAP Errors

bigint(20) unsigned

SOAP XML Errors

bigint(20) unsigned

SOAP Message Count

bigint(20) unsigned

CPU Utilization – Pass

bigint(20) unsigned

CPU Utilization – Total

double

CPU Utilization – Perc

bigint(20) unsigned

CPU Core 1 Utilization – Pass

bigint(20) unsigned

CPU Core 1 Utiliization – Total

double

CPU Core 1 Utilization – Perc

bigint(20) unsigned

CPU Core 2 Utilization – Pass

bigint(20) unsigned

CPU Core 2 Utiliization – Total

double

CPU Core 2 Utilization – Perc

bigint(20) unsigned

CPU Core 3Utilization – Pass

bigint(20) unsigned

CPU Core 3Utiliization – Total

double

CPU Core 3Utilization – Perc

bigint(20) unsigned

CPU Core 4 Utilization – Pass

bigint(20) unsigned

CPU Core 4 Utiliization – Total

double

CPU Core 4 Utilization – Perc

bigint(20) unsigned

CPU Core 5 Utilization – Pass

bigint(20) unsigned

CPU Core 5 Utiliization – Total

double

CPU Core 5 Utilization – Perc

bigint(20) unsigned

CPU Core 6 Utilization – Pass

bigint(20) unsigned

CPU Core 6 Utiliization – Total

double

CPU Core 6 Utilization – Perc

bigint(20) unsigned

CPU Core 7 Utilization – Pass

bigint(20) unsigned

CPU Core 7 Utiliization – Total

double

CPU Core 7 Utilization – Perc

bigint(20) unsigned

CPU Core 8Utilization – Pass

bigint(20) unsigned

CPU Core 8 Utiliization – Total

double

CPU Core 8 Utilization – Perc

bigint(20) unsigned

Backup Errors

bigint(20) unsigned

SiteMinder Errors

bigint(20) unsigned

FxV Bytes Transmitted

bigint(20) unsigned

FxV Discards

bigint(20) unsigned

FxV Hits Transmitted

System Health Resource table

These tables contain information about the resources (or objects) in the System Health category.

This schema applies to the following table:

* 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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating