How to enable the display of background processes in MySQL PI and PostgreSQL PI (4369626)

Background processes are filtered out by default in the MySQL Pi and PostgreSQL PI agents. How can the background processes by seen in the SQL statements?

Monitor the MySQL or PostgreSQL databases and and enable PI

Check the Agent Status Property parameters paecFilterDmvRequest and paecDmvCollectBackgroundProcess in the MySQL PI and PostgreSQL agent log

To see the background processes, paecFilterDmvRequest should be 0 and paecDmvCollectBackgroundProcess should be 1.
 

The following groovy script run in the Script Console can be used to display the background processes for the MySQL PI or PostgreSQL PI agent. Replace AGENTNAME with the name of the agent.

*** Foglight Cloud customers should contact Quest Support to request this functionality be enabled in their environment. 

agentService = server.get("AgentService");
configService = server.get("ConfigService");

def setAspParams(agents, aspName, aspValue) {
for (agent in agents) {
def primaryASP = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
primaryASP.setValueByString(aspName, aspValue);
configService.saveConfig(primaryASP);
}
}
def agents = agentService.findByName("AGENTNAME");
setAspParams(agents, "paecFilterDmvRequest", "false");
setAspParams(agents, "paecDmvCollectBackgroundProcess", "true");

return true;