Forum Discussion
Update Compliance Query help
Hi, I'm trying to create a log analytics query for Update Compliance so that it only shows the latest deployment status (not the ones generated every day) for each update that is made available to my...
SteveThomas
Microsoft
MicrosoftI am not 100% sure I understand - but I think you want a count summarization, perhaps?
Maybe a query along these lines -
WaaSDeploymentStatus | where UpdateCategory == "Quality" | summarize count() by UpdateReleasedDate, DeploymentStatus, DetailedStatus | order by UpdateReleasedDate asc
Maybe a query along these lines -
WaaSDeploymentStatus | where UpdateCategory == "Quality" | summarize count() by UpdateReleasedDate, DeploymentStatus, DetailedStatus | order by UpdateReleasedDate asc