The following SQL can be run through your SQL Console to list all control entity's retention periods:
select "NAME", "RETAINYEARS", "RETAINMONTHS", "RETAINDAYS", "ALT_RETAINYEARS", "ALT_RETAINMONTHS", "ALT_RETAINDAYS" from "PROCESSGROUP" order by "NAME"
Note that retention is defined at the Control Entity level, which is why Control Points aren't included in the results. Each name in the result refers to a Control Entity.
Comments
0 comments
Please sign in to leave a comment.