Sep 22 2021 05:37 AM
How can we whitelist combination of columns using KQL. For Eg. I want to create exclusion like below:
| where column1 !contains "abc" and column2 !contains "qwe" and column3 !contains "xyz"
while this looks pretty straight forward but my observation is that it does not make exclusion based on above 3 combination of criteria.
Seems like I'm missing something very basic but not able to identify what.
Sep 22 2021 06:18 AM
@jainshamu You can always use multiple lines.
| where column1 !contains "abc"
| where column2 !contains "qwe"
| where column3 !comtains "xyz"
Sep 22 2021 07:14 AM
I would have expected the original query to work, similar example I use (slightly modified).
Usage
| where tostring(IsBillable) !contains "false" and
DataType !in("Operation", "Usage") and
DataType !startswith "VM" and
Solution !contains "Log"
| summarize by DataType, Solution, IsBillable
Sep 22 2021 08:21 AM - edited Sep 22 2021 08:26 AM
@CliveWatson Out of curiosity, Is there any benefit to using one way over the other? Is one faster than the other?
Sep 27 2021 11:09 PM