USP_DATALIST_WEBERRORLOG

Parameters

Parameter	Parameter Type	Mode
@ALTERRORID	varchar(30)	IN
@ERRORMESSAGE	nvarchar(1000)	IN
@LOCALADDR	nvarchar(50)	IN
@REMOTEADDR	nvarchar(50)	IN
@SCRIPTNAME	nvarchar(200)	IN
@QUERYSTRING	nvarchar(250)	IN
@USERAGENT	nvarchar(100)	IN
@STARTTIME	datetime	IN
@ENDTIME	datetime	IN

Definition

Copy



create procedure dbo.USP_DATALIST_WEBERRORLOG(
    @ALTERRORID varchar(30) = NULL,
    @ERRORMESSAGE nvarchar(1000) = NULL,
    @LOCALADDR nvarchar(50) = NULL,
    @REMOTEADDR nvarchar(50) = NULL,
    @SCRIPTNAME nvarchar(200) = NULL,
    @QUERYSTRING nvarchar(250) = NULL,
    @USERAGENT nvarchar(100) = NULL,
    @STARTTIME datetime = NULL,
    @ENDTIME datetime = NULL
) as
    set nocount on;

    select top 200
        WEBERRORLOG.[ID],
        WEBERRORLOG.[ERRORMESSAGE],
        WEBERRORLOG.[ALTERRORID],
        WEBERRORLOG.[STACKTRACE],
        WEBERRORLOG.[USERID],
        WEBERRORLOG.[SITEID],
        WEBERRORLOG.[LOCALADDR],
        WEBERRORLOG.[REMOTEADDR],
        WEBERRORLOG.[SERVERNAME],
        WEBERRORLOG.[SCRIPTNAME],
        WEBERRORLOG.[QUERYSTRING],
        WEBERRORLOG.[USERAGENT],
        WEBERRORLOG.[FULLLOG],
        WEBERRORLOG.[DATEADDED]
    from 
        dbo.WEBERRORLOG
    where ALTERRORID = @ALTERRORID or (
        isnull(@ALTERRORID, '') = ''
        and (isnull(@ERRORMESSAGE, '') = '' or ERRORMESSAGE like '%' + @ERRORMESSAGE + '%')
        and (isnull(@LOCALADDR, '') = '' or LOCALADDR like '%' + @LOCALADDR + '%') 
        and (isnull(@REMOTEADDR, '') = '' or REMOTEADDR like '%' + @REMOTEADDR + '%') 
        and (isnull(@SCRIPTNAME, '') = '' or SCRIPTNAME like '%' + @SCRIPTNAME + '%') 
        and (isnull(@QUERYSTRING, '') = '' or QUERYSTRING like '%' + @QUERYSTRING + '%') 
        and (isnull(@USERAGENT, '') = '' or USERAGENT like '%' + @USERAGENT + '%') 
        and (isnull(@STARTTIME, '') = '' or DATEADDED >= @STARTTIME) 
        and (isnull(@ENDTIME, '') = '' or DATEADDED < @ENDTIME) )