The following best practices can help you use TQL effectively.
Use a list and refer to it, instead of using arrays repeatedly.
Do not run regular expressions on a large set of search results. Minimize the search results first and then run regular expressions on them.
Be careful with limit 0. It removes all limitations and causes every event to be returned.
Encapsulate all string patterns with single or double quotation marks to help ensure that Helix Enterprise accurately interprets the string. For example:
connectionid="1377908085497899" "<search string pattern in rawmsg>" srcipv4:["1.1.1.1","2.2.2.2"]count>"4"eventtime>'2022-04-07T01:10:50:000Z'
Using spaces and special characters within a
rawmsgstring pattern can result in inconsistent search results. To avoid this, either encapsulate single words with quotation marks as noted above or use theANDoperator between words. For example:Use
"incapsula" AND "impreva"instead of"incapsula impreva".Use
'username' 'admin'instead of'username:admin'.
Using
:(contains) instead of=(exact match) is recommended for inexperienced users.