KQL query for fetching vm resources in a maintenance configurations

Question

For configuring Azure update manager, I have created maintenance configuration for patching schedules where to evaluate vm resources for each configuration i was using tags to filter VMs on a scope of subscriptions i have (around 50) using Dynamic scope property in maintenance configuration. Hence doing configurations assignment to associate a schedule to a maintenance configuration.
I have a sample query with me. Can you help me with writing a correct query if this is feasible. I want to take out list VMs in each maintenance configurations.

resources
| where type == "microsoft.compute/virtualmachines"
| where subscriptionId == tolower(tostring(split(id, '/')[2]))  // Extract subscription ID from VM resource ID
| project vmName = name, vmId = id, resourceGroup, location, subscriptionId
| join kind=inner (
    maintenanceresources
    | where type == "microsoft.maintenance/configurationassignments"
    | where subscriptionId == tolower(tostring(split(id, '/')[2]))  // Extract subscription ID from maintenance configuration
    | project maintenanceConfigId = id, assignedSubscription = subscriptionId, configname=name
) on $left.subscriptionId == $right.assignedSubscription
| project vmName, vmId, resourceGroup, location, maintenanceConfigId, configname