Get Last activity time of any user.

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

I believe you will need to use the default trace to query that data. Something like this:

Select

T.path,

TE.*,

F.*

From

sys.traces T Cross Apply

::fn_trace_gettable(T.path, T.max_files) as F Left Join

sys.trace_events TE On

F.EventClass = TE.trace_event_id

Where

F.loginname = [name]