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
List of Control Groups
SELECT NAME, CREATEDDATE, UPDATEDDATE
Mapping of control groups to control views
SELECT VIEWNAME AS "Control View Name", NAME AS "Control Group Name"