Thanks @patrick I looked into the report from the post briefly and am sure I must have missed some information. Thank you. If I will close this if I can get the info i need from that post.
I dont think I see the information I want there... It is a very useful post but I dont think it is solving my current crisis.
Just to reiterate my question.. I want the last time each workbook was accessed by a user (not a data connection refresh).
If you're looking for finding the last time a view was accessed, you'll be able to find it in "_views_stats" view. Join with "_workbooks" you'll be able to pull the workbook name and last accessed date with the username.
Hope this help.