This message was deleted.
# citrix-vads
Slackbot
02/06/2020, 12:33 AMThis message was deleted.
b
Benjamin Crill
02/06/2020, 1:24 AMI’ve been able to get users connecting to a desktop session from a particular delivery group. I haven’t been able to get it to a specific desktop. Had a case where we had 3 different desktop display names against a delivery group. Tried to figure out if they were all in use. Couldn’t get it figured at the time and ultimately we bagged it because other things took priority.
h
Hal Lange
02/06/2020, 6:48 PMsame thing I am running into
Hal Lange
02/06/2020, 10:41 PMthis is the current SQL query i have working to give me the list of Desktop connections per DG... but I would like it per pub Desktop
Copy code
Select [connection].clientname,
[User].UserName,
[connection].ClientAddress,
[connection].ClientPlatform,
[Connection].ClientVersion,
DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), [Session].StartDate) as StartDate_LocalTime,
DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), [Session].EndDate) as EndDate_LocalTime,
[DesktopGroup].Name as DesktopGroup
from (((([MonitorData].[Session]
inner join [MonitorData].[User] On [MonitorData].[User].ID = [MonitorData].[Session].UserID)
inner join [MonitorData].[Connection] on [MonitorData].[Session].Sessionkey = [MonitorData].[Connection].Sessionkey)
inner join [MonitorData].[Machine] on [MonitorData].[Session].MachineID = [MonitorData].[Machine].ID)
inner join [MonitorData].[DesktopGroup] on [MonitorData].[Machine].DesktopGroupID = [MonitorData].[DesktopGroup].ID)
where ([Session].SessionType = '0') and ([connection].clientversion <> ' ') and [session].StartDate >= dateadd(day,-7,GetUTCDate()) order by usernameHal Lange
02/06/2020, 10:43 PMIt should choose everything through ICA in last 7 days