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 >
Wrap
Text File
|
2010-06-15
|
669b
|
22 lines
CREATE PROCEDURE [dbo].[ISA_spMalwareActivity]
@ArrayName nvarchar(MAX),
@ServerName nvarchar(MAX),
@FromDate datetime,
@ToDate datetime,
@CollectionTime datetime
AS
BEGIN
IF OBJECT_ID ('dbo.[tblMalwareSummary_Daily]', 'u') IS NULL RETURN
BEGIN
SELECT
@ArrayName As ArrayName,
ThreatName,
ThreatLevel,
Incidents As ThreatIncidents,
@CollectionTime As CollectionTime
FROM dbo.[tblMalwareSummary_Daily] As o
WHERE (o.[date] >= @FromDate AND o.[date] <= @ToDate) And (isnull(o.[ServerName],@ServerName)=@ServerName)
END
END