Extracting User Activity log from the system Database tables
Use the following tables: Table names are “TaskActivity” and “UserLogOnActivity” Create a dashboard using grid view and export the data from Grid view. Keep in mind to use WITH (NOLOCK) for the SQL so that you are not locking these tables which you perform the SELECT Another option is to export the log using Load/Extract option and then open the XML file in EXCEL Good Luck!