Hi All, I'm working on a search, where I currently have the following: ..base search.. | table static_name, static_time, static_title, static_owner, static_id, static_description Apart from s...
See more...
Hi All, I'm working on a search, where I currently have the following: ..base search.. | table static_name, static_time, static_title, static_owner, static_id, static_description Apart from static_title, static_time, static_id, the other fields are dynamic (they change as the search runs with different inputs. static_owner gets replaced by file_name, other fields like fqdn, process, event_hash etc get added to the search) What I'm trying to achieve is that the static values, which always are present in the search, should be shown as separate fields, while dynamic fields are merged into a new, multivalued field called Combined_Field, irrespective of the new fields showing up. They should be merged into them. | table static_time, static_owner, static_id, Combined_Field (a multivalued field, comprising the values of all the dynamic fields) ..base search.. | table static_name, static_time, static_title, static_owner, static_id, static_description | eval Combined_Field = null() | foreach * [ eval Combined_Field=if('<<field>>'==static_time OR '<<field>>'==static_owner OR '<<field>>'==static_id, '<<field>>', mvappend('<<field>>', Combined_Field)) ] | table static_time, static_owner, static_id, Combined_Field The Combined_Field always remains empty. Could anyone check and let me know as to what am I doing wrong. Or if this can be achieved via a different approach. I've always tried doing the foreach command with case instead of if, no luck. Thank you in advance, S