The info you want is in the historical_events table. The event name is "Connect to Data Source". You can save yourself some time by using the TS Events data source that I've shared, here:
It worked like a charm. Exactly the information I was looking for.
I choose "Access Data Source" as Event Name and did a max(event date(local)) to get the Last Referenced Date for each user. I am also trying to get Actor Friendly Name in addition to Actor User Name. Guess I am have to join _Users table to derive that.
One clarification is does this consider Users who have accessed the data source via a workbook and not directly from data source page?
Also with this TS Events, I tried to get Users List by each workbook and their Last Referenced date but at workbook level it doesn't seem to show all the list of users. Seems to give a close to accurate Users List only when looked at by view name. Do I need to do any differently to get the Users List by Each Workbook and their Last Referenced Date?
From my experience, the Access Data Source event includes both users accessing data source directly and those accessing data source because they've viewed a workbook that references the data source.
Matt has already suggested you use the 'Connect to Data Source' event.
Hi Nag. For the TS Events data source, yes, "Access View" events will only correspond to a View, not a Workbook. So to aggregate the Access View events for a given workbook, you must look at the Item Root Repository URL. For a View, this will be the "share name" of the Workbook, or the URL-friendly name that you'd see in your browser window. You could then blend that, or edit the data source and join Workbooks again to get the real name of the Workbook.