How to obtain from the TSPS database a list of PATROL Agents that have a specific infrastructure policy applied ?
Please follow below steps to get list of PATROL Agents where specific infrastructure policy is applied.
- From a command prompt, cd to <installdir>\truesightpserver\modules\pgsql\bin and execute below command to connect TSPS database.
psql -d truesight -U <TSPS_DATBASE_USER>
Please provide database user name in place of <TSPS_DATBASE_USER>
For Example: psql -d truesight -U postgres
- Once it is connected, please execute query:
select hostname,patrolagentport from patrolagent_details where policiesapplied like '%<POLICY_NAME>%';
Please provide policyname in place of <POLICY_NAME>