To find the count and users who have and haven't set the challenge questions for logging into OIM:

pcq is the table which we can link with usr table to get the details and pcq_key is updated whenever a user sets a Challenge question and for the three questions there will be 3 entries created in the pcq table.

            

If the user doesn't set the Challenge questions pcq_key is not populated and will be null.

Query to find the users didn't set the Challenge questions.

select * from usr, pcq where usr.usr_key=pcq.usr_key and pcq.pcq_key is null;

Note : Please check in the pcq table there shouldn't any other entires for usr_key returned from above query.

Query to find the users who set the Challenge questions.

select * from usr, pcq where usr.usr_key=pcq.usr_key and pcq.pcq_key is not null;

select count(*)/3 from usr, pcq where usr.usr_key=pcq.usr_key and pcq.pcq_key is not null;-- Usually users set the three questions and hence count/3 gives the count of users.

System property PCQ.NO_OF_QUES determines the number of questions that must be answered by the user using the web UI.By default, it is set to 3.