WSREQUESTLOG

The WSREQUESTLOG table is used to log web service request and reply message details.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
DATEADDED	datetime		Default = getdate()	The date the request message was received
CLIENTAPP	nvarchar(256)		Default = ''	The name of the client application issuing the request
NTUSER	nvarchar(256)		Default = ''	The name of the NT User issuing the request
CLIENTHOSTNAME	nvarchar(256)		Default = ''	The DNS name of the client machine that initiated the request
CLIENTHOSTADDRESS	nvarchar(16)		Default = ''	The IP address of the client that initiated the request
REQUESTOK	bit		Default = 0	True if the request was processed without error
SECURITYPASSED	bit		Default = 0	True if the request passed the request access check
REQUESTNAME	nvarchar(500)			The name of the web service request
REQUESTXML	xml	yes		The xml description of the request message
REPLYXML	xml	yes		The xml description of the reply message
ERRORMSG	nvarchar(max)		Default = ''	The error message if the request failed
WEBSERVERTIME	datetime			The time the request was logged according to the web server clock
SERVERNAME	nvarchar(256)		Default = ''	The name of the webserver that serviced the request
REQUESTBYTES	int		Default = 0	The size of the request payload in bytes

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_WSREQUESTLOG_DATEADDED	DATEADDED			yes
PK_WSREQUESTLOG	ID	yes	yes