Bulk update agents used in conditions in workflows

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Is there a way to change the "check via [AGENT_NAME]" in bulk in a Check file (or other) condition in a workflow? 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

The following can be used in the db change utility script:

REPLACE_PART JOBP, *, CONDITION_PARAMETER, "[OLD_AGENT]", "[NEW_AGENT]".

or

REPLACE JOBP, *, CONDITION_PARAMETER, "[OLD_AGENT]", "[NEW_AGENT]".

For example, in a workflow with an if condition that looks like this:

where WIN01 should be updated to WIN02 for the agent name.  The following can put in the script:

REPLACE_PART JOBP, *, CONDITION_PARAMETER, "WIN01", "WIN02".

The result when loading the transport case back into the system is:

Something to be careful with is if the agent name is in other fields in conditions within the workflow, it will update those as well.  For example, if in the example above, the Alias for "TRUE" branch set to WIN01 (for whatever reason), it would update that as well.

Using "REPLACE" and not "REPLACE_PART" with WIN01SOMETHING replaces the exact string WIN01 with nothing else around it.

Additional Information

More info on the CONDITION_PARAMETER "attribute" can be found here:  https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Utilities/admin_AboutAEDBChange.htm#link13

The CONDITION_PARAMETER change functionality was introduced with version 12.1 and is not available before that version