I'm working with Windows events, and want to make following report/search: process1 Total XX XX% command_line1 XX% command_line2 XX% … process4 Total XX XX% command_line1 XX% command_line2 XX% What I come up with: `index_windows` EventCode=4688
| fields Process_Command_Line, New_Process_Name
| stats count(Process_Command_Line) as totalCount by New_Process_Name, Process_Command_Line
| eventstats sum(totalCount) as _total
| eventstats sum(totalCount) as _totalPerProcess by New_Process_Name
| eval percentageTotal=round((totalCount/_total)*100,2)
| eval precentagePerProcess=round((totalCount/_totalPerProcess)*100,2)
| sort - totalCount The only thing is that I can't figure out how to merge fields by New_Process_Name
... View more