kusto how to check if the complete column does not have a specific string?

user_16482415 0
Viewed 132

I have a dataset that looks like this

enter image description here

I need to find the list of servers which never went to Healthy state in past 10 days. Issue I am facing is if i write where State !contain Healthy then it its still taking server 1 and 2 as there is a record of state containing repair. So in short, how to find if the server does not have state as Healthy in the complete column?

kusto-explorer kql azure-data-explorer
1 Answers

you could try using countif():

T
| summarize c = countif(State == "Healthy") by ServerName
| where c == 0
user_78618070
Related