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

ReleaseYes/No
8.3.x✅
8.2.x✅

Applicable RDBMS

RDBMSYes/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