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 / 25562 < prev    next >
Text File  |  2010-06-15  |  669b  |  22 lines
  1. CREATE PROCEDURE [dbo].[ISA_spMalwareActivity]
  2.     @ArrayName nvarchar(MAX),
  3.     @ServerName nvarchar(MAX),    
  4.     @FromDate datetime, 
  5.     @ToDate datetime,
  6.     @CollectionTime datetime
  7. AS
  8. BEGIN
  9.     IF OBJECT_ID ('dbo.[tblMalwareSummary_Daily]', 'u') IS NULL RETURN
  10.     BEGIN
  11.         SELECT
  12.             @ArrayName As ArrayName,
  13.             ThreatName,
  14.             ThreatLevel,
  15.             Incidents As ThreatIncidents,
  16.             @CollectionTime As CollectionTime
  17.         FROM dbo.[tblMalwareSummary_Daily] As o
  18.         WHERE (o.[date] >= @FromDate AND o.[date] <= @ToDate) And (isnull(o.[ServerName],@ServerName)=@ServerName) 
  19.     END    
  20. END
  21.  
  22.