Posts

Showing posts from November, 2023

Connector - DB Remove Special Character

  escapeSql(String str)  

Enhanced Query Execution

UPDATE SELECT  'Active' AS Accounts__status , a.accountkey as  accounts__PRIMARYKEY FROM accounts a where a.accountkey=72 INSERT SELECT 'NEWCUSTOMERTEST500' AS customer__customername,'International Development' AS customer__description,'543256' AS customer__customproperty1,'543256 International Development' AS customer__customproperty2,'StarHR' AS customer__customproperty3,'Imported' AS customer__customproperty4,'BU56.5.4.00003444.543256' customer__customproperty5,'Global Business Support' AS customer__customproperty7,'1' AS customer__parentcustomer,SYSDATE() AS customer__CREATEDATE,1 AS customer__RISK,1 as customer__SCORE,1 AS customer__STATUS,SYSDATE() AS customer__UPDATEDATE,'2024-01-01' AS customer__ENDDATE FROM customer select 2095 AS accountowners__OWNERUSERGROUPKEY,ACCOUNTOWNERKEY as accountowners__PRIMARYKEY,1 AS accountowners__RANK, 'sysdate()' AS accountowners__UPDATEDATE , 1 AS ac...

Connector - REST - Escape Special Characters

  ${org.apache.commons.lang.StringEscapeUtils.escapeJava(reqAttrs.customproperty10)}

Email Variables - Report Email

  date = 2023-11-23 02:29:32 endpoint = null totalRecords = 14 analyticsConfig = com.saviynt.ecm.analytics.AnalyticsConfigES : 1570 endpointDisplayName = null baseUrlForEmail = https://-dev.saviyntcloud.com/ ownerEmail = out = java.io.PrintWriter@135a96e3 [date:2023-11-23 02:29:32, endpoint:null, totalRecords:14, analyticsConfig:com.saviynt.ecm.analytics.AnalyticsConfigES : 1570, endpointDisplayName:null, baseUrlForEmail:https://-dev.saviyntcloud.com/, ownerEmail:, out:java.io.PrintWriter@135a96e3] 

Email Variables - Task completion Disconnected Revoke Access

  ApprovedEntitlementWithBJ = RejectEntitlement = randompassword = null out = java.io.PrintWriter@63184313 password = requesttype = Remove accountname = Rushikesh.Vartak@.com ApprovedEntitlement = endpointDisplayName = Costar account_name = Rushikesh.Vartak@com requestormanager = 84809 RejectEntitlementWithBJ = tasks = com.saviynt.ecm.task.ArsTasks : 99424 endpoints = Costar tasktype = Modify Account manager = 84809 rolename = entitlement = [Financial Reporting] requestor = 137658 users = 137658 account_password = Welcome123 task = com.saviynt.ecm.task.ArsTasks : 99424 requestid = 4310001 baseUrlForEmail = https://release-n-plus-one.saviyntcloud.com/ECM user = 137658 taskaction = Modify Account account = Rushikesh.Vartak@.com

Email Variables Task Completion -Disconnected Application Add Access

  Non-Vehicle Portfolio ApprovedEntitlementWithBJ = RejectEntitlement = randompassword = null out = java.io.PrintWriter@6437bab1 password = requesttype = Add accountname = Rushikesh.Vartak@.com ApprovedEntitlement = endpointDisplayName = Costar account_name = Rushikesh.Vartak@.com requestormanager = 84809 RejectEntitlementWithBJ = tasks = com.saviynt.ecm.task.ArsTasks : 99417 endpoints = Costar tasktype = Modify Account manager = 84809 rolename = entitlement = [Non-Vehicle Portfolio] requestor = 137658 users = 137658 account_password = Welcome123 task = com.saviynt.ecm.task.ArsTasks : 99417 requestid = 4300001 baseUrlForEmail = https://release-n-plus-one.saviyntcloud.com/ECM user = 137658 taskaction = Modify Account account = Rushikesh.Vartak@.com

REST Connector Variables

 Create Account JSON REST/Azure AD ${task?.requestAccessKey?.collect{ it.request_access_attrss.findAll{it.attributeName.toString().equalsIgnoreCase(' SomeValue ')}?.collect{it.attributeValue}}?.get(0)?.get(0)} SomeValue is the Dynamic Attribute Name

Email Variables - Update Role Request Template

  Update Role Request Template Email template to be used when a role is updated manager = 3778 roles = Azure-Office365-Contributor-Rushi1 baseUrlForEmail = https://dev.saviyntcloud.com/ user = 109655 users = 109655 out = java.io.PrintWriter@35e31974 [manager:3778, roles:Azure-Office365-Contributor-Rushi1, baseUrlForEmail:https://dev.saviyntcloud.com/, user:109655, users:109655, out:java.io.PrintWriter@35e31974] 

Email variables - Role Owner Removal Template

  Global config  Role Owner Removal Template Email template to be used when a role owner is removed owner = 109655 ownerrank = roles = Azure-Office365-Contributor-Rushi1 ownermanager = 3778 out = java.io.PrintWriter@20e5d9dd [owner:109655, ownerrank:, roles:Azure-Office365-Contributor-Rushi1, ownermanager:3778, out:java.io.PrintWriter@20e5d9dd] ]

Email Variables - Role Owner Assignment Template

Global config  Role Owner Assignment Template Email template to be used when a role owner is assigned 109655 is owner selected. owner = 109655 ownerrank = 1 roles = Azure-Office365-Contributor-Rushi1 ownermanager = 3778 out = java.io.PrintWriter@4fb0581c [owner:109655, ownerrank:1, roles:Azure-Office365-Contributor-Rushi1, ownermanager:3778, out:java.io.PrintWriter@4fb0581c] 

Database Tables

  access_approvers access_approvers_arch access_class access_objects accessrulesexception account_attributes account_entitlement_history account_entitlements1 account_entitlements1_bcp account_entitlements_privilege account_entitlements_rollback account_role_saviyntrfc accountowners accounts accounts_bcp accounts_owners accountsloadfromacl analyticconflictaccept analytics_analyticshistory analytics_history_report analytics_history_report_backup analyticsconfig analyticsconfig_attributes analyticsconfig_clean analyticsconfig_history analyticsconfiges analyticsconfiges_analyticsconfig_... analyticsconfiges_attributes analyticsconfiges_history analyticses_analyticshistory analyticshistory analyticshistoryes answer ao_metadata_action appdataarchive applicationonboarding applicationonboarding_history applicationtype applicense apponboardingquestionaire apponboardingsection apponboardingvalidation ars_requests ars_requests_arch arsrequest_attachments arstasks arstasks_arch arstasks_exec ...