Create visualization based on runtime

[rgjnnc]

Hi ,

I want to create visualization based on process run time log field is "TotalExecutionTimeInSeconds":4129. I have to create chart based on this value. Please help me.

[to4kawa]

your search
| rex "(?<json>{.*)"
| spath input=json
| timechart avg(TotalExecutionTimeInSeconds) as RunTime by processName

[richgalloway]

More information would be helpful, but you can start with ... | timechart avg(TotalExecutionTimeInSeconds) as RunTime by processName.

[rgjnnc]

Hi Thanks for reply

My logs looks as below.

06:07:14.9408 Info {"message":"Fin_EDI_Invoice_Processing_16A_PRODUCTION execution ended","level":"Information","logType":"Default","timeStamp":"2020-02-18T06:07:14.9408136-06:00","fingerprint":"f9308a3f-8b47-48fc-83b6-56c84eb434c3","windowsIdentity":"POLARISIND\svcrpa01","machineName":"VPCRPAPRDBOT1","processName":"Fin_EDI_Invoice_Processing_16A_PRODUCTION","processVersion":"1.0.7342.7934","jobId":"01ac06d8-fdf9-4961-93eb-6b9ccb38b98d","robotName":"Prod Bot 1","machineId":1,"totalExecutionTimeInSeconds":4929,"totalExecutionTime":"01:22:09","fileName":"Main"}

I want create vissualization based totalExecutionTimeInSeconds for diffrent runs of this process.