We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Articles in this section

See more

SQL query to list control views and control groups

Avatar
Gerard Cafaro
Follow

The SQL query below will list the following information about control views and control groups. The query can be run from the SQL console or directly against the Insight database.

  1. List of control views
  2. List of control groups
  3. Mapping of control groups to control views

 

List of Control Views

SELECT VIEWNAME, UPDATEDDATE
FROM CONTROLVIEW

 

List of Control Groups

SELECT NAME, CREATEDDATE, UPDATEDDATE
FROM CONTROLGROUP

 

Mapping of control groups to control views

SELECT VIEWNAME AS "Control View Name", NAME AS "Control Group Name"
FROM CVCGVIEW

 

 

Comments

0 comments

Please sign in to leave a comment.