How to turn on / off the "Change Tracking" collection for SQL PI? (4231553)

Attached you will find two PDF documents which contain the needed scripts for Oracle and SQL Server agents.

There is a script to enable or disable the collection for all agents at once and another one to do it only for one single agent.

When running the script only for one specific agent, change this line :
def agentName = "MyAgentName";
Replace MyAgentName with your agent name which can be picked up from the "Agent Status" dashboard.

Also there is a script which shows the current status of the "Change Tracking" collection, were 1 = enabled and 0 = disabled.

The scripts should be executed via "Script Console":

1. Go to "Administration | Tooling | Script Console"
2. In the lower part of the dashboard select the tab "Scripts"
3. Click on the green "Add" sign and the copy the script into the script window.
4. Finally click on "Run"

If help is needed running the scripts, please contact Quest support.

DISCLAIMER:

The information in the script provided is known to work successfully; however, it has not been officially tested by Quest Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Quest Support and Development.

Quest Support and Development recommend always making a backup of the current Foglight installation and database prior to execution of any scripts that may modify it.