SQL Queries - CAST Central Base - How to get the content of DSS HISTORY

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(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS(tick)
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