Audit User Activity

In many circumstances, it is important to be able to identify changes made by a specific user or application. Log Explorer lets you track activity by SQL user ID, or even by NT Login Name.

All of the transactions applied during this demonstration are created by the same NT user. However, we have simulated multiple SQL users creating different transactions. To see all activity performed by the 'Sales' user, follow these steps:

  1. Select 'Filter Log Records' from the left-hand toolbar.
  2. Select the 'User ID' tab.
  3. Click on the 'Clear' button, then find the 'Sales' user and click on the checkbox.
  4. Click the 'Apply' button to apply the filter.
  5. Select the 'View Log' function from the left-hand toolbar.

All of the transactions shown were performed by the 'Sales' user. Remember to reset the UserID filter to 'All' when you are finished.

Note: NT Login Name features are available in Log Explorer version 2.5 and later.

Click 'Next' to continue.