2013-09-20 16:53:04,723 INFO[Thread-3]EndTime=20/09/2013 16:53:04 TransactionID=A, Event=completed, Result=sent
2013-09-20 16:03:04,723 INFO[Thread-3]EndTime=20/09/2013 16:53:04 TransactionID=b, Event=completed, Result=sent
2013-09-20 13:52:04,723 INFO[Thread-3]StartTime=20/09/2013 16:52:04 TransactionID=Ab, Event=start_process
2013-09-20 09:52:04,723 INFO[Thread-3]StartTime=20/09/2013 16:52:04 TransactionID=Ab, Event=start_process
If i need to get the # of transaction every hour as belows, what would be the search statement?
Date Transaction count
2013-09-20 09 1
2013-09-20 13 1
2013-09-20 16 2
... View more