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.
Run the script via a user that has the permissions needed to run a SELECT query against the instance DB.
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.