SQL filter for interface custom properties.

rajasekar

Hi All,

Any one help me to apply filter for interface custom property in below mention SQL report.

        DECLARE @StartDate DateTime

        DECLARE @EndDate DateTime

        SET @StartDate = ${FromTime}

        SET @EndDate = ${ToTime}

        SELECT Interfaces.InterfaceId,

        Nodes.NodeID,

        Nodes.Caption AS NodeName,

        Interfaces.Caption AS Interface_Caption,

        Maxbps_In90,

        Maxbps_Out90,

        Maxbps_In95,

        Maxbps_Out95,

        Maxbps_In99,

        Maxbps_Out99

        FROM Nodes

        INNER JOIN Interfaces ON Nodes.NodeID = Interfaces.NodeID

        INNER JOIN (

        SELECT InterfaceID,

        dbo.GetInBpsPercentile(InterfaceID, @StartDate, @EndDate,90) AS Maxbps_In90,

        dbo.GetOutBpsPercentile(InterfaceID, @StartDate, @EndDate,90) AS Maxbps_Out90,

        dbo.GetInBpsPercentile(InterfaceID, @StartDate, @EndDate,95) AS Maxbps_In95,

        dbo.GetOutBpsPercentile(InterfaceID, @StartDate, @EndDate,95) AS Maxbps_Out95,

        dbo.GetInBpsPercentile(InterfaceID, @StartDate, @EndDate,99) AS Maxbps_In99,

        dbo.GetOutBpsPercentile(InterfaceID, @StartDate, @EndDate,99) AS Maxbps_Out99

        FROM InterfaceTraffic

        WHERE InterfaceTraffic.DateTime >= @StartDate AND InterfaceTraffic.DateTime <= @EndDate

        GROUP BY InterfaceID

        ) TrafficStat

        ON Interfaces.InterfaceID = TrafficStat.InterfaceID

     

If i run this in web-base am getting the output if i run the same in report writer am not getting the out getting error. May i know the reason for this.

dgsmith80

Report Writer handles date time differently so I would stick with web reports unless you have a specific reason for wanting Report Writer?

I’ll take a look at the query when I’m in the office.