Hi All,
Need an SQL query for subtraction of Average response Time of two Nodes for last week.
I have created one query for that. But its creating rows in terms of thousands.
select TOP 1000 ABC.AVG-DEF.AVG as AVERAGE , ABC.IP1 as IP_Address1 ,DEF.IP2 as IP_Address2 from (select a.NodeID ,a.IP_Address IP1, b.AvgResponseTime AVG from Nodes a, ResponseTime b WHERE
((DateTime BETWEEN dateadd(dd, -1, getdate()) and getdate())
AND
(
(a.IP_Address = 'x.x.x.x')
) and a.NodeID=b.NodeID)
) ABC , (select a.NodeID ,a.IP_Address IP2, b.AvgResponseTime AVG from Nodes a, ResponseTime b WHERE
((DateTime BETWEEN dateadd(dd, -1, getdate()) and getdate())
AND
(
(a.IP_Address = 'x.x.x.x')
) and a.NodeID=b.NodeID)
) DEF
I require the report on Day-basis. As per weekly basis , i should get 7 records only.
Please help ...
