Highlighted parts are missing. Could you please try the below condition and confirm if it's working?Your Access Request (<% if (task.entitlement_valueKey.entitlement_value.toString().startsWith("CN=nokiaenroll")) print "${task.entitlement_valueKey.en...
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
