Troublesome Query

Doherty, Adam adam.doherty at esso.ca
Fri Jun 22 18:49:39 CEST 2018


Hi all:

I'm trying to figure how to calculate the time delta between two events.
My events have a timestamp, event source, event type, and an event state and event id.

So an event looks like -
event_date_time		event_source	event_type	event_state	event_id
2018-06-22 09:05:07.000000	MODULE123	TYPEABC	ACK		24567890
2018-06-22 11:32:14.000000	MODULE123	TYPEABC	UNACK		24812266

This makes up a unique "event", start to finish.
However I have hundreds or thousands of entries between and I want be able to group them together in their unique pairings as above.

I'm not sure how to wrap my head around this one.

Adam Doherty


More information about the users-list mailing list