Hello
I'm interested in finding the outages for my business service. Here is how it works:
I have a log file that logs the request / response for a web service. These request / response messages have a field called correlationID
I have already correlated the request / response by the correlation ID (via stats)
Based on this correlation, I derive a field called "status" as follows:
If the response contains the word "Tech Exception", status="Technical Exception"
If the response contains the word successful, status="Successful"
Here is how my stats output table looks:
What I would like to get is:
- Every 2 consecutive "Technical Exceptions" is the start of an outage.
- The outage ends only after the status becomes Successful
I would like to calculate the outages for my service.
Could someone please help me derive a search for this problem?
Thanks for your time.
Regards
Sathish
... View more