Saviynt Solutions

 {   "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...

  SELECT   u . username         AS   'Entitlement_owner' ,         u . displayname ,         u . employeeclass ,         u . departmentname   AS   'DEPARTMENT' ,         CASE   u . statuskey           WHEN   1   THEN   'Active'           WHEN   0   THEN   'Inactive'         END                AS   'USERSTATUS' ,         ev . entitlement_value ,         et . entitlementname ,         ep . endpointname ,         ep . endpoin...

  UPDATE   arstasks SET      status   =   4 WHERE    at . taskdate   <=   Date ( Date_sub ( Now ( ) ,   INTERVAL   90   day ) )         AND   at . status   IN   (   1 ,   2   ) LIMIT   100 ;  

SELECT   taskkey FROM     arstasks   at WHERE    at . taskdate   <=   Date ( Date_sub ( Now ( ) ,   INTERVAL   90   day ) )         AND   at . status   IN   (   1 ,   2   ) ;  

  For anyone looking for how to do it, this is working for me as part of a User Import job attribute mapping script (i.e.  #CONST#${ ... }   ) Object log = java.util.logging.Logger.getLogger('any_name_does_not_matter'); log.info('some_message');   The log entry will look something like this: "2023-08-18T18:45:19.862+00:00","ecm-worker","","","","18-Aug-2023 18:45:18.924 INFO [quartzScheduler_Worker-15] java_util_logging_Logger$info$0.call some_message"   Hopes this help anyone needing it for troubleshooting.  It is unfortunate the logger name does not appear in the log.

  SELECT   EP . displayname                         AS   APPLICATION ,         ACC . NAME                               AS   ACCOUNTNAME ,         EV . entitlement_value                   AS   ENTITLEMENTNAME ,         U . username                             AS   USERID ,         Concat ( U . firstname ,   ' ' ,   U . lastname ) ...

SELECT   Count ( * ) FROM     ACCOUNT_ENTITLEMENTS1   AE1 ,         ACCOUNTS   A ,         ENTITLEMENT_VALUES   EV ,         ENDPOINTS   E WHERE    AE1 . ACCOUNTKEY   =   A . ACCOUNTKEY         AND   AE1 . ENTITLEMENT_VALUEKEY   =   EV . ENTITLEMENT_VALUEKEY         AND   A . ENDPOINTKEY   =   E . ENDPOINTKEY         AND   EV . CUSTOMPROPERTY30   LIKE   'True'         AND   EV . STATUS   =   1         AND   A . ACCOUNTTYPE   =   'A'         AND   A . STATUS   IN   (   1 ,   'Active' ,   'Manually Provisioned' ...

SELECT   SUBSTR ( JBPMPROCESSINSTANCEID ,   INSTR ( JBPMPROCESSINSTANCEID ,   '.' )   +   1 ,         LENGTH (                JBPMPROCESSINSTANCEID ) )   AS   requestid ,         AR . COMMENTS                      AS   requestorcomment ,         AR . REQUESTDATE                   AS   requestedon ,         AR . ENDPOINTASCSV                 AS   application ,         AR . SODEVALUATED ,         WORKFLOWNAME ...

  SELECT SUBSTR(jbpmprocessinstanceid, INSTR(jbpmprocessinstanceid, '.') + 1, LENGTH(jbpmprocessinstanceid)) REQUESTID , username AS REQUESTOR, ar.REQUESTDATE FROM ars_requests ar JOIN request_access ra ON ra.requestkey = ar.requestkey JOIN access_approvers aa ON aa.request_access_key = ra.request_accesskey JOIN users u ON u.userkey = ar.REQUESTOR WHERE aa.approverkey = 1 AND ar.status IN (1 , 2)

  SELECT   r . role_name ,         CASE   r . roletype           WHEN   5   THEN   'APPLICATION ROLE'           WHEN   4   THEN   'ENTERPRISE ROLE'           ELSE   r . roletype         END   AS   ROLE_TYPE ,         CASE   r . sox_critical           WHEN   NULL   THEN   'NONE'           WHEN   0   THEN   'NONE'           WHEN   1   THEN   'VERY LOW'           WHEN   2   THEN   'LOW'          ...