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 / 25148 < prev    next >
Text File  |  2010-06-15  |  990b  |  31 lines
  1. CREATE PROCEDURE [dbo].[ISA_spIpsSummaryMonthly]
  2.     @CurrentMonthFirstDay datetime,
  3.     @CurrentMonthLastDay datetime,
  4.     @LastDailyToKeep datetime,
  5.     @LastMonthlyToKeep datetime
  6. AS
  7. BEGIN
  8.     SET NOCOUNT ON;
  9. -- move dailies to monthlies
  10.     INSERT INTO dbo.tblIpsSummary_Monthly
  11.     SELECT
  12.             [SignatureName] AS [SignatureName],
  13.             [Action] AS [Action],
  14.             SUM([Incidents]) AS [Incidents],
  15.             SUM([TotalBytes]) AS [TotalBytes],
  16.             @CurrentMonthFirstDay AS [Date],
  17.             '-' As [ServerName]
  18.     FROM dbo.tblIpsSummary_Daily
  19.     WHERE (Date >= @CurrentMonthFirstDay) AND
  20.           (Date <= @CurrentMonthLastDay)
  21.     GROUP BY
  22.             [SignatureName],
  23.             [Action]
  24. -- cleanup dailies
  25.     DELETE FROM [ISA_RS_Db].[dbo].[tblIpsSummary_Daily]
  26.     WHERE (Date < @LastDailyToKeep)
  27. -- cleanup monthlies
  28.     DELETE FROM [ISA_RS_Db].[dbo].[tblIpsSummary_Monthly]
  29.     WHERE (Date < @LastMonthlyToKeep)
  30. END
  31.