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

[OSAdmin]

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 best way to achieve it.

Thanks & Regards
Mayank

Posted by Mayanka Bhusan

Migrated from Champions

[ckattookaran]

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.