The Server truncates data values within each audited event SQL transaction to ensure the data value fits within the corresponding database field. The following table lists selected field length values:
|
Tablename |
Fieldname |
Datatype/Field-length |
|
tbl_socketconnections |
SiteName |
Varchar (50) |
|
tbl_protocolcommands |
VirtualFolderName |
Varchar (500) |
|
|
PhysicalFolderName |
Varchar (500) |
|
|
SiteName |
Varchar (50) |
|
tbl_customCommands |
CommandParameters |
Varchar (1000) |
|
|
SiteName |
Varchar (50) |
|
tbl_ClientOperations |
RemotePath |
Varchar (500) |
|
|
LocalPath |
Varchar (500) |
|
|
UserName |
Varchar (50) |
|
tbl_Actions |
Parameters |
Varchar (1000) |
|
|
SiteName |
Varchar (50) |
|
tbl_EventRules |
SiteName |
Varchar (50) |
|
|
EventName |
Varchar (50) |
|
tbl_Authentications |
SiteName |
Varchar (50) |
|
|
UserName |
Varchar (50) |
Special Characters
The special characters (as defined by the SQL interpreter) within each data value of an audit SQL event are escaped to ensure the data value is stored and retrieved properly from the database. The following special characters are escaped by the Server during generation of SQL statements prior to submission to the database engine:
Single quote - %
Open brace - [
Percent - %
Underscore - _