USP_WSREQUESTLOG_INSERT

Parameters

Parameter	Parameter Type	Mode
@CLIENTAPP	nvarchar(50)	IN
@NTUSER	nvarchar(256)	IN
@CLIENTHOSTNAME	nvarchar(256)	IN
@CLIENTHOSTADDRESS	nvarchar(16)	IN
@REQUESTOK	bit	IN
@SECURITYPASSED	bit	IN
@REQUESTNAME	nvarchar(500)	IN
@REQUESTXML	nvarchar(max)	IN
@REPLYXML	nvarchar(max)	IN
@ERRORMSG	nvarchar(max)	IN
@WEBSERVERTIME	datetime	IN
@SERVERNAME	nvarchar(256)	IN
@REQUESTBYTES	int	IN

Definition

Copy




create procedure dbo.USP_WSREQUESTLOG_INSERT
(
    @CLIENTAPP nvarchar(50),  
    @NTUSER nvarchar(256),
    @CLIENTHOSTNAME nvarchar(256),
    @CLIENTHOSTADDRESS nvarchar(16),
    @REQUESTOK bit ,
    @SECURITYPASSED bit ,
    @REQUESTNAME nvarchar(500) ,
    @REQUESTXML nvarchar(max) ,
    @REPLYXML nvarchar(max),
    @ERRORMSG nvarchar(max),
    @WEBSERVERTIME datetime,
    @SERVERNAME nvarchar(256),
    @REQUESTBYTES int
)

 as

/* 
Called by the Blackbaud.AppFx.Server.RequestFilters.RequestLogFilter when it is enabled in web.config
*/

set nocount on

insert into dbo.WSREQUESTLOG
(
    CLIENTAPP,
    NTUSER,
    CLIENTHOSTNAME,
    CLIENTHOSTADDRESS,
    REQUESTOK,
    SECURITYPASSED,
    REQUESTNAME ,
    REQUESTXML ,
    REPLYXML ,
    ERRORMSG ,
    WEBSERVERTIME,
    SERVERNAME,
    REQUESTBYTES 
)

values 
(
    @CLIENTAPP,
    @NTUSER ,
    @CLIENTHOSTNAME ,
    @CLIENTHOSTADDRESS ,
    @REQUESTOK ,
    @SECURITYPASSED ,
    @REQUESTNAME  ,
    cast (@REQUESTXML as xml) ,
    cast (@REPLYXML as xml) ,
    @ERRORMSG  ,
    @WEBSERVERTIME ,
    @SERVERNAME ,
    @REQUESTBYTES
)

if @@error <> 0 return 1;
return 0;