Usergroup risk report

chjlarson

Can I use JupiterOne to create a high-level overview risk report of my organization's usergroups based on my user's KnowBe4 risk assessment?

Tony

You can query across UserGroups active users with the following query:

find UserGroup as g 
that HAS User with active=true 
that is Person that is knowbe4_user with active=true as k 
return g.displayName as GroupName, 
AVG(k.phishPronePercentage) as "Average Phishing Score", 
AVG(k.currentRiskScore) as RiskScore ORDER BY RiskScore DESC