VMware Tunnel SQL Structure

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

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

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

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

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