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.

  1. 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

  2. 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.