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 accountowners__UPDATEUSER from  accountowners where ACCOUNTKEY=2


SELECT  'Blackpoint' AS securitysystems__SYSTEMNAME, 'Blackpoint' as securitysystems__DISPLAYNAME,5 as securitysystems__PRIMARYKEY FROM securitysystems where systemname='Blackline' limit 1; 


select accentkey as account_entitlements1__primarykey,now() as account_entitlements1__enddate from account_entitlements1 where accentkey=262

select datasetkey as dataset__primarykey,concat(ATTRIBUTECONFIG,',AUDIT') as dataset__ATTRIBUTECONFIG from dataset where datasetname='EVICORE_INNOVATE_AD_OU_MAPPING'


Comments

Post a Comment

Popular posts from this blog

Enhanced Query - To Update Account Status and Name

select accountkey as accounts__primarykey, 'SUSPENDED FROM IMPORT SERVICE' as accounts__status, CONCAT(name,'-Deleted on-', DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s'))as accounts__name from accounts where endpointkey=527 and name='CN=INRVCH,OU=User Accounts Vista,OU=User Accounts,OU=User Directory,DC=asia-pac,DC=xx,DC=com'  and status not in ('SUSPENDED FROM IMPORT SERVICE') limit 1;
Read more

Connection Config - STATUS_THRESHOLD_CONFIG

 {   "statusAndThresholdConfig": {    "inactivateAccountsNotInFile": true    "statusColumn":"userlock",    "activeStatus":["0","128","192"],     "accountThresholdValue": 500,     "deleteLinks": false,     "correlateInactiveAccounts": true,        } } ----------------------------------------------------------------------------- When account import run above STATUS_THRESHOLD_CONFIG is used to check. ----------------------------------- inactivateAccountsNotInFile  ==> True/false true ---> Account status 1/2 ( Active/Inactive) Day 1 --> 100 Accounts import Day 2 --> 90 Diff= 10  ( 90= Active , 10 Inactive)  ------------------------------------------------------------------------------ ----------------------------------- inactivateAccountsNotInFile  ==> True/false false ---> Account status 1/SFIS ( Active/SUSPENDED FROM IMPORT SERVICE.) Day 1 --> 100 Ac...
Read more

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...
Read more