How to determine connector conf xml usage by endpoint.

Document ID : KB000010594
Last Modified Date : 14/02/2018
Show Technical Document Details

Customer needs to determine which connector conf xml is used by which endpoint. There is no functionality within the Enterprise Manager to do this.


The following SQL when executed against the PIM database will return all endpoints using ssh_connector_conf: 


SELECT endpoint.friendly_name FROM endpoint INNER JOIN endpoint_ld ON endpoint.UNIQUE_NAME = ENDPOINT_LD.ref_id WHERE endpoint_ld.ATTRIBUTE_VALUE = LIKE '%ssh_connector_conf%' 


You can change '%ssh_connector_conf%' to other connector xml, e.g. '%sudo_connector_conf%'