1. Home
  2. Azure Log Analytics – User Connection Logs

Azure Log Analytics – User Connection Logs

Below is the query to generate a list for a defined timeframe of user connections and the duration of the connection.

// Session duration by date 
// Lists users by session duration in the last 24 hours. 
// The "State" provides information on the connection stage of an actitivity.
// The delta between "Connected" and "Completed" provides the connection time for a specific connection.
WVDConnections 
| where TimeGenerated > ago(30d) 
| where State == "Connected" 
| project CorrelationId , UserName, ConnectionType , StartTime=TimeGenerated, Date=format_datetime(TimeGenerated, 'MM-dd-yyyy')
| join (WVDConnections 
 | where State == "Completed" 
 | project EndTime=TimeGenerated, CorrelationId) 
 on CorrelationId 
| project Date, Duration = EndTime - StartTime, ConnectionType, UserName 
| sort by Date desc

Comments

  1. 218733 678971Id must verify with you here. Which isnt 1 thing I often do! I get pleasure from reading a put up that will make individuals feel. Furthermore, thanks for allowing me to comment! 151539

  2. 245693 612461It can be difficult to write about this subject. I think you did an outstanding job though! Thanks for this! 209771

  3. 926795 393199Should tow line this caravan together with van trailer home your entire family quickly get exposed towards the issues along with reversing create tight placement. awnings 294318

  4. Burada göt deliği gape Tumblr Yaşlı Porno keyfini çıkarabilir ve kızların nasıl bittiğini görebilirsin. Çeşitli
    pozlarda, fışkırtma, gırtlağa kadar sokmada çok sayıda göt deliği
    gape porno var. Bütün bunlar.