mikaelsnavy of CaseTrakker Dynamo Snips
11/18/2015 - 4:59 PM

Get activity for a session on the database for a certain session

Get activity for a session on the database for a certain session

SELECT
	event_type, summary, details, start_time, client_start_time, client_end_time, client_total_time, end_time, total_time, total_database_calls, total_rows_retreived
FROM
	e_event_entry WITH (NOLOCK)
WHERE
	session_id = 'D5536E2A-0E8E-4FA5-A636-C9DA4262CA67'
	AND start_time > '20151020 11:50:00'
ORDER BY
	start_time