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.
- List of control views
- List of control groups
- 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.