Saviynt Solutions

  select e.entitlement_value,h.newvalue,h.oldvalue,h.operation,h.createdon from entitlement_values_history h,entitlement_values e where e.ENTITLEMENT_VALUEKEY=h.ENTITLEMENT_VALUEKEY and h.changedField='Owner'

 SELECT distinct SUBSTRING_INDEX(AR.JBPMPROCESSINSTANCEID,'.',-1) AS 'REQUEST ID' , AR.ENDPOINTASCSV AS 'APPLICATION', (SELECT concat(FIRSTNAME,' ',LASTNAME,' (',USERNAME,')') FROM USERS WHERE RA.USERKEY=USERKEY) AS 'USER', (SELECT concat(FIRSTNAME,' ',LASTNAME,' (',USERNAME,')') FROM USERS WHERE AR.REQUESTOR=USERKEY) AS 'REQUESTOR',AR.REQUESTDATE AS 'Request Date', ev.entitlement_value as 'Entitltment Requested', ev.customproperty11, ev.customproperty12 FROM ARS_REQUESTS AR, REQUEST_ACCESS RA, entitlement_values ev WHERE AR.REQUESTKEY = RA.REQUESTKEY and ev.ENTITLEMENT_VALUEKEY=ra.ACCESSKEY   and ar.requestkey=46465

SELECT IFNULL(EV.ENTITLEMENT_VALUE, 'blank') AS 'Role Name', IFNULL(EV.DISPLAYNAME, 'blank') AS 'Role Display Name', IFNULL(EP.ENDPOINTNAME, 'blank') AS 'EndpointName', IFNULL( ( CASE WHEN EV.RISK = 0 THEN 'None' WHEN EV.RISK = 1 THEN 'Very Low' WHEN EV.RISK = 2 THEN 'Low' WHEN EV.RISK = 3 THEN 'Medium' WHEN EV.RISK = 4 THEN 'High' WHEN EV.RISK = 5 THEN 'Critical' END ), 'blank' ) AS 'Risk', IFNULL(EV.DESCRIPTION, 'blank') AS 'Description', IFNULL(U.USERNAME, 'blank') AS 'Role Owner', IFNULL(EO.RANK, 'blank') AS 'Owner Rank', IFNULL(CONCAT(U.FIRSTNAME, " ",U.LASTNAME), 'blank') AS 'Role Owner Full Name', IFNULL( ( CASE WHEN EV.STATUS = 0 THEN 'None' WHEN EV.STATUS = 1 THEN 'Active' WHEN EV.STATUS = 2 THEN 'Inactive' WHEN EV.STATUS = 3 THEN 'Decommission Active' WHEN EV.ST...

select USERKEY, UPDATEDATE, UPDATEACCOUNTTASKCREATED, UPADTEUSER, TRAIL, TICKETID, TASKTYPE, TASKKEY, TASKDATE, STATUS, STARTDATE, SOURCEID, SOURCE, SECURITYSYSTEM, SAVCONATTRS, REQUESTRULETASKCREATED, REQUESTKEY, REQUESTEDBY, REQUESTACCESSKEY, PROVISIONINGTRIES, PROVISIONINGMETADATA, PROVISIONINGCOMMENTS, PARENTTASK, OWNERTYPE, OWNERKEY, EXTERNALCONNECTION,ENTITLEMENT_VALUEKEY, ENDPOINT, ENDDATE, COMMENTS,ASSIGNEDFROMRULE, ASSIGNEDFROMROLES, ASSIGNEDFROMROLE, ACCOUNTNAME,  ACCOUNTKEY from arstasks where taskkey=126387

  alignedAccess = null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0 ruaFixed = null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0 roleOwner = 110221 rolesNotRetroFitted = rolesRetroFitted = null,null,null,null,null,null,null,null,null,null,null,null status = RetroFitJob successful out = java.io.PrintWriter@65e6d614 [alignedAccess:null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0, ruaFixed:null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0,null=0, roleOwner:110221, rolesNotRetroFitted:, rolesRetroFitted:null,null,null,null,null,null,null,null,null,null,null,null, status:RetroFitJob successful, out:java.io.PrintWriter@65e6d614]

 select connectionname     ,connectiontype,ATTRIBUTEKEY  ,ATTRIBUTEvalue          from externalconnattvalue e,externalconnection ext  where ATTRIBUTEKEY  IN (                           'URL', 'INSTANCE_URL', 'JCO_USER', 'CLIENT_ID' ) and  e.connectiontype =                       ext.externalconnectionkey limit 100 offset 0

entitlement_endpoint_list = [] manager = 84809 service_accounts_list = [] ownerOnTerminate = 84809 serviceaccount_endpoints_list = [] baseUrlForEmail = https://dev.saviyntcloud.com/ user = 137658 requestor = 137658 entitlement_value_list = [] out = java.io.PrintWriter@43c09a6e [entitlement_endpoint_list:[], manager:84809, service_accounts_list:[], ownerOnTerminate:84809, serviceaccount_endpoints_list:[], baseUrlForEmail:https://dev.saviyntcloud.com/, user:137658, requestor:137658, entitlement_value_list:[], out:java.io.PrintWriter@43c09a6e] 

  ${Map tempMap = new HashMap(); ArrayList arr = <arrayList>; if(arr.size()>0){arr.eachWithIndex{ val, idx -> {<add your logic here> tempMap.put('<key>', <value>)}; tempBuilder = new groovy.json.JsonBuilder(tempMap); return tempBuilder.toString();}else{''}}

  access_approvers access_approvers_arch access_class access_objects accessrulesexception account_attributes account_entitlement_history account_entitlements1 account_entitlements1_08152022 account_entitlements1_bcp account_entitlements1_onboarded account_entitlements1_onboarded_ol... 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 apponboardingv...

 Pending & Tasks information  SELECT   a . taskkey              AS   'TASK ID' ,         a . taskdate             AS   'TASK CREATE DATE' ,         a . updatedate           AS   'TASK UPDATE DATE' ,         CASE           WHEN   a . tasktype   =   1   THEN   'Add Access'           WHEN   a . tasktype   =   2   THEN   'Remove Access'           WHEN   a . tasktype   =   3   THEN   'NEW ACCOUNT'           W...