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 / 25138 < prev    next >
Text File  |  2010-06-15  |  964b  |  33 lines
  1. CREATE PROCEDURE [dbo].[ISA_spMalwareUserSummaryMonthly] 
  2.     @CurrentMonthFirstDay datetime,
  3.     @CurrentMonthLastDay datetime,
  4.     @LastDailyToKeep datetime,
  5.     @LastMonthlyToKeep datetime
  6. AS
  7. BEGIN
  8.     SET NOCOUNT ON;
  9.  
  10. -- move dailies to monthlies
  11.     INSERT INTO dbo.tblMalwareUserSummary_Monthly
  12.     SELECT
  13.         [UserName], 
  14.         SUM([MalwareIncidents]) AS MalwareIncidents,
  15.         [MalwareInspectionAction] AS MalwareInspectionAction,
  16.         @CurrentMonthFirstDay AS Date
  17.     FROM dbo.tblMalwareUserSummary_Daily
  18.     WHERE (Date >= @CurrentMonthFirstDay) AND
  19.           (Date <= @CurrentMonthLastDay)
  20.     GROUP BY
  21.         [UserName],
  22.         [MalwareInspectionAction]
  23.  
  24. -- cleanup dailies
  25.     DELETE FROM [ISA_RS_Db].[dbo].[tblMalwareUserSummary_Daily]
  26.     WHERE (Date < @LastDailyToKeep)
  27.  
  28. -- cleanup monthlies
  29.     DELETE FROM [ISA_RS_Db].[dbo].[tblMalwareUserSummary_Monthly]
  30.     WHERE (Date < @LastMonthlyToKeep)
  31.  
  32. END
  33.