List of active user sessions with host details

%3CLINGO-SUB%20id%3D%22lingo-sub-1624864%22%20slang%3D%22en-US%22%3EList%20of%20active%20user%20sessions%20with%20host%20details%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1624864%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20configured%20the%20monitoring%20on%20our%20WVD%20environment%20and%20appear%20to%20be%20working%20fine.%20Thanks%20to%20the%20engineering%20team%20for%20their%20efforts%20of%20generating%20the%20workbook.%20Reference%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fwindows-it-pro-blog%2Fproactively-monitor-arm-based-windows-virtual-desktop-with-azure%2Fba-p%2F1508735%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fwindows-it-pro-blog%2Fproactively-monitor-arm-based-windows-virtual-desktop-with-azure%2Fba-p%2F1508735%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20looking%20for%20additional%20insights%20such%20as%20list%20of%20all%20the%20active%20user%20sessions%20and%20name%20of%20session%20host%20that%20they%20are%20connected%20to.%20We%20are%20sure%20that%20this%20information%20is%20populated%20already%20in%20the%20log%20analytics%20workspace%20its%20just%20that%20we%20need%20some%20assistance%20in%20deriving%20the%20correct%20log%20query.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20we%20currently%20get%20with%20the%20help%20of%20query%20below%20is%20the%20list%20of%20all%20user%20sessions%20and%20their%20session%20host%20names%20for%20last%2012%20hours%2C%20but%20it%20does%20not%20show%20information%20such%20as%20whether%20which%20user%20session%20is%20active%20or%20if%20it%20is%20connected%20from%20x%20amount%20of%20time%20or%20inactive%20from%20y%20amount%20of%20time%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-powerquery%22%3E%3CCODE%3EWVDConnections%0A%7C%20where%20State%20%3D%3D%20%22Connected%22%20and%20TimeGenerated%20%26gt%3B%20ago(12h)%20%0A%7C%20order%20by%20TimeGenerated%20desc%20%20%0A%7C%20project%20UserName%2C%20SessionHostName%2C%20TimeGenerated%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20guidance%20on%20this%20will%20be%20helpful%2C%20Thanks%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

We have configured the monitoring on our WVD environment and appear to be working fine. Thanks to the engineering team for their efforts of generating the workbook. Reference: https://techcommunity.microsoft.com/t5/windows-it-pro-blog/proactively-monitor-arm-based-windows-vir...

 

We are looking for additional insights such as list of all the active user sessions and name of session host that they are connected to. We are sure that this information is populated already in the log analytics workspace its just that we need some assistance in deriving the correct log query. 

 

What we currently get with the help of query below is the list of all user sessions and their session host names for last 12 hours, but it does not show information such as whether which user session is active or if it is connected from x amount of time or inactive from y amount of time etc. 

 

WVDConnections
| where State == "Connected" and TimeGenerated > ago(12h) 
| order by TimeGenerated desc  
| project UserName, SessionHostName, TimeGenerated

 

Any guidance on this will be helpful, Thanks in advance. 

0 Replies