
Hi!
Firstly, you should probably take a look at static and dynamic lists ( https://docs.logpoint.com/docs/search-query-language/en/latest/Search%20Query%20Language/Simple%20Search.html#list ) and either write something like -user IN [“aa*”,”ex*] or define the list and write -user IN USERLIST . Should make things easier.
Secondly, you can’t match against null because it actually mean the field doesn’t exist in the log so there is nothing to compare, but you should be able to do the inverse and and ensure that you only find logs where the field DOES exist by adding user=* after your -user=… query.
And lastly, you might be able to do something with the eval process command and/or rex command for a regular expression if you want to create something more complex and flexible.
2 comments