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 from the GPM database out of the box:
- Citrix License Metrics View
- Citrix License Usage by Date View
- Performance Metrics View
- Citrix XenApp Session Duration View
- LODReporting View (Logon Duration)
- Citrix LOS Custom Check Log Data View
The sections below describe the data available with each view.
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 |
Performance Metrics View
Attribute Name |
Attribute Type |
Description |
ComputerID |
CHAR |
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 |
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 |
CHAR |
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 |
LOD Reporting View (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 |
NUMBER |
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 |
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 |
NUMBER |
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 |