I want to write the rex command for the following regex and give it a new field where the findings will be dumped into
Call the new field "sql-tautology"
| index=webserverlogs
| regex "(?i:([\s'\"`´’‘\(\)]*?)\b([\d\w]++)([\s'\"`´’‘\(\)]*?)(?:(?:=|<=>|r?like|sounds\s+like|regexp)([\s'\"`´’‘\(\)]*?)\2\b|(?:!=|<=|>=|<>|<|>|\^|is\s+not|not\s+like|not\s+regexp)([\s'\"`´’‘\(\)]*?)(?!\2)([\d\w]+)\b))"
| rex
Hi @leagawa ,
could you share a sample of your logs?
without them it's difficoult to create a regex.
Ciao.
Giuseppe