Forum Discussion

theeley's avatar
theeley
Copper Contributor
Nov 25, 2020

Display user name in KQL Query

Hello, 

 

Running a weekly session duration query so we can check in on our VDI users.  Boss wants their actual name (AD Display Name) in this report.  For the life of me, I cannot get this report to show the user's name, just email address. 

I know Azure can show display name because I see it when I look at how many users are on each VDI server.  Any assistance in pulling the user's full name into the query would be helpful.  

azure monitor
Query Language

2 Replies

  • davinelm's avatar
    davinelm
    Copper Contributor
    Apr 29, 2022
    Just curious, did you ever figure this one out? Im running into the same issue.
    • Clive_Watson's avatar
      Clive_Watson
      Bronze Contributor
      May 09, 2022

      davinelm 

       

      If you have AAD SigninLogs you can join to that to get the data?  Simplified example 

      WVDConnections
| where State == "Connected" 
| summarize by UserName
| join (SigninLogs) on $left.UserName ==$right.UserPrincipalName
| project UserName, Identity

         

Resources