SQL query to list control points

The SQL query below will list the following information about control points. The query can be run from the SQL console or directly against the Assure database.

1. Mapping of control points to control entities
2. Type of control entity (Detail, Summary, etc.)
3. Retention Period - Standard and Alternate Retention
4. Enabled - whether a control point is active or disabled

SELECT PROCESSGROUP.NAME AS "Control Entity", PROCESSDEFINITION.DISPLAYNAME AS "Control Point", PROCESSTYPE.DESCRIPTION AS "Control Entity Type", PROCESSDEFINITION.ENABLED, PROCESSGROUP.RETAINDAYS, PROCESSGROUP.RETAINMONTHS, PROCESSGROUP.RETAINYEARS, PROCESSGROUP.ALT_RETAINDAYS, PROCESSGROUP.ALT_RETAINMONTHS, PROCESSGROUP.ALT_RETAINYEARS
FROM PROCESSDEFINITION INNER JOIN PROCESSGROUP ON PROCESSGROUPFK=PROCESSGROUPPK INNER JOIN PROCESSTYPE ON PROCESS_TYPE_FK=PROCESSTYPEPK
WHERE PROCESSGROUPPK>1