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/25081

Text File | 2010-06-15 | 1KB | 31 lines

CREATE PROCEDURE [ISA_spObjectTypeSummary]
AS
BEGIN
    SET NOCOUNT ON;
    IF OBJECT_ID ('tblObjectTypeSummary', 'u') IS NOT NULL
        DROP TABLE [tblObjectTypeSummary]
    DECLARE @FromDate datetime
    SET @FromDate = (SELECT [FromDate] FROM [tblSummaryParams])
    IF OBJECT_ID ('WEB_LOGS', 'view') IS NOT NULL
    BEGIN
        SELECT
            [mimetype] AS ObjectName,
            SUM([bytesrecvd]) AS BytesIn,
            SUM([bytessent]) AS BytesOut,
            SUM([bytesrecvd]) + SUM([bytessent]) AS TotalBytes,
            COUNT(*) AS Requests,
            @FromDate AS Date
        INTO [tblObjectTypeSummary]
        FROM WEB_LOGS
        WHERE
            ([InternalServiceInfo] & 2) = 0 AND
            ([Action] != 8) AND
            ([resultcode] != 13301) AND
            ([Action] != 10) AND
            ([objectsource] != 6)
        GROUP BY
            [mimetype]
    END
    INSERT INTO [tblSummaryTables] ([TableName]) VALUES ('tblObjectTypeSummary')
END