SQL Queries - CAST Management Base - How to get the path of the delivery and deploy folders

Purpose of Query

This query will give you the path of the delivery folder and the deploy folder.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS2✅

Query for CSS

SELECT serverpath as "DELIVERY FOLDER",
       deploypath as "DEPLOY FOLDER"
       FROM <MANAGEMENT DATABASE>.cms_pref_sources;

The result is :

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