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.
- Mapping of control points to control entities
- Type of control entity (Detail, Summary, etc.)
- Retention Period - Standard and Alternate Retention
- 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
Comments
0 comments
Please sign in to leave a comment.