Purpose of Query
The purpose of this query is to get the contents of the DSS_HISTORY table which provides information on what has been run on the database
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
Query for CSS
SELECT * FROM DSS_HISTORY ORDER BY history_id;
Query result example
"Start the proc: DSS_FillFunctionalDate";"2016-02-12 00:09:57.023";1
"End the proc: DSS_FillFunctionalDate";"2016-02-12 00:09:57.031";2
Query result interpretation
Each row has a description of the action done, the date of the action, and the id of the action.
Query for Oracle
Enter the SQL query
Query result example
Query result interpretation
Query for SQL server
Enter the SQL query
Query result example
Query result interpretation
Notes/comments
Related Pages