KnowBe4 Tables

Tables

KnowBe4Groups

Name	Type	Description
ID	integer	Unique identifier for the group record
GroupID	integer	Unique identifier for the group
Name	string	The name of the group
GroupType	string	The type of the group (e.g., security, training)
ProvisioningGuid	string	The GUID used for provisioning the group
MemberCount	integer	The number of members in the group
CurrentRiskScore	float	The current risk score associated with the group
Status	string	The status of the group (e.g., active, inactive, pending)
ConfigID	integer	Unique identifier for the configuration record related to the group
BatchDate	datetime	The timestamp when the group record was added or updated in the batch process

KnowBe4PhishingSecurityTestGroups

Name	Type	Description
ID	integer	Unique identifier for the phishing security test group record
PhishingSecurityTestID	integer	Unique identifier for the phishing security test
GroupID	integer	Unique identifier for the group associated with the phishing security test
ConfigID	integer	Unique identifier for the configuration record related to the phishing security test group
BatchDate	datetime	The timestamp when the phishing security test group record was added or updated in the batch process

KnowBe4PhishingSecurityTests

Name	Type	Description
PstId	integer	Unique identifier for the phishing security test
ID	integer	Unique identifier for the phishing security test record
CampaignId	integer	Unique identifier for the campaign associated with the phishing security test
Status	string	The status of the phishing security test (e.g., completed, in progress, scheduled)
Name	string	The name of the phishing security test
PhishPronePercentage	float	The percentage of users that were prone to phishing (calculated based on user responses)
StartedAt	datetime	The timestamp when the phishing security test started
Duration	integer	The duration of the phishing security test (typically in minutes or hours)
ScheduledCount	integer	The number of scheduled recipients for the phishing security test
DeliveredCount	integer	The number of phishing emails delivered in the phishing security test
OpenedCount	integer	The number of phishing emails that were opened by recipients
ClickedCount	integer	The number of recipients who clicked on the phishing link
RepliedCount	integer	The number of recipients who replied to the phishing email
AttachmentOpenCount	integer	The number of recipients who opened an attachment in the phishing email
MacroEnabledCount	integer	The number of recipients who enabled macros in the attachment
DataEnteredCount	integer	The number of recipients who entered data (e.g., personal information) in the phishing form
QrCodeScannedCount	integer	The number of recipients who scanned a QR code in the phishing email
ReportedCount	integer	The number of recipients who reported the phishing email
BouncedCount	integer	The number of phishing emails that bounced (failed to be delivered)
ConfigID	integer	Unique identifier for the configuration record related to the phishing security test
BatchDate	datetime	The timestamp when the phishing security test record was added or updated in the batch process

KnowBe4TrainingCampaignGroups

Name	Type	Description
ID	integer	Unique identifier for the training campaign group record
TrainingCampaignID	integer	Unique identifier for the training campaign associated with the group
GroupID	integer	Unique identifier for the group associated with the training campaign
ConfigID	integer	Unique identifier for the configuration record related to the training campaign group
BatchDate	datetime	The timestamp when the training campaign group record was added or updated in the batch process

KnowBe4TrainingCampaigns

Name	Type	Description
ID	integer	Unique identifier for the training campaign record
CampaignId	integer	Unique identifier for the training campaign
Name	string	The name of the training campaign
Status	string	The status of the training campaign (e.g., active, completed, in progress)
DurationType	string	The type of duration for the campaign (e.g., fixed, relative)
StartDate	datetime	The timestamp when the training campaign started
EndDate	datetime	The timestamp when the training campaign ended
RelativeDuration	string	The relative duration of the training campaign (if applicable, e.g., days, weeks)
AutoEnroll	bit	Indicates whether auto-enrollment is enabled for the training campaign (bit value)
AllowMultipleEnrollments	bit	Indicates whether multiple enrollments are allowed for the same user in the training campaign (bit value)
CompletionPercentage	integer	The completion percentage of the training campaign (i.e., the percentage of users who completed the training)
ConfigID	integer	Unique identifier for the configuration record related to the training campaign
BatchDate	datetime	The timestamp when the training campaign record was added or updated in the batch process

KnowBe4TrainingEnrollments

Name	Type	Description
ID	integer	Unique identifier for the training enrollment record
EnrollmentId	integer	Unique identifier for the specific enrollment instance
ContentType	string	The type of content in the training (e.g., module, video, quiz)
ModuleName	string	The name of the module included in the training enrollment
CampaignName	string	The name of the campaign associated with the training enrollment
EnrollmentDate	datetime	The timestamp when the training enrollment was initiated
StartDate	datetime	The timestamp when the training actually started
CompletionDate	datetime	The timestamp when the training was completed
Status	string	The current status of the enrollment (e.g., in progress, completed, failed)
TimeSpent	integer	The total time spent by the user on the training module (usually in minutes or seconds)
PolicyAcknowledged	bit	Indicates whether the policy was acknowledged by the user (bit value)
ConfigID	integer	Unique identifier for the configuration record related to the training enrollment
Email	string	The email address of the user enrolled in the training
FirstName	string	The first name of the user enrolled in the training
LastName	string	The last name of the user enrolled in the training
UserId	string	The unique user identifier associated with the enrolled user
BatchDate	datetime	The timestamp when the training enrollment record was added or updated in the batch process

KnowBe4TrainingPolicies

Name	Type	Description
ID	integer	Unique identifier for the training policy record
PolicyId	integer	Unique identifier for the specific training policy
ContentType	string	The type of content for the training policy (e.g., video, module, quiz)
Name	string	The name of the training policy
MinimumTime	integer	The minimum time required to complete the training policy (typically in minutes)
DefaultLanguage	string	The default language set for the training policy
Status	string	The current status of the training policy (e.g., active, inactive)
ConfigID	integer	Unique identifier for the configuration record related to the training policy
BatchDate	datetime	The timestamp when the training policy record was added or updated in the batch process

KnowBe4UserGroups

Name	Type	Description
Id	integer	Unique identifier for the user group record
UserID	integer	Unique identifier for the user associated with the group
GroupID	integer	Unique identifier for the group
ConfigID	integer	Unique identifier for the configuration record related to the user group
BatchDate	datetime	The timestamp when the user group record was added or updated in the batch process

KnowBe4Users

Name	Type	Description
ID	integer	Unique identifier for the user record
UserId	integer	Unique identifier for the user in the system
EmployeeNumber	string	Employee number associated with the user
FirstName	string	The first name of the user
LastName	string	The last name of the user
JobTitle	string	The job title of the user
Email	string	The email address of the user
PhishPronePercentage	string	The percentage of the user that is prone to phishing based on historical behavior
PhoneNumber	string	The phone number associated with the user
Extension	string	The phone extension associated with the user
MobilePhoneNumber	string	The mobile phone number associated with the user
Location	string	The location or physical address of the user
Division	string	The division the user belongs to
ManagerName	string	The name of the user's manager
ManagerEmail	string	The email address of the user's manager
ProvisioningManaged	bit	Whether the user's provisioning is managed (true/false)
ProvisioningGuid	string	Unique identifier for the provisioning record
CurrentRiskScore	float	The current risk score assigned to the user
LastSignIn	datetime	The timestamp of the user's last sign-in
Status	string	The current status of the user (e.g., active, inactive)
Organization	string	The organization to which the user belongs
Department	string	The department the user belongs to
Language	string	The preferred language of the user
Comment	string	Any comments or additional notes related to the user
EmployeeStartDate	datetime	The date the user started their employment
ConfigID	integer	Unique identifier for the configuration record related to the user
BatchDate	datetime	The timestamp when the user record was added or updated in the batch process

Tables

KnowBe4Groups

KnowBe4PhishingSecurityTestGroups

KnowBe4PhishingSecurityTests

KnowBe4TrainingCampaignGroups

KnowBe4TrainingCampaigns

KnowBe4TrainingEnrollments

KnowBe4TrainingPolicies

KnowBe4UserGroups

KnowBe4Users

Learn more...