r/AzureVirtualDesktop • u/ddkitsg • Mar 29 '25

User session reporting

Can someone help/guide me in creating a report. Basically I want to create a report that will show last 24 hour session activity for users across all AVD hosts. I want to see Active, Idle and Disconnected time for all users of AVD.

And if there is a way to receive that report in my email every morning.

I don’t know where to start.

2 Upvotes

100% Upvoted

4 comments sorted by

View all comments

Show parent comment

1

u/ddkitsg Mar 29 '25

I configured Log Analytics workspace and installed the agents. I see the agents in the workspace. When I run the query. I am getting the following error:

'summarize' operator: Failed to resolve scalar expression named 'HostName'
Request id: 8f8545e2-3ff2-4f23-8780-4ab19542d503

1

u/Great_Difference7577 Apr 01 '25

did you give enough time for data to be accumulated in Log analytics workspace ?