SCV SQL Previewer

Use this page to specify an SQL query statement that contains supported built-in functions.
The supported built-in function is based on the SQL Server version, and can be obtained by running this query in the SQL previewer: 
SELECT @@version as _version

You can then refer to the What are the SQL database functions section for the supported function details.

To run adhoc queries on the SCV database:

  1. Select Utilities > SCV SQL Previewer.
  2. Specify the required SQL query.
  3. Select the Application variable to use only if the query contains application variable.
    Note: You can select the default System application variable or the Application variable for a specific cycle.
  4. Click Replace Variable to update the query and display the actual value of the variables.
  5. Click Execute to CSV. The results are downloaded as a CSV file.
Note: 
  • The number of records that are exported is limited to 300 to prevent performance issues.
  • The query execution time is limited to 10 minutes.
  • When replacing application variables, the value is preceded with N. For example, %app_var_scv_dpls_base_location_hierarchy% is replaced with N'DPLS_BASE_LOCATION_HIERARCHY'.