Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/15/2024 11:44 PM
Hi, we have recently started doing the Revokes of out of band accesses, so some of our endpoints now have the option of "Action for Out of Band Access Detection" set to the 2nd value of Deprovision Access and Re-Create Access Request (see attached).
My question is where in the back end tables (I have looked at the endpoints table and could not see it there) is this value stored? I ask because we want to keep track of which endpoints have this value selected.
Thanks
10/16/2024 01:20 AM
Its stored in configuration table
10/16/2024 01:34 AM
SELECT E.ENDPOINTNAME,
CASE
WHEN C.CONFIGDATA = 'DEPROV' THEN 'Deprovision Access'
WHEN C.CONFIGDATA = 'DEPROV,RECREATE' THEN
'Deprovision Access And Re-create Access Request'
ELSE 'No Action'
END AS 'Action for Out of Band Access Detection'
FROM CONFIGURATION C
JOIN ENDPOINTS E
ON Cast(SUBSTRING_INDEX(C.NAME, '_', 1) AS UNSIGNED) = E.ENDPOINTKEY
WHERE C.NAME LIKE '%_OUTOFBANDACTION';