Community
Questions Library
Docs
Blog
Events
Swag
Github
Slack
JupiterOne
Discussions
Release Notes
Contact Us
User Training and Awareness - AskJ1 Community
<main> <article class="userContent"> <h2 data-id="which-users-have-not-completed-assigned-training">Which users have not completed assigned training?</h2> <p><em>Requires training data from KnowBe4 or similar.</em></p> <pre class="code codeBlock" spellcheck="false" tabindex="0">Find Training as t that assigned as enrollment User as u where enrollment.completedOn = undefined return u.first_name, u.last_name, u.email, t.name </pre> <h2 data-id="is-there-any-user-with-aws-access-that-hasn-t-completed-certain-training">Is there any user with AWS access that hasn't completed certain training?</h2> <p><em>The following example specifies <code class="code codeInline" spellcheck="false" tabindex="0">aws_iam_user</code> and <code class="code codeInline" spellcheck="false" tabindex="0">knowbe4_user</code>, requiring AWS and KnowBe4 integrations.</em></p> <p><em>Additionally, this requires proper mapping between User and Person entities.</em></p> <pre class="code codeBlock" spellcheck="false" tabindex="0">Find aws_iam_user that is Person that is knowbe4_user that !completed Training with name='training name' or campaign='campaign name' </pre> <p>If SAML is used to connect an SSO user (e.g. Okta user) to an AWS IAM Role:</p> <pre class="code codeBlock" spellcheck="false" tabindex="0">Find aws_iam_role as r that assigned User as u that is Person as p that is knowbe4_user that !completed Training with name='training name' or campaign='campaign name' return r.displayName, u.displayName, p.displayName, p.email </pre> <h2 data-id="is-there-any-developer-who-has-not-completed-secure-development-training">Is there any developer who has not completed "Secure Development" training?</h2> <p><em>The following example specifies <code class="code codeInline" spellcheck="false" tabindex="0">bitbucket_user</code>, <code class="code codeInline" spellcheck="false" tabindex="0">github_user</code>, and <code class="code codeInline" spellcheck="false" tabindex="0">knowbe4_user</code>, which requires Bitbucket or GitHub, in addition to KnowBe4 integrations.</em></p> <p><em>Additionally, this requires proper mapping between User and Person entities.</em></p> <pre class="code codeBlock" spellcheck="false" tabindex="0">Find (bitbucket_user|github_user) that is Person that is knowbe4_user that !completed Training with name='Secure Development' or campaign='Secure Development' </pre> </article> </main>
.png)