Idira Identity: Create a custom report to display users that have not configured a security question

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

Workforce Identity Articles
4 min read
L0 Member
No ratings
This article explains the steps needed to create a custom report in the Admin Portal to display users that have not configured a security question

Issue

To get started, login to the Admin Portal 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 Admin Portal. Expand the "Account Security Policies" and then "Password Reset". De-select the options you do not wish to expose to end users.
 


For additional information not covered in this guide or troubleshooting assistance, please review Idira Identity Online Documentation.
 

Steps

To get started, login to the Admin Portal 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 Admin Portal. Expand the "Account Security Policies" and then "Password Reset". De-select the options you do not wish to expose to end users.
 


For additional information not covered in this guide or troubleshooting assistance, please review Idira Identity Online Documentation. This article explains the steps needed to create a custom report in the Admin Portal to display users that have not configured a security question


To get started, login to the Admin Portal 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 Admin Portal. Expand the "Account Security Policies" and then "Password Reset". De-select the options you do not wish to expose to end users.
 


For additional information not covered in this guide or troubleshooting assistance, please review Idira Identity Online Documentation.
 
Rate this article: