InfosecIQ Tables

The InfoseqIQ integration uses the following tables

Tables

InfosecIQCampaignRuns

Name	Type	Description
ConfigID	int	The ID of the configuration within Compyl.
RunID	string	A unique identifier for CampaignRun.
CampaignID	string	A unique identifier of the Campaign associated with a CampaignRun.
Start	datetime	The datetime string representation of when CampaignRun started.
End	datetime	The datetime string representation of when CampaignRun ended.
RunNumber	int	A number specifying the run of this Campaign.
BatchDate	datetime	The sync date.

InfosecIQCampaignRunLearnerStats

Name	Type	Description
ConfigID	int	The ID of the configuration within Compyl.
EventID	string	A unique identifier for TimelineEvent.
Type	string	A type used to describe the Timeline Event. Enum: `added-to-group` `removed-from-group` `created-learner` `scheduled-in-phish-campaign` `scheduled-in-phish-campaign-run` `sent-phish-email` `phished-learner` `entered-data` `opened-attachment` `opened-phish` `started-phish-training` `completed-phish-training` `submitted-phishsim-email` `submitted-phishing-email` `scheduled-in-aware-campaign` `scheduled-in-aware-campaign-run` `started-aware-course` `started-aware-module` `completed-aware-module` `stopped-aware-course` `completed-aware-course` `started-aware-assessment` `completed-aware-assessment` `passed-aware-assessment` `failed-aware-assessment` `stopped-aware-assessment` `stopped-aware-module` `started-aware-reminder` `finished-aware-reminder` `enabled-macro` `fast-clicked` `accepted-policy` `changed-learner-status` `changed-defender-status` `replied` `matched-pattern` `core-behavior-score-changed` `adaptive-assessment-completed` `recommendation-completed` `recommendation-started`
TimeStamp	datetime	The datetime string representation of when the TimelineEvent occurred.
LearnerID	string	The unique id of the associated learner.
CampaignID	string	The unique id of the associated campaign.
QuarantinedEmailID	string	The unique id of the associated quarantined email.
ModuleID	string	The unique id of the associated module.
RunID	string	The unique id of the associated campaign run.
TemplateID	string	The unique id of the associated phish template.
LearnerGroupID	string	The unique id of the associated learner group.
AssessmentID	string	The unique id of the associated assessment.
BatchDate	datetime	The sync date.

InfosecIQCampaigns

Name	Type	Description
ConfigID	int	The ID of the configuration within Compyl.
CampaignID	string	A unique identifier for campaign.
Name	string	The Campaign name.
Type	string	The Campaign type.
Running	boolean	Whether the campaign is currently running.
BatchDate	datetime	The sync date.

InfosecIQLearnerGroups

Name	Type	Description
ConfigID	int	The ID of the configuration within Compyl.
GroupID	string	A unique identifier for the Learner Group.
Name	string	The Learner Group name.
Type	string	The Learner Group type.
Modified	string	The datetime string representation of when this Learner Group was last modified.
BatchDate	datetime	The sync date.

InfosecIQLearners

Name	Type	Description
ConfigID	int	The ID of the configuration within Compyl.
LearnerID	string	A unique identifier for the learner.
Email	string	The email address of the learner.
FirstName	string	The first name of the learner.
LastName	string	The last name of the learner.
Modified	datetime	The last modified timestamp of the learner.
BatchDate	datetime	The sync date.

InfosecIQLearnerStats

Name	Type	Description
ConfigID	int	The ID of the configuration within Compyl.
LearnerID	string	A unique identifier for the learner.
StatsId	string	Learner statistic id.
TrainingCompletedCount	int	Number of trainings completed.
PhishedCount	int	Number of times the learner was phished.
LetterGrade	string	" Letter grade of learner."
Grade	string	Number grade of learner.
BatchDate	datetime	The sync date.

InfosecIQTimelineEvents

Name	Type	Description
ConfigID	int	The ID of the configuration within Compyl.
RunID	string	A unique identifier for CampaignRun.
LearnerID	string	A unique identifier for Learner.
CompletedOn	string	A string representation of the learners completion date.
Status	string	The status of the learners course progress. Enum: "not_started" "started" "completed"
BatchDate	datetime	The sync date.

Bridge Tables

InfosecIQLearners_InfosecIQLearnerGroups

Name	Type	Description
LearnerID	string	A unique identifier for the learner.
GroupID	string	A unique identifier for the Learner Group.
ConfigID	int	The ID of the configuration within Compyl.

Updated over 1 year ago

Learn more...

Did this page help you?