How to determine connector conf xml usage by endpoint.

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

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

Instructions:

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%'