<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article Idira Identity: Create a custom report to display users that have not configured a security question in Workforce Identity Articles</title>
    <link>https://live.paloaltonetworks.com/t5/workforce-identity-articles/idira-identity-create-a-custom-report-to-display-users-that-have/ta-p/1428010</link>
    <description>This article explains the steps needed to create a custom report in the Admin Portal to display users that&amp;nbsp;have not configured a security question

&lt;H3&gt;Issue&lt;/H3&gt;
To get started, login to the Admin Portal and select Reports from the top menu. On the left side of the reports&amp;nbsp;page, click the "New Report" button. Give the report a name and optional description.&lt;BR /&gt;&lt;BR /&gt;For additional information on creating reports, please refer to the online help section "Creating a new report".&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;U&gt;&lt;B&gt;Example 1&lt;/B&gt;&lt;/U&gt;&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax&amp;nbsp;to create a report showing all users::&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;select UserName from User where ID not in (select UserGUID from Event where EventType = 'Cloud.Core.UserSecurityQuestionSet' and WhenOccurred &amp;gt;= DateFunc('now', '-999') )&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;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.&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;U&gt;&lt;B&gt;Example 2&lt;/B&gt;&lt;/U&gt;&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax to create a report showing only active users:&lt;BR /&gt;&lt;BR /&gt;select UserName from User&lt;BR /&gt;where ID not in&amp;nbsp;&lt;BR /&gt;&amp;nbsp;(select UserGUID from Event&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.UserSecurityQuestionSet'&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; and WhenOccurred &amp;gt;= DateFunc('now', '-999'))&lt;BR /&gt;and ID in&lt;BR /&gt;(select UserGUID from Event&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.Login'&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;and WhenOccurred &amp;gt;= DateFunc('now', '-30'))&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;If administrators wish to limit password reset mechanisms to only use the user-defined security question, you can set this&amp;nbsp;in cloud policy - again from within the Admin Portal. Expand the "Account Security Policies" and then "Password&amp;nbsp;Reset". De-select the options you do not wish to expose to end users.&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;For additional information not covered in this guide or troubleshooting assistance, please review Idira Identity Online Documentation.&lt;BR /&gt;&amp;nbsp;

&lt;H3&gt;Steps&lt;/H3&gt;
To get started, login to the Admin Portal and select Reports from the top menu. On the left side of the reports&amp;nbsp;page, click the "New Report" button. Give the report a name and optional description.&lt;BR /&gt;&lt;BR /&gt;For additional information on creating reports, please refer to the online help section "Creating a new report".&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;Example 1&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax&amp;nbsp;to create a report showing all users::
&lt;PRE class="ckeditor_codeblock"&gt;
select UserName from User where ID not in (select UserGUID from Event where EventType = 'Cloud.Core.UserSecurityQuestionSet' and WhenOccurred &amp;gt;= DateFunc('now', '-999') )
&lt;/PRE&gt;
&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;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.&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;Example 2&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax to create a report showing only active users:
&lt;PRE class="ckeditor_codeblock"&gt;
select UserName from User
where ID not in&amp;nbsp;
&amp;nbsp;(select UserGUID from Event&amp;nbsp;
&amp;nbsp;&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.UserSecurityQuestionSet'
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; and WhenOccurred &amp;gt;= DateFunc('now', '-999'))
and ID in
(select UserGUID from Event&amp;nbsp;
&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.Login'&amp;nbsp;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;and WhenOccurred &amp;gt;= DateFunc('now', '-30'))&amp;nbsp;&lt;/PRE&gt;
&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;If administrators wish to limit password reset mechanisms to only use the user-defined security question, you can set this&amp;nbsp;in cloud policy - again from within the Admin Portal. Expand the "Account Security Policies" and then "Password&amp;nbsp;Reset". De-select the options you do not wish to expose to end users.&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;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&amp;nbsp;have not configured a security question&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;To get started, login to the Admin Portal and select Reports from the top menu. On the left side of the reports&amp;nbsp;page, click the "New Report" button. Give the report a name and optional description.&lt;BR /&gt;&lt;BR /&gt;For additional information on creating reports, please refer to the online help section "Creating a new report".&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;U&gt;&lt;B&gt;Example 1&lt;/B&gt;&lt;/U&gt;&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax&amp;nbsp;to create a report showing all users::&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;select UserName from User where ID not in (select UserGUID from Event where EventType = 'Cloud.Core.UserSecurityQuestionSet' and WhenOccurred &amp;gt;= DateFunc('now', '-999') )&lt;/SPAN&gt;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;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.&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;U&gt;&lt;B&gt;Example 2&lt;/B&gt;&lt;/U&gt;&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax to create a report showing only active users:&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;select UserName from User&lt;BR /&gt;where ID not in&amp;nbsp;&lt;BR /&gt;&amp;nbsp;(select UserGUID from Event&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.UserSecurityQuestionSet'&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; and WhenOccurred &amp;gt;= DateFunc('now', '-999'))&lt;BR /&gt;and ID in&lt;BR /&gt;(select UserGUID from Event&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.Login'&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;and WhenOccurred &amp;gt;= DateFunc('now', '-30'))&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;If administrators wish to limit password reset mechanisms to only use the user-defined security question, you can set this&amp;nbsp;in cloud policy - again from within the Admin Portal. Expand the "Account Security Policies" and then "Password&amp;nbsp;Reset". De-select the options you do not wish to expose to end users.&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;For additional information not covered in this guide or troubleshooting assistance, please review Idira Identity Online Documentation.&lt;BR /&gt;&amp;nbsp;</description>
    <pubDate>Thu, 05 Nov 2026 20:06:44 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2026-11-05T20:06:44Z</dc:date>
    <item>
      <title>Idira Identity: Create a custom report to display users that have not configured a security question</title>
      <link>https://live.paloaltonetworks.com/t5/workforce-identity-articles/idira-identity-create-a-custom-report-to-display-users-that-have/ta-p/1428010</link>
      <description>This article explains the steps needed to create a custom report in the Admin Portal to display users that&amp;nbsp;have not configured a security question

&lt;H3&gt;Issue&lt;/H3&gt;
To get started, login to the Admin Portal and select Reports from the top menu. On the left side of the reports&amp;nbsp;page, click the "New Report" button. Give the report a name and optional description.&lt;BR /&gt;&lt;BR /&gt;For additional information on creating reports, please refer to the online help section "Creating a new report".&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;U&gt;&lt;B&gt;Example 1&lt;/B&gt;&lt;/U&gt;&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax&amp;nbsp;to create a report showing all users::&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;select UserName from User where ID not in (select UserGUID from Event where EventType = 'Cloud.Core.UserSecurityQuestionSet' and WhenOccurred &amp;gt;= DateFunc('now', '-999') )&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;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.&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;U&gt;&lt;B&gt;Example 2&lt;/B&gt;&lt;/U&gt;&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax to create a report showing only active users:&lt;BR /&gt;&lt;BR /&gt;select UserName from User&lt;BR /&gt;where ID not in&amp;nbsp;&lt;BR /&gt;&amp;nbsp;(select UserGUID from Event&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.UserSecurityQuestionSet'&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; and WhenOccurred &amp;gt;= DateFunc('now', '-999'))&lt;BR /&gt;and ID in&lt;BR /&gt;(select UserGUID from Event&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.Login'&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;and WhenOccurred &amp;gt;= DateFunc('now', '-30'))&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;If administrators wish to limit password reset mechanisms to only use the user-defined security question, you can set this&amp;nbsp;in cloud policy - again from within the Admin Portal. Expand the "Account Security Policies" and then "Password&amp;nbsp;Reset". De-select the options you do not wish to expose to end users.&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;For additional information not covered in this guide or troubleshooting assistance, please review Idira Identity Online Documentation.&lt;BR /&gt;&amp;nbsp;

&lt;H3&gt;Steps&lt;/H3&gt;
To get started, login to the Admin Portal and select Reports from the top menu. On the left side of the reports&amp;nbsp;page, click the "New Report" button. Give the report a name and optional description.&lt;BR /&gt;&lt;BR /&gt;For additional information on creating reports, please refer to the online help section "Creating a new report".&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;Example 1&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax&amp;nbsp;to create a report showing all users::
&lt;PRE class="ckeditor_codeblock"&gt;
select UserName from User where ID not in (select UserGUID from Event where EventType = 'Cloud.Core.UserSecurityQuestionSet' and WhenOccurred &amp;gt;= DateFunc('now', '-999') )
&lt;/PRE&gt;
&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;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.&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;Example 2&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax to create a report showing only active users:
&lt;PRE class="ckeditor_codeblock"&gt;
select UserName from User
where ID not in&amp;nbsp;
&amp;nbsp;(select UserGUID from Event&amp;nbsp;
&amp;nbsp;&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.UserSecurityQuestionSet'
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; and WhenOccurred &amp;gt;= DateFunc('now', '-999'))
and ID in
(select UserGUID from Event&amp;nbsp;
&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.Login'&amp;nbsp;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;and WhenOccurred &amp;gt;= DateFunc('now', '-30'))&amp;nbsp;&lt;/PRE&gt;
&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;If administrators wish to limit password reset mechanisms to only use the user-defined security question, you can set this&amp;nbsp;in cloud policy - again from within the Admin Portal. Expand the "Account Security Policies" and then "Password&amp;nbsp;Reset". De-select the options you do not wish to expose to end users.&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;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&amp;nbsp;have not configured a security question&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;To get started, login to the Admin Portal and select Reports from the top menu. On the left side of the reports&amp;nbsp;page, click the "New Report" button. Give the report a name and optional description.&lt;BR /&gt;&lt;BR /&gt;For additional information on creating reports, please refer to the online help section "Creating a new report".&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;U&gt;&lt;B&gt;Example 1&lt;/B&gt;&lt;/U&gt;&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax&amp;nbsp;to create a report showing all users::&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;select UserName from User where ID not in (select UserGUID from Event where EventType = 'Cloud.Core.UserSecurityQuestionSet' and WhenOccurred &amp;gt;= DateFunc('now', '-999') )&lt;/SPAN&gt;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;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.&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;U&gt;&lt;B&gt;Example 2&lt;/B&gt;&lt;/U&gt;&lt;BR /&gt;&lt;BR /&gt;In the report query field, copy and past the following syntax to create a report showing only active users:&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="font-family: courier new,courier,monospace;"&gt;select UserName from User&lt;BR /&gt;where ID not in&amp;nbsp;&lt;BR /&gt;&amp;nbsp;(select UserGUID from Event&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.UserSecurityQuestionSet'&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; and WhenOccurred &amp;gt;= DateFunc('now', '-999'))&lt;BR /&gt;and ID in&lt;BR /&gt;(select UserGUID from Event&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;where EventType = 'Cloud.Core.Login'&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;and WhenOccurred &amp;gt;= DateFunc('now', '-30'))&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;If administrators wish to limit password reset mechanisms to only use the user-defined security question, you can set this&amp;nbsp;in cloud policy - again from within the Admin Portal. Expand the "Account Security Policies" and then "Password&amp;nbsp;Reset". De-select the options you do not wish to expose to end users.&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;For additional information not covered in this guide or troubleshooting assistance, please review Idira Identity Online Documentation.&lt;BR /&gt;&amp;nbsp;</description>
      <pubDate>Thu, 05 Nov 2026 20:06:44 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/workforce-identity-articles/idira-identity-create-a-custom-report-to-display-users-that-have/ta-p/1428010</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2026-11-05T20:06:44Z</dc:date>
    </item>
  </channel>
</rss>

