How to programmatically list all PATROL Agents connected to a specific TrueSight Integration Server 10.x, 11.x

Manage Support IDs

Use checkboxes to 'Remove support IDs/Users' or 'Allow to create Cases'
Support IDs for BMC Customer Support Site Guest User
Profiles Which Include    Back to All Support IDs
 

Knowledge Article

How to programmatically list all PATROL Agents connected to a specific TrueSight Integration Server 10.x, 11.x
How to programmatically list all PATROL Agents connected to a specified TrueSight Integration Server 10.x, 11.x
TrueSight Presentation Server
TSIM Integration Service
TSIM Integration Server 10.x - 11.x
TrueSight Presentation Server
TSIM Integration Service
TSIM Integration Server 10.x - 11.x
How to list all PATROL Agents connected to each TrueSight Integration Server 10.x, 11.x
In order to view the PATROL Agents connected to the Integration Servers in TSIM,  please login to the TrueSight Presentation Server (TSPS) machine.

1) Connect to the TSPS PostGres database from - InstallationDirectory\TrueSightPServer\truesightpserver\modules\pgsql\bin\pgAdmin3>
2) Connect to database >> tables >> usergroup
3) Run the following sql query:

select patrolagent_details.hostname from patrolagent_details where proxyid=(select proxyid from proxy_details where proxyhostname LIKE 'xyz.bmc.com')

Here xyz.bmc.com is the name of the Integration Server, please replace the server name with your Integration Server name
TrueSight Presentation Server
TSIM Integration Service
TSIM Integration Server 10.x - 11.x
Attachment(s):