Run below groovy script in Script console. It will output Agent name, usedID, Authentication type information for all MS-SQL server agents.
def out = new StringBuilder();
def agentService = server.get("AgentService");
def configService = server.get("ConfigService");
def agents = agentService.findByAdapterAndType("FglAM", "DB_SQL_Server");
for (agent in agents) {
def primaryASP = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
if (primaryASP) {
out.append(String.format("%s, %s: User Authentication Type=%s\n", agent.getRemoteClientId(), agent.getName(), primaryASP.getString("monUserAuthentication")));
out.append(String.format("%s, %s: User Name=%s\n", agent.getRemoteClientId(), agent.getName(), primaryASP.getString("monUserName")));
}
}
return out.toString();
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center