We have a server access log with format like below. 10:30:30.269 HostID=1001, ClientConnectionStatus=Connecting,... 10:30:32.269 HostID=1004, ClientConnectionStatus=Connecting,... 10:30:33.269 HostID=1004, ClientConnectionStatus=Connected,... 10:30:50.269 HostID=1001, ClientConnectionStatus=Connecting,... 10:31:10.269 HostID=1001, ClientConnectionStatus=Connecting,... 10:31:11.269 HostID=1001, ClientConnectionStatus=Connected,... So a host is trying to connect to server and if it fails it will re-try it every 20sec (in this example, host 1001 has tried three times and eventually connected at 3rd attempt while host 1004 was able to connect by its 1st attempt). We'd like to have a search/report to count the ratio of connected/connecting attempts per HostID, for example 1001 is 1/3 and 1004 is 1 in this case. Was wondering what's the best way of constructing this? Thank you! ... View more