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
/
25614
< prev
next >
Wrap
Text File
|
2010-06-15
|
2KB
|
39 lines
CREATE PROCEDURE [dbo].[ISA_spBranchCacheUtilizationRDL]
@FromDate datetime,
@ToDate datetime,
@ReportType varchar(10)
AS
BEGIN
DECLARE @SummTableName varchar(100)
SET @SummTableName = dbo.fnGetSummaryTableName('tblBranchCacheSummary', @FromDate, @ToDate, @ReportType)
-- will be used to create a pie chart (there will always be 2 entries)
CREATE TABLE #CacheUtilization
(
TrafficDirection nvarchar(64),
TrafficKB bigint
)
IF OBJECT_ID (@SummTableName, 'u') IS NOT NULL
BEGIN
DECLARE @strQuery varchar(8000)
SET @strQuery =
'SELECT
N''{[25295]}'' AS [TrafficDirection],
SUM(summary.[TMGCacheOutKB]) + SUM(summary.[HostedCacheOutKB]) AS [TrafficKB]
FROM ' + @SummTableName + ' AS summary
WHERE (summary.[date] >= ' + QUOTENAME(CONVERT(varchar, @FromDate, 126),CHAR(39)) + ' AND summary.[date] <= ' + QUOTENAME(CONVERT(varchar, @ToDate, 126),CHAR(39)) + ')
'
INSERT INTO #CacheUtilization
EXEC(@strQuery)
SET @strQuery =
'SELECT
N''{[25294]}'' AS [TrafficDirection],
SUM(summary.[TMGCacheInKB]) + SUM(summary.[HostedCacheInKB]) AS [TrafficKB]
FROM ' + @SummTableName + ' AS summary
WHERE (summary.[date] >= ' + QUOTENAME(CONVERT(varchar, @FromDate, 126),CHAR(39)) + ' AND summary.[date] <= ' + QUOTENAME(CONVERT(varchar, @ToDate, 126),CHAR(39)) + ')
'
INSERT INTO #CacheUtilization
EXEC(@strQuery)
END
SELECT * FROM #CacheUtilization
END