Airlock Tables
The Airlock integration uses the following tables
Tables
AirlockAgents
The AirlockAgents table keeps track of all devices (or "agents") connected to the system. Each agent represents a computer or server that is being monitored.
| Name | Type | Description |
|---|---|---|
| AgentID | string | Unique identifier for the agent. |
| AirlockGroupConfigID | integer | The ID of the configuration within Compyl. |
| BatchDate | datetime | The date and time data was synced to our database. |
| ClientVersion | string | Version of the client software installed on the agent. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| Domain | string | The network domain or device name the agent is associated with. |
| FreeSpace | string | Amount of free disk space available on the agent, typically in GB. |
| GroupID | string | Identifier for the group to which the agent belongs. |
| HostName | string | Hostname of the agent's machine. |
| IP | string | Public IP address of the agent's machine. |
| LastCheckIn | datetime | The last time the agent checked in with the system |
| OS | string | Operating system and version running on the agent. |
| PolicyVersion | string | The version of the security policy applied to the agent. |
| Status | string | The current status of the agent. |
| UserName | string | The username of the primary user of the agent's machine. |
AirlockAllowedApplications
The AirlockAllowedApplications table keeps track of applications that are permitted to run within the system. It helps ensure that only approved software is used, improving security and compliance.
| Name | Type | Description |
|---|---|---|
| ApplicationID | string | Unique identifier for the allowed application. |
| BatchDate | datetime | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| Name | string | The name of the allowed application. |
| Version | string | The version number of the application. |
AirlockBlocklists
The AirlockBlocklists table keeps a record of applications or services that are not allowed to run within the system. This helps protect the network by preventing unauthorized or potentially harmful software from being used.
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime | The date and time data was synced to our database. |
| BlocklistID | string | Unique identifier for the blocklist entry. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| Name | string | The name of the blocklisted application or service. |
AirlockGroups
The AirlockGroups table organizes agents into groups for better management and security enforcement.
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime | The date and time data was synced to our database. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| GroupID | string | Unique identifier for the Airlock group. |
| Hidden | integer | Indicates whether the group is hidden (0 = visible, 1 = hidden). |
| Name | string | The name of the Airlock group. |
| Parent | string | The parent group ID or reference. |
AirLockIntegrations
Table contains 0+ configurations a customer may have. (Don't think this table needs to be/should be on Readme)
| Name | Type | Description |
|---|---|---|
| BaseURL | string | Base URL used for calling the Salesforce API |
| CreatedBy | string | Email address of the user who created the integration configuration. |
| CreatedDate | datetime | The date and time the integration configuration was created. |
| ID | integer | Unique identifier for the integration configuration. |
| IsEnabled | bit | Whether this integration configuration is enabled or not. |
| ModifiedBy | string | Email address of the user who modified the integration configuration. |
| ModifiedDate | datetime | The date and time the integration configuration was updated. |
| Name | string | Name of the configuration. |
AirlockSVRActivities
The AirlockSVRActivities table keeps a record of important activities and tasks performed by the system or users.
| Name | Type | Description |
|---|---|---|
| BatchDate | datetime | The date and time data was synced to our database. |
| Checkpoint | string | A unique identifier or reference for the activity instance. |
| ConfigID | integer | The ID of the configuration within Compyl. |
| Datetime | datetime | The timestamp of when the activity occurred. |
| Description | string | A textual description of the activity that provides additional context |
| ID | integer | Unique identifier for each server activity record. |
| Task | string | The name of the task performed (e.g., "Repository Add", "Client Checkin"). |
| User | string | The user or system process that performed the task. |
Updated over 1 year ago