This SQL statement is executed to get a policy state entry for
a username. It is expected to return the details of both consecutive and
cumulative counters, policy violation and current window time in the SQL
database. Special formatting characters are replaced as follows:
- %0 with the username
- %1 with the
FailurePolicyContext
parameter
value
The returned columns are used as described below. Column
numbering starts at 0:
- Current consecutive failures as column 0
- Current consecutive failure window end timestamp as column 1
- Current consecutive lock end timestamp as column 2
- Current cumulative failures as column 3
- Current cumulative failure window end timestamp as column 4
- Current cumulative lock end timestamp as column 5
There is no default and
GetQuery
is not
run.
GetQuery
supports SQL bind variables with
GetQueryParam
. See the sample configuration file
goodies/failurepolicy.cfg
for an example query. For
more information about bind variables, see
Section 3.8.1. SQL bind variables.