Display user name in KQL Query

Copper Contributor

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.  

2 Replies
Just curious, did you ever figure this one out? Im running into the same issue.

@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