Identifying the Database in which Auditor is Tracking Changes

Set up Auditor to identify in which database a tracked change is being made.

In the Auditor SmartList, you would need to add the ‘Product Name’ column and create a SmartList Favorite.

  1. In the Auditor SmartList, click on the Columns button.
  2. Then, click Add.. .
  3. In the Available Columns column, click Product Name.
  4. Click OK in the Columns window.
  5. Click OK in the Change Column Display window.

To add the SmartList as a Favorite:

  1. Click the Favorites button.
  2. Give the SmartList a Name.
  3. Click Add.
  4. Select Add favorite.

The database name is tracked in the PRODNAME column in the RSAS015 table. You could also use SQL Tools to access this information.

Related Content