SOLVED

KQL query to ignore placeholders

Copper Contributor

Hi Team,

 

Can you please provide me a query to ignore account filed that has  "-\- "

 

Nimantha_Deshappriya_0-1727424964112.png

 

 

 

2 Replies
best response confirmed by Nimantha_Deshappriya (Copper Contributor)
Solution
"\" is a special character in KQL so the trick is to use two

e.g.

| where Account !="-\\-"
Thanks. It worked.
1 best response

Accepted Solutions
best response confirmed by Nimantha_Deshappriya (Copper Contributor)
Solution
"\" is a special character in KQL so the trick is to use two

e.g.

| where Account !="-\\-"

View solution in original post