Where is the Action for Out of Band Access Detection stored?

[Claudio_Origin]

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

[rushikeshvartak]

Its stored in configuration table

[rushikeshvartak]

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';