I want join/combine two searches by their common value to compare transaction success/failure rate at both places. i tried something below, but unable to search by evaluated result
Step1: Extract substring from second log as this value exactly doesn't match within first log.
index=indexoffirstlog sourcetype="secondlog" eval length=len(fieldinterestedin) | eval transaction_id=substr(fieldinterestedin, 6, length)
Step2: Search results within first log where result contain transaction_id (Not Joined yet, just checking first log query alone)
index=indexoffsfirstlog sourcetype="firstlog" matchstringoffirstlog
Step3: Now join both searches and search by transaction_id
index=indexoffirstlog AND index=indexofsecondlog sourcetype="secondlog" matchstringoffirstlog | eval length=len(fieldinterestedin) | eval result=substr(fieldinterestedin, 6, length) | search result
But i am not getting any results. appreciate any advice.
... View more