Hi, I am writing a query in Splunk dashboard and the query return in base search it has multiple joint query. still the page is loading very slow. need to improve performance of dashboard query. Th...
See more...
Hi, I am writing a query in Splunk dashboard and the query return in base search it has multiple joint query. still the page is loading very slow. need to improve performance of dashboard query. This my the query. index="Test"
applicationName="sapi" timestamp log.map.correlationId level message ("Ondemand Started*" OR "Process star
| rex field-message max_match=0 "\"Ondemand Started for. filename: (?<OnDemandFileName> [^\n]\w+\S+)"
| rex field-message max_match=0 "Process started for (?<FileName>[^\n]+)"
Ieval OnDemandFileName=rtrim(OnDemandFileName, "Job")
Ieval "FileName/JobName"= coalesce (OnDemandFileName, FileName)
| rename timestamp as Timestamp log.map.correlationId as CorrelationId level as Level message as Message
eval JobType=case (like( 'Message', "%Ondemand Started%"), "OnDemand", like('Message", "Process started%"), "Scheduled", true (), "Unknown")
eval Message=trim(Message, "\"")
table Timestamp CorrelationId Level JobType "FileName/JobName" Message
join CorrelationId type=left
[search index="Test" applicationName="sapi" level=ERROR
| rename log.map.correlationId as CorrelationId level as Level message as Messagel
I dedup CorrelationId
| table CorrelationId Level Message1]
| table Timestamp CorrelationId Level JobType "FileName/JobName" Messagel
I join CorrelationId type=left
20
[ search index="Test" applicationName="sapi" message="*file archived successfully *"
| rex field-message max_match=0 "\"Concur file archived successfully for file name: (?<Archived FileName>[^\n]\w+\S+)"
Ieval Archived FileName=rtrim(Archived FileName,"\"")
I rename log.map.correlationId as CorrelationId
| table CorrelationId ArchivedFileName]
1 table Timestamp CorrelationId Level JobType "FileName/JobName" ArchivedFileName Message1
join CorrelationId type=left
[ search index="Test" applicationName="sapi" (log.map.processor Path=ExpenseExtractProcessingtoOraclex AND (" Import*" OR "APL Import*"))
| rename timestamp as Timestamp1 log.map.correlationId as CorrelationId level as Level message as Message
| eval Status-case (like('Message", "%GL Import flow%"), "SUCCESS", like('Message", "%APL Import flow%"), "SUCCESS", like('Level', "%Exception%"), "ERROR")
| rename Message as Response
| table Timestamp1 CorrelationId Status Response]
Ieval Status=if (Level="ERROR", "ERROR", Status)
Ieval StartTime=round(strptime(Timestamp, "%Y-%m-%dT%H:%M: %S.%QZ"))
| eval EndTime=round(strptime (Timestamp1, "%Y-%m-%dT%H:%M: %S.%QZ"))
Ieval Elapsed TimeInSecs-EndTime-StartTime
| eval. "Total Elapsed Time"=strftime (Elapsed TimeInSecs, "%H:%M:%S")
eval Response= coalesce (Response, Message1)|table Status CorrelationId ArchivedFileName]
1 table Timestamp CorrelationId Level JobType "FileName/JobName" ArchivedFileName |search Status=*|stats count by JobType