Viewing DDL Logs
OneData DDL logs track structural changes to physical tables in the database.
The DDL log entries screen displays the detailed DDL statement, including the result of the execution, connection details, DDL message, execution time, and the user who executed the script.
To view DDL logs
1. On the Menu toolbar, click Administer > Logs > DDL Log.
OneData displays the Filter screen on which you can search for specific DML logs.
2. Select the filters to apply:
a. In Date Range, enter a date in the From and To fields to narrow the results to logs executed between the specified dates.
b. In Objects, select the logs for one or more objects. To select multiple objects, press the Control key and click the objects to include. You must select at least one object. Objects in the production area and work or staging area may be prefixed by a corresponding code, such as PRD, for production, or STG for staging area.
c. In Statement Types, select the types of actions to include in the result. You must select at least one statement type:
All Statements: Displays DDL logs for all types of updates.
CREATE statements: Displays only DDL logs of objects with insert actions.
DROP statements: Displays only DDL logs of object with delete actions.
ALTER statements: Displays only DML logs of objects with update actions.
Note:
The filter is an and filter. If multiple criteria are selected in the filter, OneData searches for logs that meet all of the criteria specified. For example, if a date range and object are specified, the filter returns the logs that match both the criteria for the type of action (statement type).
d. Click Next.
OneData displays the DDL Log Entries screen.
Note:
The execution time always displays in YYYY-MM-DD HH24:MI:SS format, regardless of the preference set in Personalize > Preferences.
3. Use the arrows above the columns to scroll through the results. Click the column heading to change the sort order.
To export the results to Excel, click
Export to Excel. Save the file or open the file directly in Excel.
To apply a different filter, click
Change Filter.