Hello @Akash Chopra , Thank you for reaching.
I tried it on my end but could not fetch the Application Gateway unhealthy host count using Azure Resource Graph explorer. I am afraid fetching this data is not supported via Azure Graph Explorer.
The work arounds in this case will be to.
- Set Up Azure Monitoring for your application gateway and then you will be able to fetch Healthy host count and Unhealthy host count via the backend metrics
- You will be able to get this Unhealthy host data by running this PowerShell Command
Get-AzApplicationGatewayBackendHealth -Name "<appgtwname>" -ResourceGroupName "rgName"
but to get an unhealthy host count you will have parse this data using a custom script.
If you wish to add this as feature to Azure Graph explorer, I kindly request you to create a feedback item on our feedback portal. Thank you!
Hope this helps! Please let us know if you have any additional questions here we will gladly continue with our discussion. Thank you!