We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Articles in this section

See more

List retention period by control

Avatar
Gerard Cafaro
  • Updated
Follow

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.

mceclip0.png

Comments

0 comments

Please sign in to leave a comment.