Is there a way to change the user/password for many database agents?
RESOLUTION 1 (for a single agent)
From Foglight web console, navigate to the "Databases" dashboard.
To change the OS credential:
To change the Database credential:
Refer to Knowledge base article 4308764 for more details on this resolution.
RESOLUTION 3 (for multiple agents)
From Foglight web console, navigate to the "Databases" dashboard.
Refer to knowledgebase article 4228645 for more details on this resolution.
RESOLUTION 4 (for all SQL Server Agents on a Foglight Management Server)
Review KB 4309796 on how to run a groovy script in the FMS script console.
NOTE: This resolution will only update the password for SQL Server database agent monitoring and will not update the OS credentials used by either the Windows or SQL Server agents.
def agentService = server.get("AgentService");
def configService = server.get("ConfigService");
def currentDBUser = ""; // or \\
def currentDBPassword = "";
def newDBPassword = "";
def out = new StringBuilder();
def agents = agentService.findByAdapterAndType("FglAM", "DB_SQL_Server");
for (agent in agents) {
def primaryAsp = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
def authenticationTypeASPValue = primaryAsp.getString("monUserAuthentication");
if (!authenticationTypeASPValue.equalsIgnoreCase("Windows_Default_Account")) {
def dbUserASPValue = primaryAsp.getString("monUserName");
def dbPasswordASPValue = primaryAsp.getString("monPassword");
if (dbUserASPValue.equalsIgnoreCase(currentDBUser) && dbPasswordASPValue.equalsIgnoreCase(currentDBPassword)) {
out.append(String.format("Changing agent %s DB password\n", agent.getName()));
primaryAsp.setValueByString("monPassword", newDBPassword);
configService.saveConfig(primaryAsp);
}
}
}
return out.toString();
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center