cancel
Showing results for 
Search instead for 
Did you mean: 
AaronThummel
Archer Employee
Archer Employee

This SQL SELECT query will bring back all the modules (applications and questionnaires) that have an advanced workflow that is currently active. It also shows some information pertaining to how records are enrolled into advanced workflow (upon creation, upon update, manual enrollment), if re-enrollment is configured, and if advanced workflow auditing is turned on and what the retention type and periods are based on.

 

Example output:

Ssms_IjKcqnRhbm.png

 

Directions:

Run the script via a user that has the permissions needed to run a SELECT query against the instance DB.

 

Change History:

3/4/2020 - Initial Release

 

This is not an official RSA supported script.
It is provided as-is.
While this script is not intended to change data, please make sure to follow your proper change management procedures and have a current backup in place.