Hi Guys
Sorry if this seems like quite a bit for my first post but a bit stuck with this one.
So i already have my report created in web-based report writer focusing on the In and out avg's of traffic as well as max in and out for specific interfaces.
I would like to add additional info but adding the daily graphs of the top 3 highest peaks adding in and out traffic together.
In SQL the result dates of this is what i would like to get daily graphs from.
###################
DECLARE @StartDate DateTime
DECLARE @EndDate DateTime
SET @StartDate = CONVERT(varchar,dateadd(d,-(day(dateadd(m,-1,getdate()-2))),dateadd(m,-1,getdate()-1)),106)
SET @EndDate = CONVERT(varchar,dateadd(d,-(day(getdate())),getdate()),106)
SELECT TOP 3 DateTime,
Out_Maxbps + In_Maxbps AS Total
FROM InterfaceTrafficByDays
INNER JOIN Interfaces ON (InterfaceTrafficByDays.InterfaceID = Interfaces.InterfaceID)
WHERE DateTime BETWEEN @StartDate AND @EndDate
AND
Interfaces.Fullname = 'Secondary_WAN'
ORDER By Total DESC
#########################
How can i get this working on the Web based report writer so i can have all the info in one report.
TIA
JackB
