Posts

Showing posts from February, 2025

statusAndThresholdConfig

 {   "statusAndThresholdConfig": {     "accountThresholdValue": 100,     "deleteLinks": true,     "correlateInactiveAccounts": true,     "inactivateAccountsNotInFile": false,     "inactivateEntsNotInFeed": true,     "entThresholdValue": {       "entType": {         "Group": {           "ent": 100         },         "Account_Permission_Set": {           "ent": 100         }       }     }   } }

SQL - Connection table

 select EXTERNALCONNECTIONKEY,CONNECTIONDESCRIPTION,CONNECTIONNAME,CONNECTORMS,CREATEDBY,CREATEDON,CREDENTIALCHANGECONFIG,EMAILTEMPLATE,EXTERNALCONNECTIONTYPE,MSCONNECTORVERSION,NODE_MAC_ID,SSLCERTIFICATE,STATUS s,STATUSFORENABLEDISABLE,TEMPLATE_MANDATORYDATA,TEMPLATENAME,UPDATEDBY,UPDATEDON,VAULTCONFIG,VAULTCREDENTIALCONNECTION,CONNECTORTYPE  from externalconnection  SELECT   eh . connectionname ,         CASE           WHEN   eh . operation   =   'Remove'                AND   (   eh . newvalue   IS   NULL                       OR   eh . newvalue   =   ''   )   THEN   'ROLE_ADMIN'           ELSE   Conca...