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

User Session ValueCount table

This table contains distributions and reference counter metrics for User Session category objects.

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

datetime

See TimeStamp in Appendix A

smallint(6)

Distribution configuration identifier

smallint(6)

See MeasureID in Appendix A

tinyint(4)

1 = HTTP, 2 = HTTPS, 0 = None

char(34)

Unique identifier for this resource (object)

int(10) unsigned

Described in Metric tables

bigint(20) unsigned

Described in Metric tables

 

Appendix: Column description

This section presents the column descriptions for the Foglight Experience Monitor metrics stored in the SQL database.

For details, see these topics:

CategoryID

Table 78. CategoryID

Server

HTTP Protocol

Site

Content Type

Page

Hit

Service

User Agent

Path

Subnet

ISP

Service Step

User Session

Application Component

Enterprise

User Session Hit

Soap Operation

Soap Consumer

Soap Server

Soap Transaction

Soap Web Service

User Session Page

Service by City

Service by Subnet

Synthetic Transaction

Application by City

Application by Subnet

System Health

City

Region

Country

Service by Region

Service by Country

Service by ISP

Application by Region

Application by Country

Application by ISP

Service Step by Subnet

Service Step by City

Service Step by Region

Service Step by Country

Service Step by ISP

Soap Fault

Http Fault

System Database

TCP Protocol

TCP Protocol By Server

TCP Protocol By Subnet

Soap Application

Instrumented Page

Instrumented Application

Instrumented Application By City

Instrumented Application By Country

Instrumented Application By ISP

Instrumented Application By Region

Instrumented Application By User Agent

HTTP codes

Table 79. HTTP codes

Continue

Switching Protocol

OK

Created

Accepted

Non-Authoritative Information

No Content

Reset Content

Partial Content

Multiple Choices

Moved Permanently

Found

See Other

Not Modified

Use Proxy

Temporary Redirect

Bad Request

Unauthorized

Payment Required

Forbidden

Not Found

Method Not Allowed

Not Acceptable

Proxy Authentication Required

Request Timeout

Conflict

Gone

Length Required

Entity Request Too Large

Request-URI Too Long

Unsupported Media Type

Request Range Not Satisfiable

Expectation Failed

Internal Server Error

Not Implemented

Bad Gateway

Service Unavailable

Gateway Timeout

HTTP Version Not Supported

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating