Jump to content
Welcome to our new Citrix community!
  • 0

SQL query not showing expected output for users BVDI session and launch details

Sthitaprajna Rath1709161222


we are able to see the actual output details from citrix director however from monitoring database we are running below query bot its not providing the expected output result . can you please check if below query is correct which should show the actual output , 

query = SELECT MonitorData.[User].UserName, MonitorData.Session.StartDate,MonitorData.Session.EndDate, MonitorData.Connection.ClientName, MonitorData.Connection.ClientAddress, MonitorData.Machine.DnsName, MonitorData.Machine.IPAddress, MonitorData.Session.SessionKey from monitordata.Session join monitordata.[user] on monitordata.session.userid = monitordata.[user].Id join monitordata.machine on monitordata.session.MachineId = monitordata.machine.Id join monitordata.connection on monitordata.session.sessionkey = monitordata.connection.SessionKey where StartDate >=? ORDER BY StartDate DESC

Link to comment

1 answer to this question

Recommended Posts

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...