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

Created by user-4b453, last modified by Alex Thottunkel on Jan 02, 2023
Purpose of Query

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

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x (tick)
8.1.x (tick)
8.0.x (tick)
7.3.x (tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
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