home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
moodle.waes.ac.uk
/
moodle.waes.ac.uk.zip
/
moodle.waes.ac.uk
/
TMG
/
SP1-TMG-KB981324-AMD64-ENU.msp
/
PCW_CAB_SHFx2
/
F2143_msfpcui.dll
/
BINARY
/
25096
< prev
next >
Wrap
Text File
|
2010-06-15
|
1KB
|
30 lines
CREATE PROCEDURE [ISA_spDroppedUserSummary]
AS
BEGIN
IF OBJECT_ID ('tblDroppedUserSummary', 'u') IS NOT NULL
DROP TABLE [tblDroppedUserSummary]
DECLARE @FromDate datetime
SET @FromDate = (SELECT [FromDate] FROM [tblSummaryParams])
IF OBJECT_ID ('FWS_LOGS', 'view') IS NOT NULL
BEGIN
SELECT
CASE
WHEN [ClientUserName] = '-' OR [ClientUserName] = 'SYSTEM' THEN '@\@' + CAST([OriginalClientIP] AS nvarchar(500))
ELSE [ClientUserName]
END as UserName,
COUNT(*) AS DroppedPackets,
@FromDate AS Date
INTO [tblDroppedUserSummary]
FROM FWS_LOGS
WHERE
([Action] = 8) AND
([InternalServiceInfo] & 2) = 0
GROUP BY
CASE
WHEN [ClientUserName] = '-' OR [ClientUserName] = 'SYSTEM' THEN '@\@' + CAST([OriginalClientIP] AS nvarchar(500))
ELSE [ClientUserName]
END
END
INSERT INTO [tblSummaryTables] ([TableName]) VALUES ('tblDroppedUserSummary')
END