Query - SAV Role to Features Mapping

 SELECT sr.ROLENAME,

       sr.ROLEDESCRIPTION,
       FEATUREDISPLAYNAME,
       DESCRIPTION
FROM   SAVROLE_FEATURE sf,
       SAVROLES sr,
       FEATURE f
WHERE  sr.ROLEKEY = sf.ROLEKEY
       AND f.FEATUREID = sf.FEATUREID 


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

Advanced HQL Query Rules

  a.id IN (select ua.userkey FROM User_accounts ua WHERE ua.accountkey IN ( SELECT a.id FROM Accounts a,Account_entitlements1 ae ,Entitlement_values ev where a.endpointkey = 65 and a.status IN ('1', 'Manually Provisioned') AND ae.accountkey= a.id and ev.id= ae.entitlement_valuekey and ev.customproperty1 = '1')) Link 
Read more