You are right, I missed to filter again for exceptions. Please try below, you should see only correlationId exceptions that have no SUCCESS. index="mulesoft" applicationName="s-concur-api" environme...
See more...
You are right, I missed to filter again for exceptions. Please try below, you should see only correlationId exceptions that have no SUCCESS. index="mulesoft" applicationName="s-concur-api" environment=PRD
| eventstats values(tracePoint) as TracePoints values(message) as Messages by correlationId
| search TracePoints="EXCEPTION" Messages!="*(SUCCESS)*"
| fields - TracePoints - Messages
| search tracePoint="EXCEPTION"
| transaction correlationId
| rename timestamp as Timestamp correlationId as CorrelationId tracePoint as TracePoint content.ErrorType as Error content.errorType
as errorType content.errorMsg as ErrorMsg content.ErrorMsg as errorMsg
| eval ErrorType=if(isnull(Error),"Unknown",Error)
| dedup CorrelationId
| eval errorType=coalesce(Error,errorType)
| eval Errormsg=coalesce(ErrorMsg,errorMsg)
| table CorrelationId,Timestamp, applicationName, locationInfo.fileName, locationInfo.lineInFile, errorType, message,Errormsg
| sort -Timestamp