Which users have not completed assigned training? 
Requires training data from KnowBe4 or similar.
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
Is there any user with AWS access that hasn't completed certain training? 
The following example specifies aws_iam_user
and knowbe4_user
, requiring AWS and KnowBe4 integrations.
Additionally, this requires proper mapping between User and Person entities.
Find aws_iam_user that is Person that is knowbe4_user that !completed Training with name='training name' or campaign='campaign name'
If SAML is used to connect an SSO user (e.g. Okta user) to an AWS IAM Role:
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
Is there any developer who has not completed "Secure Development" training? 
The following example specifies bitbucket_user
, github_user
, and knowbe4_user
, which requires Bitbucket or GitHub, in addition to KnowBe4 integrations.
Additionally, this requires proper mapping between User and Person entities.
Find (bitbucket_user|github_user) that is Person that is knowbe4_user that !completed Training with name='Secure Development' or campaign='Secure Development'
Comments
0 comments
Please sign in to leave a comment.