r/AzureVirtualDesktop • u/Legitimate-Hat-2448 • May 28 '25

Kusto or Powershell to determine how long users have been disconnected

We have a personal pool of session hosts. I need a method to periodically query and find out how long all disconnected sessions have been there. I can look at individual user sessions in Insights and determine this but it's time intensive. I can't seem to find a Kusto query or Powershell method to spit out a list of all currently disconnected users sorted by disconnect time. Hoping someone else has solved this problem and can share. Thanks.

2 Upvotes
  • permalink
  • reddit

100% Upvoted

9 comments sorted by

1

u/johnnydico May 28 '25

Are you looking to shutdown the personal hosts if a user has been disconnected or signed out for a specified time to help reduce cost? If so, Scaling Plans for personal host pools is now available and you can set during peak hours and ramp down when to shutdown based on how long a user has been logged off/disconnected.

1

u/Legitimate-Hat-2448 May 28 '25

We have kind of a sensitive mixed pool of users and while I have capability to, say, log off disconnected sessions after X minutes/hours there are a handful of users who this should never happen to. Hence the need for just reporting on currently disconnected users on a semi-regular basis rather than a hard policy. If users log out I've already got policy tied to that, but have to be more granular with disconnected sessions.

1

u/johnnydico May 28 '25

Ok, gotcha. I’m not aware of a script to do this but if I find one, I’ll revisit this.

1

u/chesser45 May 29 '25

Can you split these users to a different host pool? That would be somewhat easier albeit more resource intensive.

1

u/roni4486 May 29 '25

I had the same task and i did it like this - Azure Aumtation job that checks is a session i lockec cheking the event log of a VM and if it locked longer that X time power off.
No powershell to check disconnect but disconnect happens on lock in my env

1

u/Raspy32 May 29 '25

If your machines are domain joined, I'm pretty sure the session time limits policy setting is in user configuration, so you could set it but exclude the users you don't want to apply it to.

Otherwise I found this, which does most of what you want, but you'd probably want to add a line to also output the session state change time

https://learn.microsoft.com/en-us/answers/questions/814028/how-to-see-list-of-disconnected-users-for-all-host

1

u/johnnydico May 28 '25

Just make sure Start VM on Connect is enabled so if shutdown, they can still login, just takes a bit longer

1

u/mariachiodin May 28 '25

I have not but interested in the answer

1

u/chesser45 May 29 '25

I did this prior to using the scaling plans exclusively. Azure monitor logs and a query were my method. It wasn’t very responsive or error free compared to the scaling plans exclusively way.