Overview
Goliath Performance Monitor allows for third-party Business Intelligence products like Microsoft Power BI, Excel, Tableau, or your own custom applications, to be used to create advanced reports and data analysis. This document describes the database views that are available. These can be used to create your own custom reports.
Goliath Database Views
GPM version 11.7.7.6 and later includes database views that can be used to create your own reports using tools like Microsoft’s Power BI or Excel, Tableau, or for advanced users, with custom reporting applications that can extract and report on SQL Server data.
The following database views are available with the GPM database:
- Advanced View
- Citrix License Metrics View
- Citrix License Usage by Date View
- Citrix LOS Custom Check Log Data View
- Citrix XenApp Session Duration View
- Citrix XenDesktop Session Duration View
- Event Log View
- File Check View
- Horizon LOD Reporting View (Logon Duration)
- LODReporting View (Citrix Logon Duration)
- LOS View (GAAM)
- Performance Metrics View
- Process View
- Server View
- SNMP Trap View
- Syslog Messages View
- Performance Monitoring View
- Server Metrics View
- Service View
- Uptime and Availability View
- Util List PK
- Win Service View
The sections below describe the data available with each view.
Advanced View
|
Attribute Name |
Attribute Type |
Description |
| AlertGroupID | INT | ID of the alert group |
| AlertName | NVARCHAR | Name of the monitoring rule |
| DTime | Date/Time | Date/Time of measurement |
| ExitCode | INT | Code returned |
| ProcessID | INT | |
| ProgramCLO | NVARCHAR | |
| ProgramName | NVARCHAR | |
| ProgramStatus | INT | |
| MonitorDescription | NVARCHAR | |
| ServerName | NVARCHAR |
Citrix License Metrics View
|
Attribute Name |
Attribute Type |
Description |
|
AVGSessionCount |
NUMBER |
Average number of user session |
|
AvgUserCount |
NUMBER |
Average number of users logged in |
|
MaxSessionCount |
NUMBER |
Highest measured session count |
|
MaxUserCount |
NUMBER |
Highest measured users logged in |
|
MinSessionCount |
NUMBER |
Lowest measured session count |
|
MinUserCount |
NUMBER |
Lowest measured number of users logged in |
|
RefID |
CHAR |
Session Groupings |
Note: The Citrix License Metrics view displays aggregate metrics across the entire data set grouped by REFID.
Citrix License Usage by Date View
|
Attribute Name |
Attribute Type |
Description |
|
AVGSessionCount |
NUMBER |
Average number of user session |
|
AvgUserCount |
NUMBER |
Average number of users logged in |
|
BusinessDay |
NUMBER |
Day of Measurement (Date) |
|
BusinessHour |
NUMBER |
Hour of Day of Measurement |
|
MaxSessionCount |
NUMBER |
Highest measured session count |
|
MaxUserCount |
NUMBER |
Highest measured users logged in |
|
MinSessionCount |
NUMBER |
Lowest measured session count |
|
MinUserCount |
NUMBER |
Lowest measured number of users logged in |
|
RefID |
CHAR |
Session Groupings |
CTX LOS Custom Check Log Data View
|
Attribute Name |
Attribute Type |
Description |
|
AlertGroupID |
NUMBER |
Identity of Group for Notification and Alerting Settings |
|
AppName |
CHAR |
Name of Application related to Simulation |
|
CheckDT |
DATETIME |
Date/Time of Simulation |
|
ComputerID |
INT |
Identity of Computer |
|
ExitCode |
NUMBER |
|
|
ID |
NUMBER |
Unique Identifier of Session |
|
LO Duration |
CHAR |
Simulation Logon Duration Metric in seconds |
|
LO Start |
CHAR |
Simulation Logon Start |
|
MonitorID |
NUMBER |
Identity of AdvandedWatch Rule Configured for the Simulation |
|
PortalName |
CHAR |
Citrix portal site |
|
ProcessID |
NUMBER |
Identity of Process related to the Simulation |
|
ProgramName |
CHAR |
Program related to the simulation |
|
ProgramStatus |
BOOLEAN |
Did the Simulation Succeed/Fail (Yes/No) |
|
SessionHost |
CHAR |
Name of Session Host Associated with Simulation |
|
UserName |
CHAR |
User Account related to the Simulation |
Citrix XenApp Session Duration View
|
Attribute Name |
Attribute Type |
Description |
|
AccountName |
CHAR |
Account Related to Session |
|
AppName |
CHAR |
|
|
AuthDuration |
NUMBER |
Authorization Duration Metric |
|
ClientName |
CHAR |
Xen App Client Name |
|
ClientValidDuration |
NUMBER |
Validation Duration Metric |
|
ClientVersion |
CHAR |
Version Number of Xen App Client |
|
ComputerID |
INT |
Identity of Computer |
|
ConnectDT |
DTIME |
Date/Time Session Connected |
|
DisconnectDT |
DTIME |
Date/Time Session Disconnected |
|
DTime |
DTIME |
Date/Time of Record was Last Updated |
|
GPODuration |
NUMBER |
Time to Initialize Group Policy Objects in seconds |
|
GroupName |
CHAR |
Computer Group Name |
|
ID |
CHAR |
Unique Identifier of Session |
|
LoadDuration |
NUMBER |
Application Load Duration Metric in seconds |
|
LogonConnectionData |
TEXT |
A String including various Session Metrics |
|
LogonDuration |
NUMBER |
User Logon Duration Metric in seconds |
|
ProfileDuration |
NUMBER |
User Profile Load Duration Metric in seconds |
|
Reconnect |
BOOLEAN |
Is Current Session a Result of a Reconnect (Yes/No) |
|
ScriptsDuration |
NUMBER |
Elapsed Time to Execute Login Scripts in seconds |
|
ServerName |
CHAR |
Name of Xen App Server |
|
SessionDuration |
NUMBER |
Length of User Session in hours |
|
SessionID |
CHAR |
Session Unique Identifier |
|
SessionName |
CHAR |
Name of Session |
|
SessionProtocol |
CHAR |
Protocol Type |
|
SessionState |
CHAR |
Idetifies Session State: Logged On, Logged Off |
|
TotalLogonDuration |
NUMBER |
Total Time for User Logon to Complete - in seconds |
|
XAServerName |
CHAR |
Xen App Server Name |
Citrix XenDesktop Session Duration View
|
Attribute Name |
Attribute Type |
Description |
|
AuthDuration |
NUMBER |
Authorization Duration Metric |
|
ClientValidDuration |
NUMBER |
Validation Duration Metric |
|
DeliveryControllerID |
NVARCHAR |
|
|
DesktopGroup |
NVARCHAR |
|
|
DesktopGroupID |
INT |
|
|
Domain |
NVARCHAR |
|
|
DTime |
DTIME |
Date/Time of Record was Last Updated |
|
GPODuration |
NUMBER |
Time to Initialize Group Policy Objects in seconds |
|
HostMachine |
VARCHAR |
|
|
LoadDuration |
NUMBER |
Application Load Duration Metric in seconds |
|
LogonDuration |
NUMBER |
User Logon Duration Metric in seconds |
|
ProfileDuration |
NUMBER |
User Profile Load Duration Metric in seconds |
|
Reconnect |
BOOLEAN |
Is Current Session a Result of a Reconnect (Yes/No) |
|
ScriptsDuration |
NUMBER |
Elapsed Time to Execute Login Scripts in seconds |
|
SessionDuration |
NUMBER |
Length of User Session in hours |
|
SessionID |
CHAR |
Session Unique Identifier |
|
SessionProtocol |
CHAR |
Protocol Type |
|
SessionState |
CHAR |
Identifies Session State: Logged On, Logged Off |
|
SessionStateChangeTime |
DATETIME |
|
| StartTime | DATETIME | |
| SummaryState | NVARCHAR | |
|
TotalLogonDuration |
NUMBER |
Total Time for User Logon to Complete - in seconds |
|
UserName |
NVARCHAR |
|
EventLog View
|
Attribute Name |
Attribute Type |
Description |
| AlertGroupID | INT | ID of the alert group |
| AlertName | NVARCHAR | Name of the monitoring rule |
| ComputerID | INT | Computer ID |
| Description | NTEXT | Event description details |
| DTime | Date/Time | Date/Time of measurement |
| EventID | INT | Event Identifier |
| GeneratedOn | Date/Time | Date/Time when event created |
| ID | BIGINT | |
| LogName | NVARCHAR | Event log name |
| MonitorDescription | NVARCHAR | |
| ServerName | NVARCHAR | Server name |
| Source | NVARCHAR | |
| Type | VARCHAR | Event Type |
| UserName | NVARCHAR | Username associated with Event |
File Check View
|
Attribute Name |
Attribute Type |
Description |
| Address | NVARCHAR | |
| AlertGroupID | INT | ID of the alert group |
| AlertName | NVARCHAR | Name of the monitoring rule |
| ComputerID | INT | Computer ID |
| DTime | Date/Time | Date/Time of measurement |
| FileCount | NVARCHAR | |
| FileDateTime | NVARCHAR | Date and Time of file |
| FileName | NVARCHAR | Name of the file |
| FileSize | NVARCHAR | Size of the file |
| MonitorDescription | NVARCHAR | |
| ServerName | NVARCHAR | Server name |
| Status | NTEXT |
Horizon LOD Reporting View (Logon Duration)
|
Attribute Name |
Attribute Type |
Description |
|
AuthDuration |
FLOAT |
Authorization Duration Metric |
|
ClientValidation |
FLOAT |
Client Validation Stage Duration |
|
ComputerID |
INT |
Identity of Computer |
|
ConnectDT |
DATETIME |
Date/Time Session Connected |
|
ConnectSecondsRemoved |
TIME |
Time Session Connected with Seconds Value Removed |
|
ConnectTime |
TIME |
Time Session Connected |
|
ConnectTimeText |
CHAR |
Text-Based Version of Time Session Connected including AM/PM |
|
DesktopName |
NVARCHAR |
|
|
DisconnectDT |
DATETIME |
Date/Time Session Disconnected |
|
DomainName |
CHAR |
Domain Related to Session |
|
DTime |
DATETIME |
Date/Time when Record was Last Updated |
|
DTime_Date |
DATE |
Date when Record was Last Updated |
|
DTime_Day |
CHAR |
Day of Week when Record was Last Updated |
|
DTime_Text |
CHAR |
Text-Based Date when Record was Last Updated |
|
GPODuration |
FLOAT |
Time to Initialize Group Policy Objects in seconds |
|
GroupName |
NVARCHAR |
|
|
HostedMachine |
NVARCHAR |
|
|
LoadDuration |
FLOAT |
Application Load Duration Metric in seconds |
|
LogonDuration |
FLOAT |
User Logon Duration Metric in seconds |
|
ProfileDuration |
FLOAT |
User Profile Load Duration Metric in seconds |
|
Reconnect |
BOOLEAN |
Is Current Session a Result of a Reconnect (Yes/No) |
|
SessionDuration |
FLOAT |
Duration of the Horizon session |
|
ScriptsDuration |
FLOAT |
Elapsed Time to Execute Login Scripts in seconds |
|
SessionID |
CHAR |
Session Unique Identifier |
|
SessionProtocol |
CHAR |
Protocol Type |
|
SessionState |
CHAR |
Identifies Session State: Logged On, Logged Off |
|
SessionType |
NVARCHAR |
|
|
UserName |
CHAR |
User Account Related to Session |
LOD Reporting View (Citrix Logon Duration)
|
Attribute Name |
Attribute Type |
Description |
|
AccountName |
CHAR |
Account Related to Session |
|
AppName |
CHAR |
Web Application Related to Session |
|
AuthDuration |
FLOAT |
Authorization Duration Metric |
|
ClientName |
CHAR |
Xen App Client Name |
|
ClientValidDuration |
FLOAT |
Validation Duration Metric |
|
ClientVersion |
CHAR |
Version Number of Xen App Client |
|
ComputerID |
INT |
Identity of Computer |
|
ConnectDT |
DATETIME |
Date/Time Session Connected |
|
ConnectSecondsRemoved |
TIME |
Time Session Connected with Seconds Value Removed |
|
ConnectTime |
TIME |
Time Session Connected |
|
ConnectTimeText |
CHAR |
Text-Based Version of Time Session Connected including AM/PM |
|
DisconnectDT |
DATETIME |
Date/Time Session Disconnected |
|
DomainName |
CHAR |
Domain Related to Session |
|
DTime |
DATETIME |
Date/Time when Record was Last Updated |
|
DTime_Date |
DATE |
Date when Record was Last Updated |
|
DTime_Day |
CHAR |
Day of Week when Record was Last Updated |
|
DTime_Text |
CHAR |
Text-Based Date when Record was Last Updated |
|
GPODuration |
FLOAT |
Time to Initialize Group Policy Objects in seconds |
|
GroupName |
CHAR |
Computer Group Name |
|
LoadDuration |
FLOAT |
Application Load Duration Metric in seconds |
|
LogonDuration |
FLOAT |
User Logon Duration Metric in seconds |
|
ProfileDuration |
FLOAT |
User Profile Load Duration Metric in seconds |
|
Reconnect |
BOOLEAN |
Is Current Session a Result of a Reconnect (Yes/No) |
|
ScriptsDuration |
FLOAT |
Elapsed Time to Execute Login Scripts in seconds |
|
ServerName |
CHAR |
Name of Xen App Server |
|
SessionID |
CHAR |
Session Unique Identifier |
|
SessionMinutes |
FLOAT |
Length of the Session in Minutes |
|
SessionName |
CHAR |
Name of Session |
|
SessionProtocol |
CHAR |
Protocol Type |
|
SessionState |
CHAR |
Identifies Session State: Logged On, Logged Off |
|
UserName |
CHAR |
User Account Related to Session |
|
XAServerName |
CHAR |
Xen App Server Name |
LOS View
|
Attribute Name |
Attribute Type |
Description |
| AlertName | NVARCHAR | Name of associated alert |
| AlertGroupID | INT | ID of the alert group |
|
ComputerID |
INT |
Identity of Computer |
|
DTime |
DTIME |
Date/Time of Measurement |
|
MiscParms |
NTEXT |
|
|
MonitorDescription |
NVARCHAR |
|
|
ProgramCLO |
NVARCHAR |
|
|
ProgramStatus |
INT |
|
|
ServerName |
NVARCHAR |
Name of the associated server |
Performance Metrics View
|
Attribute Name |
Attribute Type |
Description |
|
ComputerID |
INT |
Identity of Computer |
|
DTime |
DTIME |
Date/Time of Measurement |
|
GroupID |
CHAR |
Computer Group |
|
MiscData |
CHAR |
Packed Metrics Field - Key/Value Pairs for Performance Metrics |
|
RefID |
CHAR |
|
|
SessionCount |
NUMBER |
Number of Active Sessions Measured |
|
SessionID |
CHAR |
null |
|
Type |
CHAR |
value = XASessionUserCount (user count metrics) |
|
UserCount |
NUMBER |
Number of Active Users Measured |
|
UserID |
CHAR |
null |
|
Value |
NUMBER |
Session Count | User Count |
Process View
|
Attribute Name |
Attribute Type |
Description |
| AlertName | NVARCHAR | Name of associated alert |
| AlertGroupID | INT | ID of the alert group |
|
ComputerID |
INT |
Identity of Computer |
|
CPU |
INT |
|
|
DTime |
DTIME |
Date/Time of Measurement |
|
Memory |
INT |
|
|
MonitorDescription |
NVARCHAR |
|
|
NPPool |
INT |
|
|
PFile |
INT |
|
|
PID |
NVARCHAR |
|
|
PPool |
INT |
|
|
ProcessName |
NVARCHAR |
|
|
ServerName |
NVARCHAR |
Name of the associated server |
|
Status |
INT |
Status code |
|
UserName |
NVARCHAR |
User associated with the process |
Server View
|
Attribute Name |
Attribute Type |
Description |
| Address | NVARCHAR | |
| AlertGroupID | INT | ID of the alert group |
| AlertName | NVARCHAR | Name of the monitoring rule |
| ComputerID | INT | |
| Description | NTEXT | |
| DTime | Date/Time | Date/Time of measurement |
| MonitorDescription | NVARCHAR | |
| Notified | BIT | |
| Port | INT | |
| Reason | NTEXT | |
| ServerName | NVARCHAR | |
| Type | NVARCHAR |
SNMP Trap View
|
Attribute Name |
Attribute Type |
Description |
| AlertGroupID | INT | ID of the alert group |
| AlertName | NVARCHAR | Name of the monitoring rule |
| ComputerID | INT | |
| Description | NTEXT | |
| Device | NVARCHAR | |
| DTime | Date/Time | Date/Time of measurement |
| FromAddress | NVARCHAR | |
| ID | INT | |
| MonitorDescription | NVARCHAR | |
| Notified | BIT | |
| ObjectID | NVARCHAR | |
| ServerName | NVARCHAR |
Syslog Messages View
|
Attribute Name |
Attribute Type |
Description |
| AlertGroupID | INT | ID of the alert group |
| AlertName | NVARCHAR | Name of the monitoring rule |
| ComputerID | INT | |
| DTime | Date/Time | Date/Time of measurement |
| Facility | NVARCHAR | |
| ID | INT | |
| Message | NTEXT | |
| MonitorDescription | NVARCHAR | |
| ServerName | NVARCHAR | |
| Severity | NVARCHAR | |
| Tag | NVARCHAR |
Performance Monitoring View
|
Attribute Name |
Attribute Type |
Description |
| ComputerID | INT | |
| ComputerName | NVARCHAR | |
| DateCategory | VARCHAR | |
| DTime | Date/Time | |
| Value | Float |
Server Metrics View
|
Attribute Name |
Attribute Type |
Description |
| AgentSetupOnVM | VARCHAR | |
| AvailableDiskSpace | NVARCHAR | |
| AvailableMemory | NVARCHAR | |
| CPU | NVARCHAR | |
| ComputerID | INT | |
| DTime | Date/Time | |
| TotalDiskSpace | NVARCHAR | |
| TotalMemory | NVARCHAR |
Service View
|
Attribute Name |
Attribute Type |
Description |
| Address | NVARCHAR | |
| AlertGroupID | INT | ID of the alert group |
| AlertName | NVARCHAR | |
| ComputerID | INT | |
| DisplayName | NVARCHAR | |
| DTime | Date/Time | |
| Info | NVARCHAR | |
| MonitorDescription | NVARCHAR | |
| ServerName | NVARCHAR | |
| ServiceName | NVARCHAR | |
| StatusCode | INT |
Uptime and Availability View
|
Attribute Name |
Attribute Type |
Description |
| Address | NVARCHAR | |
| AlertGroupID | INT | ID of the alert group |
| AlertName | NVARCHAR | |
| AlertDescription | NVARCHAR | |
| ComputerID | INT | |
| Description | NTEXT | |
| DTime | Date/Time | |
| ElapsedTime | INT | |
| FrequencyDays | INT | |
| FrequencyHours | INT | |
| FrequencyMinutes | INT | |
| FrequencySeconds | INT | |
| ID | BIGINT | |
| LastDateTimeChecked | Date/Time | |
| Port | SMALLINT | |
| ServerName | NVARCHAR | |
| ServiceType | NVARCHAR | |
| StatusCode | INT | |
| TypeStr | NVARCHAR |
Util List PK View
|
Attribute Name |
Attribute Type |
Description |
| Columns | NVARCHAR | |
| PK_Name | SYSNAME | |
| Schema_Name | NVARCHAR | |
| Table_Name | SYSNAME |
Win Service View
|
Attribute Name |
Attribute Type |
Description |
| Address | NVARCHAR | |
| AlertGroupID | INT | ID of the alert group |
| AlertName | NVARCHAR | |
| ComputerID | INT | |
| DisplayName | NVARCHAR | |
| DTime | Date/Time | |
| Info | NVARCHAR | |
| MonitorDescription | NVARCHAR | |
| ServerName | NVARCHAR | |
| ServiceName | NVARCHAR | |
| StatusCode | INT |