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 1In 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 2In 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 1In 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 2In 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.