Hi,
I have log messages like this:
1) ECMSELECT_SERVICE_RESPONSEReceived Tru2way Proxy Sync Response - selectService, Status: OK, Status Message: Tuning to service:
2) OCAPRESP:Tru2Way Proxy received RPC call - tuning, Status: OK, Status Message: Received service context event, Tune Status: CA_ERROR
The log 1 gets printed whenever a successful channel is being tuned. And log 2 will get printed whenever the channel tunning fails. In the log 2, CA_ERROR is one type of error similarly i have 5 or 6 log messages for different errortypes. Now I need to form a query which gives me the result such as the number of successful channel tunes, number of channel tunes failed based on the deviceId. So, basically it should display for each deviceId how many channel tunes were success and how many got failed. How to frame thee query for this?
