Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
3 years ago

Extracting system log IE: user activity and Task Activity from system Database table

Hi All, We are exploring an option to extract the system log from System database table. Table names are “TaskActivity” and “UserLogOnActivity”. If any one of you can guide me, what would be the be...
Reports
ckattookaran's avatar
ckattookaran
VIP
3 years ago

Mayank, you could create a dashboard using grid view and export the data from Grid view.
Or you could write a rule to do that.
Whichever approach you go with keep in mind to use WITH (NOLOCK) for the SQL so that you are not locking these tables which you perform the SELECT.

Other option is to export them using Load/Extract and then open the XML file in EXCEL. I did write a blog post using this approach.