The expiry date of the certificate. Can be used to track the expiration of the web host certificates. When NULL, the expiry date was not provided by the user, when uploading the certificate.
The original name of the file, used to upload the certificate. Used only for reference purposes. When NULL, means that the user did not provide that information when uploading the certificate.
The unique Internet name of the host. Should NOT include protocol name and should NOT include any forward slashes. This is just the dot-separated host name.
Columns
Certificate_Contents
The contents of the web host certificate. NULL means to use the server system certificate.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
varbinary (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Certificate_Expiry_Date
The expiry date of the certificate. Can be used to track the expiration of the web host certificates. When NULL, the expiry date was not provided by the user, when uploading the certificate.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
date (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Certificate_Expiry_Date - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
GreaterThanOrLessThan
None
yes
yes
Certificate_Original_Filename
The original name of the file, used to upload the certificate. Used only for reference purposes. When NULL, means that the user did not provide that information when uploading the certificate.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
254
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
nvarchar(254) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Certificate_Original_Filename - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
Like
None
no
no
Certificate_Password
The password, which should be used to decrypt the certificate. NULL when the certificate has no password or the system certificate is used.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
2147483647
Order
2147483647
Ownership Reference
no
Pasword
yes
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
nvarchar(max) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Certificate_Type
The type of certificate uploaded. Currently, only PFX is supported.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
PFX
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
3
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
nvarchar(3)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Certificate_Type - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Notes
Property
Value
Attributes
IsLongString
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
2147483647
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
nvarchar(max) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Row_Version
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
timestamp
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Web_Host_Id
Property
Value
Auto Complete
no
Data Filter
no
Default Value
NewGuid
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
yes (order: 1)
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Web_Host_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Web_Host_Name
The unique Internet name of the host. Should NOT include protocol name and should NOT include any forward slashes. This is just the dot-separated host name.