Attached you will find two PDF documents which contain the needed scripts for Oracle and SQL Server agents.
There is a scripts 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 "Plan Changes" collection, were 1 = enabled and 0 = disabled.
The scripts should be executed via "Script Console":
If help is needed running the scripts, please contact Quest support.
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.