Run the below query from analytics to fetch the required data -select extcon.CONNECTIONNAME, extconattval.ATTRIBUTEKEY, extconattval.ATTRIBUTEVALUEfrom externalconnection extcon, externalconnattvalue extconattvalwhere extcon.EXTERNALCONNECTIONKEY = e...
Could you please check if the below query will solve the purpose?UPDATE enpointsSETcustomproperty1 = (SELECTcustomproperty1FROMendpointsWHEREendpointname = 'EndpointA')WHEREendpointname = 'EndpointB'AND (customproperty1 IS NULLOR customproperty1 = ''...
You can use the below query to fetch managers display name of the users.select u.username, m.displaynamefrom users u, users mwhere u.manager = m.userkey
