Activity Log
The Teradata MDS Activity Log is a table in the MDS repository. When activity logging is enabled, entries to the table track user access (reads, writes, deletes) to objects in the repository. The log also indicates when access to an object is rejected because of permission conflicts. Unlike the Audit Trail, the Activity Log is not limited to only tracking changes to the DIM.
You can view the contents of the Activity Log when logged on as Administrator through MDS Repository Explorer, MetaManager, or by using SQL directly.
The Activity Log can be accessed directly through the metaactivitylog table.
Entries to the Activity Log can be viewed or deleted with Teradata MDS Repository Explorer.
Entries to the Activity Log can be deleted using bteq or SQL Assistant.
Enabling and Disabling the Activity Log
1 In the Audit and Activity Logs area of the Repository Configuration screen, enable the Activity Log by selecting the Activity Logging On check box.
To disable the Activity Log, clear the Activity Logging On check box.
2 Click Apply Changes.
Viewing Activity Log Entries
1 Logon to Repository Explorer as an MDS Administrator (for example, metasu).
2 In the Navigation Pane click Administration > Configuration Management > Activity Log.
The Activity Log area appears.
3 In the Activity Log Search area, click Show All to view all entries, or specify a search filter, and then click Search.
The search results appear. For additional information, click 
.
Deleting Activity Log Entries
1 Logon to Repository Explorer as an MDS Administrator (for example, metasu).
2 In the Navigation Pane, click Administration > Configuration Management > Activity Log.
The Activity Log area appears.
3 In the Activity Log Search area, click Show All to view all entries, or specify a search filter, and then click Search.
The search results appear.
4 Do one of the following:
Note: Clicking Delete All will permanently delete all current entries in the Activity Log.
For additional information, click .