Exporting Manage Agents List - Agent Mode

Question

Greetings,

I'm trying to export the list of all Manage Agents in my SAM so i can know which Agent is in "Server initiated communication" and which is "Agent initiated communication" I couldnt find any query nor i couldnt copy paste the data from the webpage.

does anyone knows how to do such thing?

Thanks in advance.

TalK · Accepted Answer

Hello Guys,

for those who looking for that solution the DB query is:

select * from dbo.agentManagement_agents

when the column you are looking for is "connectionType"

2 = Server Initiated

4 = Agent Initiated

good luck all.