Posts

Showing posts from September, 2024

Email variables _ Register User

ServiceAccountOwnerMap ------- [:] entitlements ------- [] accessapprovers ------- com.saviynt.ecm.workflow.Access_Approvers : 812 jbpm_activity_name ------- Third Party Registration Approvers allApproversComments ------- null fullrowhtmltablerows ------- listofallrolesinrequest ------- [] approvedEntitlementsOwners ------- [] entitlementshtmltablerowsv2 ------- entitlementshtmltablerowsv3 ------- ServiceAccountType ------- requestlink ------- null/jbpmworkflowmanagement/showrequestdetails/TP Registration Approvals.553050?reqid=433 allRejectorsComments ------- null rolesApprovedOrRejected ------- [] rolename ------- request_access ------- com.saviynt.ecm.workflow.Request_Access : 456 users ------- XXXX allRejectors ------- [] requestid ------- 553050 rolemap ------- [:] baseUrlForEmail ------- https://dev.saviyntcloud.com/ECM assignee ------- XXXX activityname ------- Third Party Registration Approvers ServiceAccountFlag ------- false request ------- com.saviynt.ecm.workflow.ARS_Reques...

SQL - Find Duplicate Active Entitlements under Endpoint

 SELECT e.endpointname,et.entitlementname as entitlementtype,entitlement_Value, COUNT(*) as count FROM entitlement_Values ev, entitlement_types et,endpoints e WHERE ev.status = '1' and ev.entitlementtypekey=et.entitlementtypekey and et.entitlementname='saprole' and e.endpointkey=et.endpointkey GROUP BY entitlement_Value, et.entitlementname   HAVING COUNT(*) > 1;

Workflow Custom Assigment Block - Custom Query

 Requestee's manager validation select u.userkey from users u where lower(u.username) in (select owner from users where username in (select lower(raa.ATTRIBUTE_VALUE) from request_access_attrs raa , ars_requests ar, request_access ra WHERE ar.REQUESTKEY = ra.REQUESTKEY and ra.REQUEST_ACCESSKEY = raa.REQUEST_ACCESS_KEY and ar.REQUESTKEY=${ARSREQUEST.id} and raa.ATTRIBUTE_NAME='owner'))

REST _ SIMAAS Import Acount Access JSON

 {     "accountParams": {         "connection": "acctAuth",         "processingType": "SequentialAndIterative",         "call": {             "call1ABCDEFGHJKLM": {                 "callOrder": 1,                 "stageNumber": 1,                 "http": {                     "url": "https://${connection.hosturl}/scim/v2/Users?filter=active%20eq%20%22Activated%22%20and%20(identityUserID%20sw%20%22a%22%20or%20identityUserID%20sw%20%22b%22%20or%20identityUserID%20sw%20%22c%22%20or%20identityUserID%20sw%20%22d%22%20or%20identityUserID%20sw%20%22e%22%20or%20identityUserID%20sw%20%22f%22%20or%20identityUserID%20sw%20%22g%22%20or%20identityUserID%20sw%20%22h%22%20or%20identityUserID%20sw%20%22j%22%20or%20identityUserID%20s...

Workflow - Action Event

    "REQUESTOR": "rushikesh.vartak@pronoesis.com",   "REQUESTDATE": "2024-08-31 20:57:58.0",   "USER_NAME": "rushikesh.vartak@pronoesis.com",     "REQUESTID": 1542 Error 2024-08-31T16:56:36-04:00-ecm----2024-08-31T20:56:36.867179968Z stdout F org.jbpm.pvm.internal.wire.WireException: method justCall(java.util.HashMap) is not available on object vartak.rushikesh.RushikeshVartakSaviyntAuthenticationForForum@5790b6d1 (vartak.rushikesh.RushikeshVartakSaviyntAuthenticationForForum)  public static void printSpecifiedKeys(Map<String, String> map) { 2024-08-31T16:57:58-04:00-ecm----2024-08-31T20:57:58.377163915Z stdout F org.jbpm.api.JbpmException: couldn't invoke 'authenticateWithMap' with [{REQUESTOR=rushikesh.vartak@xx.com, REQUESTDATE=2024-08-31 20:57:58.0, USER_NAME=rushikesh.vartak@xx.com, CONNECTION_PARAM={CREATEACCOUNTJSON={"cn":"${user.username}","displayname":"${...

Jar

 vartak.rushikesh.RushikeshVartakSaviyntAuthentication.SaviyntApp main justCall vartak.rushikesh.RushikeshVartakSaviyntAuthentication.SaviyntEmailSender sendEmailNotification {    "DOMAIN": "xx-partner.saviyntcloud.com",    "USERNAME": "rushikesh.vartak@xx.com",    "PASSWORD": "UnVzaGlAMTIz",    "SENDEMAIL": "true",    "MAILFROM": "rushikesh.vartak@xx.com",    "MAILTO": "rushikesh.vartak@xx.com",    "MAILCC": "rushikesh.vartak@xx.com",    "MAILSUBJECTPREFIX": "Rushikesh Jar - ",    "MAILSUBJECT": "Rushikesh Jar - ",    "MAILBODY": "Rushikesh Jar - "  vartak.rushikesh.RushikeshVartakSaviyntAuthentication.SaviyntUserDetails sendUserDetailsOverEmail {    "DOMAIN": "xx-partner.saviyntcloud.com",    "USERNAME": "rushikesh.vartak@xx.com",    "PASSWORD...

REST Google Apps Import Account Access JSON

 {   "accountParams": {     "connection": "userAuth",     "processingType": "SequentialAndIterative",     "statusAndThresholdConfig": {       "statusColumn": "customproperty21",       "activeStatus": [         "false"       ],       "deleteLinks": true,       "accountThresholdValue": 100,       "correlateInactiveAccounts": true,       "inactivateAccountsNotInFile": false,       "deleteAccEntForActiveAccounts": true     },     "call": {       "call1": {         "callOrder": 0,         "stageNumber": 0,         "http": {           "url": "https://admin.googleapis.com/admin/directory/v1/users?projection=full&customer=C01cjfwbp",           "httpHeaders": {   ...

Email Binding Variables

 ${this.binding.variables.collect {RVK,RVV -> "$RVK = $RVV<br>"}} ${this.binding.variables.collect {RVK,RVV -> "$RVK: $RVV" }.join('<br>')}

EQ - Endpoint Filter Reference Key Issue

 select entitlement_valuekey as entitlement_values__Primarykey ,(select entitlement_valuekey from entitlement_values r where r.entitlementid=ev.entitlementid and r.ENTITLEMENTTYPEKEY =147) entitlement_values__REFERENCED_ENTITLEMENT from entitlement_values ev where ev.ENTITLEMENTTYPEKEY in (select et.ENTITLEMENTTYPEKEY from entitlement_types et where ENDPOINTKEY in (select ENDPOINTKEY from endpoints where PARENTENDPOINTKEY=7)) and REFERENCED_ENTITLEMENT is null and entitlementid not like '%old%' and (select entitlement_valuekey from entitlement_values r where r.entitlementid=ev.entitlementid and r.ENTITLEMENTTYPEKEY =147) != ''

SQL - Find Label Key -message_properties

 select * from message_properties where message_key like '%Revoke%' and message_locale in ('fr','fr_CA') select * from message_properties where message_value like 'ENTITLEMENTS' and message_locale in ('en')