0 Replies Latest reply on May 24, 2017 5:52 PM by royaltci

    Trying to add a sql filter for a custom property in Solorwinds  Network Monitor

    royaltci

      Trying to add a sql filter for a custom property
      called "IsTenant' to reduce the number of nodes listed during the query.
      Below is the updated sql query that says it has a "xxxxxxxx" error
      when testing in report writer but seems to work when using it in a Microsoft
      SQL workspace.

       

      SET NOCOUNT OFF SET ROWCOUNT 0 DECLARE @StartDate DateTime
      DECLARE @EndDate DateTime SET @StartDate = CAST((ROUND(CAST(GetDate() - 7 AS
      FLOAT), 0, 1)) as datetime) SET @EndDate = GetDate() SELECT
      Interfaces.InterfaceId, Nodes.NodeID, Nodes.Caption AS NodeName,
      Nodes.VendorIcon AS Vendor_Icon, Interfaces.Caption AS Interface_Caption,
      Interfaces.InterfaceIcon AS Interface_Icon, Maxbps_In95, Maxbps_Out95,
      Maxbps_95 FROM Nodes INNER JOIN Interfaces ON Nodes.NodeID = Interfaces.NodeID
      INNER JOIN ( SELECT InterfaceID, dbo.GetInBps95th(InterfaceID, @StartDate,
      @EndDate) AS Maxbps_In95, dbo.GetOutBps95th(InterfaceID, @StartDate, @EndDate)
      AS Maxbps_Out95, dbo.GetMaxBps95th(InterfaceID, @StartDate, @EndDate) AS
      Maxbps_95 FROM InterfaceTraffic WHERE InterfaceTraffic.DateTime >=
      @StartDate AND InterfaceTraffic.DateTime <= @EndDate SELECT InterfaceID,
      IsTenant FROM dbo.Interfaces WHERE IsTenant=1 GROUP BY InterfaceID )
      TrafficStat ON Interfaces.InterfaceID = TrafficStat.InterfaceID WHERE
      ${LIMITATION} ORDER BY NodeName, Interface_Caption .