I've edited one of the 90/95/99 percentile web reports that comes in Solarwinds by default, but trying to do a slight modification. I've added a custom property of "Agreement" to the interface. The report shows this, but I want the report to only show me interfaces with that agreement field not being NULL. This way I can have a report auto-generate of all our burstable billing customers directly to Sales without any manual intervention required. The value is "Interfaces.Agreement" at the start of the select, how would I make this only display lines with that not null?
DECLARE @StartDate DateTime
DECLARE @EndDate DateTime
SET @StartDate = ${FromTime}
SET @EndDate = ${ToTime}
SELECT
Interfaces.Agreement,
Nodes.Caption AS NodeName,
Interfaces.Caption AS Interface_Caption,
Maxbps_In95,
Maxbps_Out95
FROM Nodes
INNER JOIN Interfaces ON Nodes.NodeID = Interfaces.NodeID
INNER JOIN (
SELECT InterfaceID,
dbo.GetInBpsPercentile(InterfaceID, @StartDate, @EndDate,95) AS Maxbps_In95,
dbo.GetOutBpsPercentile(InterfaceID, @StartDate, @EndDate,95) AS Maxbps_Out95
FROM InterfaceTraffic
WHERE InterfaceTraffic.DateTime >= @StartDate AND InterfaceTraffic.DateTime <= @EndDate
GROUP BY InterfaceID
) TrafficStat
ON Interfaces.InterfaceID = TrafficStat.InterfaceID
