mockmyberet

OK>>> Did this make it into 10.3?????

So, some modifications to the code and I came up with a filter that can be added to a nodes list on a view: (SELECT CASE ISNULL(E.EventTime, 0) WHEN 0 THEN DATEDIFF(DAY, LastEvent.EventTime, GETDATE()) ELSE DATEDIFF(DAY, E.EventTime, GETDATE()) END AS DaysDown FROM Nodes N LEFT OUTER JOIN (SELECT NetworkNode, EventTime,…

With a few modifications, that was perfect.

Yeah, I've just started dabbling with SQL myself. It's pretty neat what you can pull out of the database.

The business intelligence engine places everything you type in the filter into the query's where clause. The 'Dup1.NodeID = Nodes.NodeID' is the key to tying this filter to the row returned by the engine's query. 'and Dup1.DynamicIP = 0' is to weed out potential matches because of dynamic IPs. 'group by Dup1.Node1' is…

Oh, you're trying to run this in the management studio, this is a filter for the website. The SQL is... select Dup1.* from Nodes AS Dup1 INNER JOIN Nodes AS Dup2 ON Dup1.NodeID <> Dup2.NodeID AND (Dup1.IP_Address = Dup2.IP_Address) and Dup1.DynamicIP = 0 order by Caption That is finding them by IP, this one will do it by…

What is your SQL server version?

It returns what all the joins that I have tried returns... everything that has data in the Events... but not all the down devices. Since the program prunes the Events at 30 days... there is no info in the events table for any device that has been down for more than 30 days. I have handled that in mine, but I realize making…

It (of course) depends on the data distribution... declare @Percentile as int = 95; declare @StartDate as datetime = DATEADD(day, -30,getdate()); declare @EndDate as datetime = getdate();Declare @ReferenceTemp TABLE(InterfaceID INT,InBPS DECIMAL(38,2),GetInBps95th DECIMAL(38,2),InDiff DECIMAL(38,2),InChange…

There's a WHOLE bunch of caveats to this... and assumptions... and problems with doing it this way, but it's pretty much the only way to do it (that I can see, analyzing the SWQL and the DB).

How about something like this? SELECT N.Caption, I.FullName, MAX(IT.In_Maxbps + IT.Out_Maxbps) AS MAX_Thru_bps, AVG(IT.In_Averagebps) AS AVG_In_bps, MIN(IT.In_Minbps) AS MIN_In_bps, MAX(IT.In_Maxbps) AS MAX_In_bps, AVG(IT.Out_Averagebps) AS AVG_Out_bps, MIN(IT.Out_Minbps) AS MIN_Out_bps, MAX(IT.Out_Maxbps) AS…

(SELECT GM.name FROM dbo.Containers G inner join dbo.ContainerMemberSnapshots GM on G.ContainerID = GM.ContainerID WHERE GM.EntityDisplayName = 'Node' AND G.Name = 'Windows' AND substring(GM.MemberUri,35,45) = Nodes.NodeID) IS NOT NULL -Drink me (put this in your filter)

We end up creating views that have many widgets that have the same filters for various items, such as devices with interfaces labeled with 'Verizon' in their name for all of our WAN routers.