I use this SPL to bring out the notes in findings. index=notable |join source_event_id [|search index=_audit source=mc_notes
| rex field=_raw "^(?<timestamp>[^,]+),(?<incident_id>[^,]+),(?<user>[^,]+),(?<model>[^,]+),(?<command>[^,]+),\"(?<json>\{.*\})\"$"
| eval json=replace(json,"\\\\\"","\"")
| spath input=json path=content output=content
| spath input=json path=author.username output=author
| spath input=json path=create_time output=create_time
| spath input=json path=notable_id output=source_event_id
| eval content=urldecode(content)|convert ctime(create_time)
| table timestamp incident_id user command author content source_event_id create_time]|table search_name rule_description user parent_process process annotations.mitre_attack content create_time entity
... View more