Disclaimer
My postings are my own and don’t necessarily represent VMware’s positions, strategies or opinions.
Disclaimer
My postings are my own and don’t necessarily represent VMware’s positions, strategies or opinions.
ws1tunnel.TunnelConfiguration
Column | Description | Type of Data |
---|---|---|
Uuid | UUID based primary Key | uniqueidentifier |
Name | Name of the Tunnel Configuration | nvarchar(255) |
Enabled | If Tunnel Configuration is enabled or not | bit |
PacFileSupportEnabled | If PAC File Upload support is enabled or not | bit |
OrganizationGroupUuid | UUID based Organization Group Id | uniqueidentifier |
VpnVersion | Vpn Config version | nvarchar(255) |
VpnVersionUtcDateTime | VpnConfigVersionUtcDateTime | nvarchar(255) |
CreatedBy | Core user who created this record | uniqueidentifier |
CreatedOn | Created on Date | datetime |
ModifiedBy | Core user who modified this | uniqueidentifier |
ModifiedOn | Modified Date | datetime |
ws1tunnel.TunnelClientConfiguration
Column | Description | Type of Data |
---|---|---|
Uuid | UUID based primary Key | uniqueidentifier |
TunnelConfigUuid | Uuid of Tunnel Configuration | uniqueidentifier |
AuthenticationType | Authentication Type | int |
CertificateSource | VPN Certificate Source | nvarchar(255) |
CertificateAuthorityUuid | VPN CA Id. | uniqueidentifier |
CertificateTemplateUuid | Airwatch VPN CA Template Id. | uniqueidentifier |
ScepCertificateTemplateUuid | SCEP Certificate Template ID for Client Certificate for Tunne | uniqueidentifier |
ProfileScepCertificateTemplateUuid | the Airwatch CA template id for SCEP template with key 4096 | uniqueidentifier |
CreatedBy | Core user who created this record | uniqueidentifier |
CreatedOn | Created on Date | datetime |
ModifiedBy | Core user who modified this | uniqueidentifier |
ModifiedOn | Modified Date | datetime |
ws1tunnel.TunnelServerConfiguration
Column | Description | Type of Data |
---|---|---|
Uuid | UUID based primary Key for the table | uniqueidentifier |
TunnelConfigUuid | Uuid of Tunnel Configuration | uniqueidentifier |
AwCertificateThumbprint | VPN Certificate Thumbprint | nvarchar(255) |
AwIdentifier | Unique string for AWCM to identify an installation of AirWatch for VPN | nvarchar(1024) |
VpnIdentifier | Unique string for AWCM to identify an installation of VPN server | nvarchar(1024) |
TunnelConfigurationType | Whether VPN is in a standard or endpoint-relay configuration. | int |
EndpointHost | VPN server endpoint Host name | nvarchar(255) |
RelayEndpointPort | VPN server port | int |
VpnServerHostName | VPN server Host name | nvarchar(255) |
VpnServerPort | VPN server port | int |
PublicSslVPN | Whether to use a public SSL certificate for vpn. | bit |
LogLevel | VPN logging level | int |
ApiViaProxy | Whether to enable API and AWCM outbound calls via proxy. | bit |
AccessLogMode | AccessLogMode (rsyslog or file) | int |
EnableAccessLog | Vpn EnableAccessLog | bit |
VpnServerConnectionType | VPN server connection type | int |
SyslogHost | Syslog Hostname | nvarchar(255) |
SyslogPort | Syslog Port | int |
CreatedBy | Core user who created this record | uniqueidentifier |
CreatedOn | Created on Date | datetime |
ModifiedBy | Core user who modified this | uniqueidentifier |
ModifiedOn | Modified Date | datetime |
ws1tunnel.ConfigCertificateMapping
Column | Description | Type of Data |
---|---|---|
Uuid | UUID based primary Key for the table | uniqueidentifier |
TunnelConfigUuid | Reference Identifier to TunnelConfiguration table | uniqueidentifier |
CertificateUuid | UUID for Certificate | uniqueidentifier |
CertificateType | Certficate type | int |
IsActive | Actively used certificate | bit |
CreatedBy | User ID that created this record | uniqueidentifier |
CreatedOn | DateTime when the record was created in the DB | datetime |
ModifiedBy | User ID that modified this record | uniqueidentifier |
ModifiedOn | DateTime when the record was last modified in the DB | datetime |
ws1tunnel.TunnelTestConnectionStatus
Column | Description | Type of Data |
---|---|---|
Uuid | UUID based primary Key for the table | uniqueidentifier |
TunnelConfigUuid | Reference Identifier to TunnelConfiguration table | uniqueidentifier |
TestConnectionState | Current state of Test connection | nvarchar(20) |
TestConnectionInitiatedTime | Time at which test connection was initiated | datetime |
AWCMReachable | AWCM is Reachable or not | bit |
AWCMConnectionFailureReason | Reason for AWCMC not being reachable | nvarchar(50) |
TestConnectionResult | Test connection was successful or not | bit |
CreatedBy | Created by for the Test connection status record | uniqueidentifier |
CreatedOn | Created on for the Test connection status record | datetime |
ModifiedBy | Modified by for the Test connection status record | uniqueidentifier |
ModifiedOn | Modified on for the Test connection status record | datetime |