CVAD On-prem - How to verify if a specific ICA user session been recorded by Citrix Monitor Database
book
Article ID: CTX695367
calendar_today
Updated On:
Description
Please follow the steps to verify if a specific ICA user session been recorded by Citrix Monitor Database.
- In any Delivery Controller in the CVAD site, run the Powershell command-line to get the target session key value.
Get-Brokersession -UserName 'Domain\UserName' -MachineName 'Domain\MachineName' | Select-Object SessionKey
- In Citrix Monitor Database, run the two SQL queries and verify whether the target session key has a record in [MonitorData].[Session] table and [MonitorData].[Connection] table. If both of the queries return a row rows about the session key, it is deemed that the session has been well recorded by Monitor Database.
SELECT * FROM [MonitorData].[Session] where SessionKey = '<sessionkey>'
SELECT * FROM [MonitorData].[Connection] where SessionKey = '<sessionkey>'
Issue/Introduction
In troubleshooting Citrix Director data display issues, customers may request a verification of whether a specific ICA user session has been recorded by Citrix Monitor Database or not.
The article describes the verification steps.
Was this article helpful?
thumb_up
Yes
thumb_down
No