We have a need to look for wildcard matches in a string array within an ESA correlation alert.
I can get the string value to match using the syntax below, but need to get a wildcard match as we need to see matches of domains that match prior to this value.
Syntax for static match of 'maliciousdomain'. Need to get a wildcard to match anything before 'maliciousDomain'.
SELECT * FROM Event(
medium = 1
AND ('maliciousDomain' = ALL( alias_host )));