Hi team,

Please help me write a KQL query which reflects the devices which are missing windows security patches, the condition i want to apply here is, i need the device’s sensor health=”Active” and Onboarding status=”Onboarded”.
right now i am using ” 

“
Please help me out!
Thanks in advance! 🙂

​Hi team,Please help me write a KQL query which reflects the devices which are missing windows security patches, the condition i want to apply here is, i need the device’s sensor health=”Active” and Onboarding status=”Onboarded”.right now i am using ” DeviceTvmSoftwareVulnerabilities  | where RecommendedSecurityUpdate endswith “August 2024 security updates”| where DeviceName contains “xyz”| summarize by DeviceId, DeviceName, RecommendedSecurityUpdate, OSPlatform”Please help me out!Thanks in advance! 🙂  Read More

​