is there a Query that can tell me how many deployment I have for specific Namespace and if it ready or not.

them I want to make alert from it , so if the deployment status is not ready and lower then the amount I choose it will alert me

I managed to create this Query but It not what I want .

 KubePodInventory
| where Namespace  == 'pm8'
| where ClusterName  == 'dynamic-hermit-aks'
| summarize by  TimeGenerated , Computer , ServiceName , PodStatus