Find specific Azure Virutal Desktop assigned user


Recently I saw a question on X (Twitter) where someone was looking for a way to filter for a specific Azure Virtual Desktop assigned user using the Azure management API. For some reason, the filter option is not working in this API. Where in the end it was not possible to find the correct user directly from an API request. In this post, I show a different, also more efficient way, to find the correct user assigned to an Azure Virtual Desktop session host.

Table Of Contents

The case

As said in the intro, we want to find a session host that is assigned to a specific user. The idea is when having the correct session host(s) a user can reboot his session host for example using self-service. Good to know, the assigned user situation is only applicable when having a Personal hostpool type.


The first attempt

The first attempt was to use the session host api as documentent here . The endpoint including the filter should be something like this:{{subscription}}/resourceGroups/{{resourceGroup}}/providers/Microsoft.DesktopVirtualization/hostpools/{{hostpool}}/sessionHosts?api-version=2022-02-10-preview&$filter=properties/assignedUser eq ''

Unfortunately, the filter is not working for some reason. Also the $select function did not work. This was the point where I found the question at X.

Solution, using the Microsoft.Resources API

Luckily, there are more ways to Rome ;), and there are more Azure Management API endpoints available to achieve that goal. An endpoint that I use often is the Microsoft.Resources/resources endpoint.

A big advantage of this endpoint is that the endpoint is Azure globally available. The means the endpoint is resource independend. So no subscriptionId, resource group or specific resourceId is needed. That means this is extremely suitable for finding resources in Azure.

Azure Resource Graph API

The Azure Microsoft.Resources API endpoint accepts a POST request with in the body a JSON content. The content consists of a Kusto Query. It is the same as the resource graph in the Azure portal. resource-graph

The body send to the endpoint looks like this. For this particular situation I search for all resources with the type microsoft.desktopvirtualization/hostpools/sessionhosts that is assigned to a specific user.

    "subscriptions": [],
    "query": "desktopvirtualizationresources | where type == \"microsoft.desktopvirtualization/hostpools/sessionhosts\" and properties.assignedUser == \"\""


For more information about the Resource Graph endpoint please check this document .

The response gives all resource information that is useable for any next step in you automation.

Using this endpoint gives you much more flexibility than specific resource API endpoint.

Thank you for reading my blog find specific azure virutal desktop assigned user.
I hope you got a bit inspired. Enjoy your day and happy automating 👋

comments powered by Disqus