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 / 25086 < prev    next >
Text File  |  2010-06-15  |  856b  |  27 lines
  1. CREATE PROCEDURE [ISA_spHttpResponseSummary]
  2. AS
  3. BEGIN
  4.     IF OBJECT_ID ('tblHttpResponseSummary', 'u') IS NOT NULL
  5.         DROP TABLE [tblHttpResponseSummary]
  6.     DECLARE @FromDate datetime
  7.     SET @FromDate = (SELECT [FromDate] FROM [tblSummaryParams])
  8.     IF OBJECT_ID ('WEB_LOGS', 'view') IS NOT NULL
  9.     BEGIN
  10.         SELECT
  11.             [resultcode] AS Response,
  12.             COUNT(*) AS Requests,
  13.             @FromDate AS Date
  14.         INTO [tblHttpResponseSummary]
  15.         FROM WEB_LOGS
  16.         WHERE
  17.             ([InternalServiceInfo] & 2) = 0 AND
  18.             ([Action] != 8) AND
  19.             ([resultcode] != 13301) AND
  20.             ([Action] != 10) AND
  21.             ([objectsource] != 6)
  22.         GROUP BY
  23.             [resultcode];
  24.     END
  25.     INSERT INTO [tblSummaryTables] ([TableName]) VALUES ('tblHttpResponseSummary')
  26. END
  27.