Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >

KB-5447: Create a custom report to display users that have not configured a security question

App Access Service ,  

25 July,16 at 03:32 PM

Applies to: Centrify Identity Service

This article explains the steps needed to create a custom report in the Cloud Manager to display users that have not configured a security question

To get started, login to the cloud manager and select Reports from the top menu. On the left side of the reports page, click the "New Report" button. Give the report a name and optional description.

For additional information on creating reports, please refer to the online help section Creating a new report.

Example 1

In the report query field, copy and past the following syntax to create a report showing all users::
select UserName from User where ID not in (select UserGUID from Event where EventType = 'Cloud.Core.UserSecurityQuestionSet' and WhenOccurred >= DateFunc('now', '-999') )
Select "Preview" or simply save and run the report. It should display a list of all users that have not yet set a security question.

Example 2

In the report query field, copy and past the following syntax to create a report showing only active users:

select UserName from User
where ID not in 
 (select UserGUID from Event 
   where EventType = 'Cloud.Core.UserSecurityQuestionSet'
     and WhenOccurred >= DateFunc('now', '-999'))
and ID in
(select UserGUID from Event 
  where EventType = 'Cloud.Core.Login' 
    and WhenOccurred >= DateFunc('now', '-30')) 

If administrators wish to limit password reset mechanisms to only use the user-defined security question, you can set this in cloud policy - again from within the cloud manager. Expand the "Account Security Policies" and then "Password Reset" - de-select the options you do not wish to expose to end users.
Additional online help is available at

For additional information not covered in this guide or troubleshooting assistance, please review the
Centrify Online Help or Customer Support Portal at

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.